Create a database shortcut

A database shortcut in Real-Time Intelligence is an embedded reference within a KQL database to a source database. The source database can be one of the following types:

• A KQL Database in Real-Time Intelligence
• An Azure Data Explorer database

The behavior of the database shortcut is similar to that of a follower database.

When is a database shortcut useful?

If you have data in an Azure Data Explorer database and want to use this data in Real-Time Intelligence, create a database shortcut to expose this data. This feature is also useful to segregate compute resources to protect a production environment from nonproduction use cases. You can also use a database shortcut to associate the costs with the party that runs queries on the data.

How does a database shortcut work?

The owner of the source database, the data provider, shares the database with the creator of the shortcut in Real-Time Intelligence, the data consumer. The owner and the creator can be the same person.

The database shortcut connects in read-only mode, so you can view and run queries on the data that the source Azure Data Explorer database ingested. The database shortcut synchronizes changes in the source database. Because of the synchronization, there's a data lag of a few seconds to a few minutes in data availability. The length of the time lag depends on the overall size of the source database metadata.

The source and database shortcuts use the same storage account to fetch the data. The source database owns the storage. The database shortcut views the data without needing to ingest it. Since the database shortcut is a read-only database, you can't modify the data, tables, and policies in the database except for caching policy, principals, and permissions.

Create database shortcut

A data consumer can create a database shortcut in Real-Time Intelligence from any source database in Azure Data Explorer by using an invitation link, or by using a cluster URI and database name. The data consumer can control how much data is cached by setting the cache policy. The main implications of setting the hot cache policy are:

• Cost: The cost of cold cache can be dramatically lower than the cost of hot cache.
• Performance: Data in hot cache is queried faster, particularly for range queries that scan large amounts of data.

Important

The database shortcut setup requires a high level of trust between the involved parties, such as the leader database and the database shortcut (follower). You can establish the database shortcut even if the leader cluster is behind a virtual network (VNet) or has public access disabled. Ensure that you thoroughly review and accept the security posture of this setup.

Select the tab that corresponds with the way you'd like to create a shortcut.

Use a cluster URI

Prerequisites

• A workspace with a Microsoft Fabric-enabled capacity.
• A source database. This database can be an Azure Data Explorer database or a KQL Database.
• An eventhouse.

Important

Both the source database and the database shortcut in Real-Time Intelligence must be in the same region, but they can be in different tenants.

Important

This method works with sources both in Azure Data Explorer and in Real-Time Intelligence.

Create a shortcut with a cluster URI

To create a shortcut by using a cluster URI and database name, make sure you have at least contributor permissions on the source data, and then follow these steps:

1. Browse to your workspace in Microsoft Fabric.

2. Open a new or existing eventhouse in Real-Time Intelligence.

3. Select the plus sign next to KQL databases.

4. Enter a name for your database shortcut.

5. Select Type > New shortcut database (Follower).

   

6. Select Next.

7. Select Method > Cluster URI.

8. Enter the URI of the source cluster. To find the URI of a KQL Database, see Copy URI.

9. Specify the source Database.

10. Optionally, modify the default cache policy.

    

11. Select Create.

Use an invitation link

Important

This method works only when the source database is in Azure Data Explorer.

Prerequisites

• A workspace with a Microsoft Fabric-enabled capacity.
• A source database. This database can be an Azure Data Explorer database or a KQL Database.

Important

Both the source database and the database shortcut in Real-Time Intelligence must be in the same region, but they can be in different tenants.

Create an invitation token

A data consumer who wants to create a database shortcut by using invitation tokens must get a token from the data provider. A token is a code that lets a data consumer create a shortcut to the source database. You don't need a token if you create a database shortcut by using the cluster URI method.

To create an invitation token, the data provider can use the following steps:

1. Go to the Azure portal.

2. Go to the Azure Data Explorer database you want to use as the source.

3. Select Share.

   

4. Enter the recipient email address. This address should be the email address associated with the Fabric user account in which you later create the database shortcut. This email address can be your own, or someone else's.

5. Choose one of the following options to create a link for a new shortcut.

   Use a link to create a shortcut as it opens the New database shortcuts dialog box and autopopulates the Source cluster URI and Database name from the information in the invitation token.

   • If you used your own email address to create the token and want to create the shortcut immediately, select Open link.
   • Otherwise, select Copy link. The person who the token is for can later paste this link into a browser to create the shortcut.

   

   Note

   You can also choose to manually create the shortcut. To do so, select Copy token. Go to your workspace, select + New > KQL Database, and then select Type > New shortcut database (Follower). Select Method > Invitation token, in Invitation token paste the token, and then select Create.

Use the invitation token

Use the link to open Real-Time Intelligence showing the New database shortcut dialog box, and then follow these steps:

1. Enter a name for your database shortcut.

2. Specify the Workspace in which you want to create the database shortcut.

3. Optionally, modify the default cache policy.

4. Check that the Invitation token is populated with the token you created and verified.

   

5. Select Create.

When you create the shortcut, you're taken to the database details view of the new database shortcut.

Delete database shortcut

1. Within your workspace, find the KQL database shortcut you want to delete.

2. Select the More menu [...] > Delete.

   

You deleted your database shortcut. Once you delete a database, you can't recover it. However, you can create a new database shortcut from the same source database.

Related content

• Query data in a KQL queryset
• Create a KQL database