Create a KQL database
Microsoft Fabric is in preview.
In Real-Time Analytics, you interact with your data in the context of databases. A single workspace can hold multiple databases, and each database can hold multiple tables.
In this article, you learn how to create a new KQL database. Once your KQL database has data, you can proceed to query your data using Kusto Query Language in a KQL queryset.
Create a new KQL database
Select New > KQL Database.
Enter your database name, then select Create.
The database name can contain alphanumeric characters, underscores, periods, and hyphens. Special characters aren't supported.
The KQL database has now been created within the context of the selected workspace.
The main page of your KQL database shows an overview of the contents in your database. The following table lists the available information.
|Created by||User name of person who created the database.|
|Region||Shows the region of the data and services.|
|Created on||Date of database creation.|
|Last ingestion||Date on which data was ingested last into the database.|
|Query URI||URI that can be used to run queries or to store management commands.|
|Ingestion URI||URI that can be used to get data.|
|OneLake folder||OneLake folder path that can be used for creating shortcuts. You can also activate and deactivate data copy to OneLake.|
|Compressed||Total size of compressed data.|
|Original size||Total size of uncompressed data.|
|Compression ratio||Compression ratio of the data.|
|Name||Lists the names of tables in your database. Select a table to see more information.|
|Size||Database size in megabytes. The tables are listed in a descending order according to the data size.|
|Most active users|
|Name||User name of most active users in the database.|
|Queries run last month||The number of queries run per user in the last month.|
|Recently updated functions|
|Lists the function name and the time it was last updated.|
|Recently used Querysets|
|Lists the recently used KQL queryset and the time it was last accessed.|
|Recently created data connections|
|Lists the data connection and the time it was created.|