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!
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.
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
GO3- Create a Shortcut in KQL Database pointing to the new tables
table_without_pk -> ok
table_with_pk -> error
Thanks
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.