Edit

Share via

Query acceleration over OneLake shortcuts (preview)

  • Article

This article explains how to use the query acceleration policy to accelerate queries over OneLake shortcuts in the Microsoft Fabric UI. To set this policy using commands, see query acceleration policy. For general information on the query acceleration over OneLake shortcuts, see Query acceleration over OneLake shortcuts - overview (preview).

Important

This feature is in preview.

Note

If you have compliance considerations that require you to store data in a specific region, make sure your Eventhouse capacity is in the same region as your external table or shortcut data.

Prerequisites

Enable query acceleration on a new shortcut

Query acceleration can be enabled during shortcut creation, or on existing shortcuts. To enable query acceleration on a new shortcut, follow these steps:

  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.

  1. Toggle the Accelerate button to On.

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

  2. Select Create.

Enable query acceleration on an existing shortcut

  1. Browse to the shortcut you want to accelerate.
  2. In the menu bar, select Manage > Data policies.
  3. In the data policy pane, toggle the Query acceleration button to On.

Set caching period

Query acceleration is applied to data within a specific time period, defined as a timespan in days, starting from the modificationTime in the delta log.

The default caching period is that of the database in which the OneLake shortcut has been created. To set this policy using commands, see query acceleration policy. To set the caching period in the UI, follow these steps:

  1. Browse to the shortcut you want to accelerate.

  2. In the menu bar, select Manage > Data policies.

  3. In the data policy pane, enter the number of days for which data will be cached.

    Screenshot of the data policy for query acceleration.

Related content