Create a KQL queryset

In this article, you learn how to create a new KQL queryset. The KQL Queryset is the item used to run queries, view, and customize query results on data from different data sources, such as Eventhouse, KQL database, and more.

Prerequisites

• A workspace with a Microsoft Fabric-enabled capacity
• A KQL database with editing permissions and data

Create a KQL queryset

The KQL Queryset exists within the context of a workspace. A new KQL queryset is always associated with the workspace you're using when you create it.

1. Go to the desired workspace.

2. Select +New item.

   

   Select KQL Queryset. Use the search bar to filter by item type.

   

3. In the New KQL Queryset window, enter a unique name. You can use alphanumeric characters, underscores, periods, and hyphens. Special characters aren't supported.

   Note

   You can create multiple KQL Querysets in a single workspace.

4. Select Create.

5. In the OneLake data hub window that appears, select a KQL database to connect to your KQL queryset.

6. Select Connect. Alternatively, close theOneLake data hub window and use the +Add data source menu to connect to a different data source.

Open an existing KQL queryset

1. To access an existing KQL queryset, go to your workspace.

2. Optionally, you can reduce the number of items displayed by filtering on the item type. Select Filter > KQL Queryset.

   

3. Select the KQL queryset from the list of items that appear in the workspace.

Next step

Query data in a KQL queryset