Create database shortcut for Azure Data Explorer database

This article describes how to create a database shortcut for an Azure Data Explorer Database.

Prerequisites

  • Access to a workspace in the Fabric capacity license mode (or) the Trial license mode with Contributor or higher permissions.
  • You need to have a contributor role or higher to the Azure Data Explorer cluster.
  1. Sign in to Microsoft Fabric.

  2. If you see Power BI at the bottom-left of the page, switch to the Fabric workload by selecting Power BI and then by selecting Fabric.

    Screenshot that shows how to switch to the Fabric workload.

  3. Select Real-Time on the left navigation bar.

    Screenshot that shows the Real-Time selected on the left navigation bar.

Launch Create Database Shortcut experience

  1. In the left pane, select Microsoft sources.

  2. From the Source drop-down menu, choose Azure Data Explorer.

    Screenshot that shows the selection of Azure Data Explorer on the Microsoft sources page.

  3. For Subscription, select an Azure subscription that contains the resource group with your Azure Data Explorer.

  4. For Resource group, select a resource group that has your Azure Data Explorer.

  5. For Region, select a location where your Azure Data Explorer is located.

  6. Hover over the name of the Azure Data Explorer you want to create a database shortcut for, and select the Create database shortcut button, or select the ellipsis (...), and then select Create database shortcut.

    Screenshot that shows the Create database shortcut menu.

Configure the new database shortcut

  1. Enter a name for your database shortcut.

  2. Choose an existing eventhouse or create a new one.

  3. If you create a new Eventhouse, select the workspace where you want the Eventhouse to be saved.

  4. The Source cluster URI is prepopulated based on the Azure Data Explorer you selected.

  5. Modify the default Cache policy. This step is optional.

  6. Select Create.

    Screenshot that shows the Create database shortcut window.

    Note

    The region of the selected source cluster and the workspace region must be the same. Additionally, ensure that the Azure Data Explorer cluster is running.

    Once the shortcut is created, you're taken to the Database details view of the new database shortcut.

    Screenshot that shows the Database details page.