Forum Discussion

AnibalBenedetto's avatar
AnibalBenedetto
Frequent Visitor
2 years ago

KQL Database - Shortcut creation failed

Hello everyone!, I want to create a Shortcut in a KQL database pointing to a Warehouse table but I'm getting errors (I am the owner of both and they are in the same Workspace).

 

 

I don't know If I'm doing something wrong and what can I do.

Thanks!

data warehouse
Eventhouse and KQL
one lake
Real-time Analytics

5 Replies

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

    Hi AnibalBenedetto 

     

    Thanks for using Microsoft Fabric Community.

    Apologies for the inconvenience.

    KQL databases don't currently support data in the Delta format. Tables in a KQL database only export to OneLake as Parquet files. Shortcuts in KQL databases that contain Delta-formatted data in the target aren't recognized as tables.

    For more details refer Link

    I tried creating a shortcut pointing to a Lakehouse which has csv file. Please find the screenshot for reference.

    I hope this helps. Please do let us know if you have any further questions. Glad to help.

    • AnibalBenedetto's avatar
      AnibalBenedetto
      Frequent Visitor
      2 years ago

      Thanks v-cboorla-msft!

      I’m confused. I have already created some shortcuts in my KQL Database pointing to Lakehouse or Warehouse tables using the wizard to do that.

      In this particular case, I got an error.

      I see that warehouse table which has a PK produces error in shortcut creation.

       

      Steps to reproduce:

       

      1- Create a Warehouse called “test_shortcut”

      2- Create two tables and only one of them with primary key

      CREATE TABLE [test_shortcut].[dbo].[table_without_pk]
(
   col1 int NOT NULL,
   col2 varchar(10) NOT NULL
)
GO

CREATE TABLE [test_shortcut].[dbo].[table_with_pk]
(
   col1 int NOT NULL,
   col2 varchar(10) NOT NULL
)
GO
ALTER TABLE dbo.table_with_pk ADD CONSTRAINT table_with_pk_key PRIMARY KEY NONCLUSTERED (col1, col2) NOT ENFORCED
GO

      3- Create a Shortcut in KQL Database pointing to the new tables

       

      table_without_pk -> ok

      table_with_pk -> error

       

      Thanks

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

        Hi AnibalBenedetto 

         

        Apologies for the inconvenience that you are facing here.

        I tried to repro the same scenario from our end and initially I have faced the same error, but after deleting the KQL Database and creating a new one the issue was resolved. Please try this workaround and let me know. I have attached screenshots for reference.

         

        I hope this helps. Please do let us know if you have any further questions. Glad to help.