Note
Access to this page requires authorization. You can try signing in or .
Access to this page requires authorization. You can try .
Sample gallery
Real-Time Intelligence in Microsoft Fabric includes sample datasets in several formats and sizes so you can practice loading data and writing queries. When you load a dataset from the Real-Time Intelligence Sample Gallery, Fabric creates a new KQL database in your workspace, loads the dataset as a table, and creates an attached KQL queryset with sample queries for that dataset.
In this article, you learn how to load and query sample gallery data in Real-Time Intelligence.
Tip
To use the sample gallery to create an end-to-end real-time solution that shows how to stream, analyze, and visualize real-time data in a real-world context, see End-to-end sample.
Prerequisites
Get data
Tip
To use the sample gallery to create an end-to-end real-time solution that shows how to stream, analyze, and visualize real-time data in a real-world context, see End-to-end sample.
Select Workloads in the left navigation bar, and then select Real-Time Intelligence.
On the Real-Time Intelligence home page, in the Explore Eventhouse samples tile, select Select to open the gallery.
In the Real-Time Intelligence Sample Gallery window, select a sample scenario tile to load into your workspace. Fabric loads the data as a table in a KQL database and creates a KQL queryset with sample queries for the dataset.
👁 Screenshot of the Real-Time Intelligence sample gallery showing sample databases available for ingestion.
Note
You can also load data from the Real-Time Intelligence Sample Gallery into an existing KQL database as a table. In that case, Fabric loads the sample data without creating a KQL queryset with sample queries.
To load sample data without the sample queries, open an existing KQL database, and then select Get data > Sample.
Run queries
A query is a read-only request to process data and return results. You state the request in plain text, using a data-flow model that's easy to read, author, and automate. Queries always run in the context of a particular table or database. At a minimum, a query consists of a source data reference and one or more query operators applied in sequence, indicated visually by the use of a pipe character (|) to delimit operators.
For more information about Kusto Query Language (KQL), see Kusto Query Language (KQL) overview.
In the query editor window, place your cursor anywhere on the query text.
Select Run, or press + to run the query.
Review the results in the query results pane below the query editor. Notice the green check indicating the query completed successfully, and the time used to compute the query results.
Before you run any query or command, read the comments above it—they include important information.
👁 Screenshot of a sample KQL queryset showing sample queries for the Storm Events table.
Tip
Select Recall at the top of the query window to show the result set from the first query without rerunning the query. During analysis, you might run multiple queries, and Recall lets you retrieve previous results.
Clean up resources
Clean up the items by going to the workspace where you created them.
In your workspace, hover over the KQL database or KQL queryset that you want to delete, and then select More menu [...] > Delete.
Select Delete. You can't recover deleted items.
Related content
Feedback
Was this page helpful?