StormEvents | summarize TotalDamage = sum(DamageProperty) by State
You cannot query data until it is ingested. In Synapse Data Explorer, there are two main ways to do this: learn azure synapse data explorer pdf
