Forum Discussion

v-cboorla-msft's avatar
v-cboorla-msft
Microsoft 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