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:

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

The behavior exhibited by 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, you can 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. A database shortcut can also be used 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 is attached in read-only mode, making it possible to view and run queries on the data that was ingested into the source Azure Data Explorer database. 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 storage is owned by the source database. The database shortcut views the data without needing to ingest it. Since the database shortcut is a read-only database, the data, tables, and policies in the database can't be modified 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 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 setting the hot cache policy are:

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

Select the desired 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 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 can be in different tenants.

Important

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

To create a shortcut 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 only works when the source database is in Azure Data Explorer.

Prerequisites

• A workspace with a Microsoft Fabric-enabled capacity
• A source database. This 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 can be in different tenants.

Create an invitation token

A data consumer who wants to create a database shortcut using invitation tokens must obtain 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 using the cluster URI method.

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

1. Browse to the Azure portal.

2. Browse to the Azure Data Explorer database you wish to use as 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 may be your own, or someone else's.

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

   We recommend using a link to create a shortcut as it opens the New database shortcuts dialog box and with the Source cluster URI and Database name autopopulated 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 was created for can later paste this link into a browser to create the shortcut.

   

   Note

   Optionally, you can 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.

Once the shortcut is created, 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 wish to delete.

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

   

Your database shortcut has now been deleted. Once a database is deleted, it can't be recovered. You can, however, create a new database shortcut from the same source database.

Related content

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