Edit

Share via


Create OneLake shortcuts in a KQL database

OneLake is a single, unified, logical data lake for Microsoft Fabric to store lakehouses, warehouses, KQL databases, and other items. Shortcuts are embedded references within OneLake that point to other files' store locations without moving the original data. The embedded reference makes it appear as though the files and folders are stored locally but in reality; they exist in another storage location. Shortcuts can be updated or removed from your items, but these changes don't affect the original data and its source.

In this article, you learn how to create a OneLake shortcut in a KQL database that points to internal Fabric or external sources. This kind of shortcut is later accessed for query in KQL querysets by using the external_table() function. Shortcuts created in a KQL database can't be renamed, and only one shortcut can be created at a time.

In addition to creating shortcuts from a KQL database, shortcuts can also be created from other Fabric items. These shortcuts also point to data stored in internal Fabric or external sources, but have different limitations and are accessed differently. For more information, see OneLake shortcuts.

Note

To accelerate queries over OneLake shortcuts, see Accelerate queries over OneLake shortcuts.

Select the tab that corresponds to the shortcut you'd like to create:

Prerequisites

To access the data in your KQL database in other Microsoft Fabric experiences, see One logical copy.

Create shortcut

Note

The following flow shows how to create a shortcut that points to data in a Lakehouse in Fabric. Similarly, you can create shortcuts that point to Data Warehouses or other KQL databases.

  1. Browse to an existing KQL database.

  2. Select New > OneLake shortcut.

    Screenshot of the Home tab showing the dropdown of the New button. The option titled OneLake shortcut is highlighted.

Select a source

  1. Under Internal sources, select Microsoft OneLake.

    Screenshot of the New shortcut window showing the two methods for creating a shortcut. The option titled OneLake is highlighted.

  2. Select the data source you want to connect to, and then select Next.

    Screenshot of the Select a data source type window showing the available data sources to use with the shortcut. The Next button is highlighted.

  3. Expand Tables, and select a specific table to connect to.

    Screenshot of new shortcut where tables are expanded and one table is selected.

  4. Select Next.

Note

To enable query acceleration on a new shortcut, toggle the Accelerate button to On. For more information, see Accelerate queries over OneLake shortcuts.

Screenshot of the New shortcut window showing the data in the LakeHouse. The subfolder titled StrmSC and the Create button are highlighted.

  1. Select Create.

Note

You can only connect to one subfolder or table per shortcut. To connect to more data, repeat these steps and create additional shortcuts.

The database refreshes automatically. The shortcut appears under Shortcuts in the Explorer pane.

Screenshot of the Explorer pane showing the new shortcut.

The OneLake shortcut has been created. You can now query this data.

Query data

To query data from the OneLake shortcut, use the external_table() function.

  1. On the rightmost side of your database, select Explore your data. The window opens with a few example queries you can run to get an initial look at your data.
  2. Replace the table name placeholder with external_table('Shortcut name').
  3. Select Run or press Shift + Enter to run a selected query.

Screenshot of the Explore your data window showing the results of an example query.

Data types mapping

Delta parquet to Eventhouse data types mapping

Delta primitive data types are mapped to Eventhouse scalar data types using the following rules. For more information on Eventhouse data types, see Scalar data types.

Delta Type Eventhouse Scalar Data Type
string string
long long
integer int
short int
byte real
float real
double real
decimal decimal
boolean bool
binary string
date datetime
timestamp_ntz (without time zone) datetime
struct dynamic
array dynamic
map dynamic