.create table StormEvents (StartTime: datetime, EndTime: datetime, EpisodeId: int, EventId: int, State: string, EventType: string, InjuriesDirect: int, InjuriesIndirect: int, DeathsDirect: int, DeathsIndirect: int, DamageProperty: int, DamageCrops: int, Source: string, BeginLocation: string, EndLocation: string, BeginLat: real, BeginLon: real, EndLat: real, EndLon: real, EpisodeNarrative: string, EventNarrative: string, StormSummary: dynamic)

.ingest into table StormEvents 'https://raw.githubusercontent.com/CloudBreadPaPa/adx-sample-dataset-stormevents/main/dataset/StormEvents.csv' with (ignoreFirstRecord=true)

StormEvents
| sort by StartTime desc
| take 10