Quickstart: Create an Azure Data Explorer cluster and database
Azure Data Explorer is a fast, fully managed data analytics service provided by Microsoft.
It simplifies complex data exploration by enabling users to analyze large volumes of data streaming from applications, websites, IoT devices, and more.
It’s capable of handling many petabytes of data and allows quick data retrieval for analytical purposes.
In order to use the Azure Data Explorer we have to create a cluster, and then create at least one database in that cluster. Then we can run queries.
Fill out the fields below.
Select my cluster from the left hand menu
Under “actions” select create under the create DB panel
Enter “TestDatabase” for the database name
And then create the database
Even though we don’t have data for a database we can still run commands.
You will see a “Query” data panel. Select this and paste “.show databases”
Then select run (in blue)
There won’t be any results yet!
Ingest sample data into Azure Data Explorer
Now lets load data into our Azure Data explorer database
We are going to use the StormEvents sample data set which contains weather-related data
https://dataexplorer.azure.com/
- select “query” from the left hand side
- right click on the database you want to use
- Then select “ingest data”
- Fill out the following fields below
- Select “source”
Fill out the following fields below
Select “Blob” as the source type
Copy this link below and insert it in “Link to source”
https://kustosamples.blob.core.windows.net/samplefiles/StormEvents.csv
Then select “Schema”
Confirm the details below and click
“start ingestion”
Lets run a query against the data we have
After the ingestion is completed, select “query” from left hand panel
Paste in the fields below:
StormEvents
| sort by StartTime desc
| take 10
Select “run” in blue
You can see the results below.
We sorted by start time in DESC order, 10 at a time.