Creating a Kusto Query Language (KQL) database
Like other databases, a KQL database organizes tables, materialized views, and functions. It is also the entry point where a user will go to access the data, whether that is by using the Fabric UX, Azure Data Explorer, or even Azure Data Studio. A Fabric workspace can hold multiple KQL databases. The KQL database that is created in this section will be used to store the stock exchange data generated later in this chapter.
Fabric has a core concept of storing a single copy of the data, which can then be used across all the compute engines. By default, the data in a KQL database is only accessible from the RTA experience. To allow the other Fabric experiences access to the data, it is necessary to enable the OneLake folder policy at the database level, which we will do later in this chapter. After enabling, all new tables created and populated are visible in OneLake and accessible through other Fabric experiences. This policy will be...
