Skip to content

Latest commit

 

History

History
57 lines (38 loc) · 2.5 KB

ingest-sample-data.md

File metadata and controls

57 lines (38 loc) · 2.5 KB
title description services author ms.author ms.reviewer ms.service ms.topic ms.date
Ingest sample data into Azure Data Explorer
Learn about how to ingest (load) weather-related sample data into Azure Data Explorer.
data-explorer
orspod
v-orspod
mblythe
data-explorer
conceptual
09/24/2018

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 Quickstart: 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.

    .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 h'https://kustosamplefiles.blob.core.windows.net/samplefiles/StormEvents.csv?st=2018-08-31T22%3A02%3A25Z&se=2020-09-01T22%3A02%3A00Z&sp=r&sv=2018-03-28&sr=b&sig=LQIbomcKI8Ooz425hWtjeq6d61uEaq21UVX7YrM61N4%3D' with (ignoreFirstRecord=true)

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

Write queries

Azure Data Explorer data ingestion