Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest Fabric, Power BI, and SQL learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register todayThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
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:
To access the data in your KQL database in other Microsoft Fabric experiences, see One logical copy.
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.
Browse to an existing KQL database.
Select New > OneLake shortcut.
Under Internal sources, select Microsoft OneLake.
Select the data source you want to connect to, and then select Next.
Expand Tables, and select a specific table to connect to.
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.
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.
The OneLake shortcut has been created. You can now query this data.
To query data from the OneLake shortcut, use the external_table()
function.
external_table('
Shortcut name')
.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 |
Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest Fabric, Power BI, and SQL learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register todayTraining
Module
Work with Delta Lake tables in Microsoft Fabric - Training
Tables in a Microsoft Fabric lakehouse are based on the Delta Lake technology commonly used in Apache Spark. By using the enhanced capabilities of delta tables, you can create advanced analytics solutions.
Certification
Microsoft Certified: Fabric Data Engineer Associate - Certifications
As a Fabric Data Engineer, you should have subject matter expertise with data loading patterns, data architectures, and orchestration processes.
Documentation
Create a database shortcut - Microsoft Fabric
Learn how to create a database shortcut to data in another KQL Database or in Azure Data Explorer in Real-Time Intelligence.
Eventhouse OneLake Availability - Microsoft Fabric
Learn how to turn on KQL database data availability in OneLake.
Query acceleration for OneLake shortcuts - overview (preview) - Microsoft Fabric
Overview on learning how to use the query acceleration policy over OneLake shortcuts to improve query performance and reduce latency for external delta tables.