Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
abhiram342
Microsoft Employee
Microsoft Employee

KQL Shortcut OneLake Option Missing

Hi there - We want to process data from Azure Data Explorer (Kusto). using Spark. I have created shortcut using this Create a database shortcut - Microsoft Fabric | Microsoft Learn . However, I don't see option for creating shorcut on top of KQL Shortcut database i.e I want to access this data under Lakehouse using externaltable option in order to process using spark.

 

Created ShortCut using Azure Data Explorer (Kusto).  Create a database shortcut - Microsoft Fabric | Microsoft Learn

abhiram342_3-1704752381739.png

 

 

OneLakeAvailability Option:

I can see OneLake Availablity Option for new kql database created in Fabric but it's missig in Above Screenshot

abhiram342_1-1704752240291.png

 

Please suggest how to resolve the issue.

 

Thanks,

Abhiram

1 ACCEPTED SOLUTION
v-cboorla-msft
Community Support
Community Support

Hi @abhiram342 

 

Thanks for using Microsoft Fabric Community.

 

No, you cannot directly create a OneLake shortcut to a KQL database that's already created using an Azure Data Explorer database. Shortcuts can only point to original data sources, not to other shortcuts. This is expected behavior due to the following reasons.

OneLake Shortcut Scope:

  • OneLake shortcuts are primarily designed for accessing file-based data sources stored in external locations like ADLS Gen2, S3, Dataverse, or other OneLake locations. OneLake shortcuts are designed to point to external file-based data sources, not database-based sources.
  • They are not currently compatible with database-based sources like KQL databases, including those created as shortcuts within Fabric.

I hope this information helps. Please do let us know if you have further questions.

 

Thanks

View solution in original post

4 REPLIES 4
v-cboorla-msft
Community Support
Community Support

Hi @abhiram342 

 

Glad that your query got resolved.

Please continue using Fabric Community for any help regarding your queries.

v-cboorla-msft
Community Support
Community Support

Hi @abhiram342 

 

Thanks for using Microsoft Fabric Community.

 

No, you cannot directly create a OneLake shortcut to a KQL database that's already created using an Azure Data Explorer database. Shortcuts can only point to original data sources, not to other shortcuts. This is expected behavior due to the following reasons.

OneLake Shortcut Scope:

  • OneLake shortcuts are primarily designed for accessing file-based data sources stored in external locations like ADLS Gen2, S3, Dataverse, or other OneLake locations. OneLake shortcuts are designed to point to external file-based data sources, not database-based sources.
  • They are not currently compatible with database-based sources like KQL databases, including those created as shortcuts within Fabric.

I hope this information helps. Please do let us know if you have further questions.

 

Thanks

Hi @abhiram342 


We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet.
In case if you have any resolution please do share that same with the community as it can be helpful to others.
Otherwise, will respond back with the more details and we will try to help.

 

Thanks.

Hi @abhiram342 

 

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others.
If you have any question relating to the current thread, please do let us know and we will try out best to help you.
In case if you have any other question on a different issue, we request you to open a new thread.


Thanks 

Helpful resources

Announcements
FabricCarousel_June2024

Fabric Monthly Update - June 2024

Check out the June 2024 Fabric update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.