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.

Note

You already have this data if you completed Ingest data using the Azure Data Explorer Python library.

Prerequisites

• A Microsoft account or an Azure Active Directory user identity. An Azure subscription isn't required.
• An Azure Data Explorer cluster and database. You can create a free cluster or create a full cluster. To decide which is best for you, check the feature comparison.

Ingest data

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

First, sign in to https://dataexplorer.azure.com. Then follow the steps to ingest the sample data.

Ingest with wizard

1. In the left menu, select Data.

   

2. In the Data Management page, select Ingest data from blob, and then Ingest.

3. In the Destination tab, fill out the following information:

   

   Setting	Description
   Cluster	Select your cluster.
   Database	Choose a database.
   Table	Create a new table. For this example, name it StormEvents.

4. Select Next: Source.

5. Fill out the Source tab with the following information:

   

   Setting	Description
   Source type	Select the data source to ingest. In this example, From blob is already selected.
   Link to source	Use the following storage URI link: https://kustosamples.blob.core.windows.net/samplefiles/StormEvents.csv.

6. Select Next: Schema.

7. Confirm the schema details.

   

   Setting	Description
   Compression type	The compression type is inferred from the file extension.
   Data format	The data format, CSV, is already specified.
   Ignore the first record	If the source table includes column names, the first record is ignored during ingestion.
   Mapping	Schema mapping name.

8. Select Next: Summary.

9. After ingestion completes, select Query in the left pane.

   

10. Paste in the following query and select Run.

    StormEvents
    | sort by StartTime desc
    | take 10
    

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

    

Ingest with command

1. In the left menu, select Query. In the upper-left of the application, select Add cluster.

   

2. In the Add cluster dialog box, enter your cluster URL in the form https://<ClusterName>.<Region>.kusto.windows.net/, then select Add.

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

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

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

5. After ingestion completes, paste in the following query 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.