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 is suitable for testing purposes.

Note

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

Prerequisites

A test 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.com.

  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.windows.net/, 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://kustosamplefiles.blob.core.windows.net/samplefiles/StormEvents.csv?sv=2019-12-12&ss=b&srt=o&sp=r&se=2022-09-05T02:23:52Z&st=2020-09-04T18:23:52Z&spr=https&sig=VrOfQMT1gUrHltJ8uhjYcCequEcfhjyyMX%2FSc3xsCy4%3D' 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.

    Query results

Next steps