Forum Discussion
Lakehouse SQL endpoint tables "Sync Error" after adding a column to table
Hi, Having an issue with the Lakehouse SQL Endpoint tables report a "Sync Error" state after adding a column to the deltatable. For example: Initially created a DimDate table via: d...
After removing the relationships from the model, I also deleted the foreign key constraints via a SQL endpoint query.
For example:
-- identifiy the foreign key constraint for each fact table
sp_fkeys 'FactSales'
-- then drop it
ALTER TABLE dbo.FactSales DROP CONSTRAINT FK_bd9f34c4_b835_4e87_956a_xxxxxxxxxxxx
daxman
Advocate II
Advocate IIThat resolved my issue, thank you so much!