Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Frequent Visitor

Lakehouse SQL endpoint tables "Sync Error" after adding a column to table



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:



df.write.format('delta').mode("overwrite").option("overwriteSchema", True).save('Tables/DimDate')



Table was accessable via SQL Endpoint

After adding a column for "MonthEndDate" to the dataframe and running the notebook again, SQL Endpoint of DimDate does not show the new column and reports this error:



MonthEnd is not available via the SQL Endpoint, however it is available within spark queries:



Am I doing something incorrect in the saving of the dataframe?  Also got same result when merging schema instead of overwriting.

Any insight appreciated, thanks!




Frequent Visitor

Turns out the issue was foreign keys inhibit syncing of the schema.


Limitations and known issues - Microsoft Fabric | Microsoft Learn




Dropped the constraints and tables sync'd and issue resolved

Interesting. I had some relationships defined in my Lakehouse SQL Endpoint, added columns to 2 tables in Spark, then ran into your same issue.

I removed all relationships from the model, and the SQL Endpoint is still having issues syncing. This is after waiting for 15 mins, trying to force a refresh from button in top left corner. Nothing seems to get it to sync again.


What exactly did you do after removing the relationships to get it to sync again?

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

-- then drop it

ALTER TABLE dbo.FactSales DROP CONSTRAINT FK_bd9f34c4_b835_4e87_956a_xxxxxxxxxxxx

That resolved my issue, thank you so much!

Helpful resources


Fabric Monthly Update - June 2024

Check out the June 2024 Fabric update to learn about new features.


Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.