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.
  • Create a cluster and database.

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.

  1. In the left menu, select Data.

    Screenshot of the Azure Data Explorer web UI to ingest data from blob.

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

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

    Screenshot of the Azure Data Explorer web UI where you select ingestion cluster and database and select an existing or new table name. Specify table name.

    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:

    Screenshot of the Azure Data Explorer web UI where you select source for ingestion and provide list of source URIs or containers.

    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.

    Screenshot of the Azure Data Explorer web UI where you define the schema for ingestion, whether data is uncompressed, and structure of table.

    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.

    Screenshot of the Azure Data Explorer web UI where you select the Query pane from the menu.

  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.

    Screenshot of the Azure Data Explorer web UI where you select the query results for the ingested sample data.

Next steps