Edit

Share via

Create a OneLake shortcut

  • Article

In this article, you learn how to create a OneLake shortcut inside a Fabric lakehouse. You can use a lakehouse, a data warehouse, or a Kusto Query Language (KQL) database as the source for your shortcut.

For an overview of shortcuts, see OneLake shortcuts. To create shortcuts programmatically, see OneLake shortcuts REST APIs.

Prerequisite

If you don't have a lakehouse, create one by following these steps: Create a lakehouse with OneLake.

Create a shortcut

  1. Open a lakehouse.

  2. Right-click on a directory within the Explorer pane of the lakehouse.

  3. Select New shortcut.

    Screenshot showing where to select New shortcut from the Lake view.

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 Files or Tables, and select one or more subfolders to connect to, then select Next.

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

  4. Review your selected shortcut locations. Use the edit action to change the default shortcut name. Use the delete action to remove any undesired selections. Select Create to generate shortcuts.

    Screenshot of the New shortcut window showing selected shortcut locations and providing the option to delete or rename selections.

  5. Select Close.

Note

You can select up to 50 subfolders when creating OneLake shortcuts.

The lakehouse automatically refreshes. The shortcut(s) appears under the selected directory in the Explorer pane. You can differentiate a regular file or table from the shortcut from its properties. The properties have a Shortcut Type parameter that indicates the item is a shortcut.

Screenshot showing a Lake view list of folders that display the shortcut symbol.

Remove a shortcut

To delete a shortcut, select the ... icon next to the shortcut file or table and select Delete. To delete shortcuts programmatically, see OneLake shortcuts REST APIs

Related content