Quickstart: Ingest sample data into Azure Data Explorer

This article shows you how to ingest (load) sample data into an Azure Data Explorer database. There are several ways to ingest data. This article focuses on a basic approach that's suitable for testing purposes.

Prerequisites

• An Azure subscription. Create a Azure account.
• Create a cluster and database.

Ingest data

The StormEvents sample data set contains weather-related data from the National Centers for Environmental Information.

1. Sign in to https://dataexplorer.azure.cn.

2. In the upper-left of the application, select Add cluster.

3. In the Add cluster dialog box, enter your cluster URL in the form https://<ClusterName>.<Region>.kusto.chinacloudapi.cn/, then select Add.

4. Paste in the following command, and select Run to create a StormEvents table.

   .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)
   

5. Paste in the following command, and select Run to ingest data into StormEvents table.

   .ingest into table StormEvents 'https://kustosamples.blob.core.chinacloudapi.cn/samplefiles/StormEvents.csv' with (ignoreFirstRecord=true)
   

6. After ingestion completes, paste in the following query, select the query in the window, and select Run.

   StormEvents
   | sort by StartTime desc
   | take 10
   

   The query returns the following results from the ingested sample data.

   

Next steps

• Azure Data Explorer data ingestion to learn more about ingestion methods.
• Quickstart: Query data in Azure Data Explorer Web UI.
• Write queries with Kusto Query Language.