Forum Discussion

abhiram342's avatar
abhiram342
Icon for Microsoft Employee rankMicrosoft Employee
2 years ago
Solved

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...
data engineering
Eventhouse and KQL
one lake
Real-time Analytics
  • v-cboorla-msft's avatar
    v-cboorla-msft
    2 years ago

    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

v-cboorla-msft's avatar
v-cboorla-msft
Icon for Microsoft Employee rankMicrosoft Employee
2 years ago

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

v-cboorla-msft's avatar
v-cboorla-msft
Icon for Microsoft Employee rankMicrosoft Employee
2 years ago

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.

  • v-cboorla-msft's avatar
    v-cboorla-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    2 years ago

    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