Tables are not synchronized when using lakehouse schema

[QuinnDatatyk]

It seems that when using lakehouse schema, the table is not synchronized on sql warehouse.

I created a lakehouse with lakehouse schema and a table.

However, when i switch to sql warehouse, i can't see the created tables like when using normal lakehouse.

[frithjof_v · Accepted solution]

The SQL Analytics Endpoint does not work in Lakehouses which has Schema (Preview) enabled.

Ref. similar thread 

Solved: Lakehouse tables not showing up in SQL Endpoint - Microsoft Fabric Community 

It's listed as a current limitation here:

https://learn.microsoft.com/en-us/fabric/data-engineering/lakehouse-schemas#public-preview-limitatio...

[Anonymous]

HI @QuinnDatatyk,

Have you tried to manually refresh on the dbo tables folder?
AFAIK, the sql endpoint table not real-time syncing from lakehouse, so you may need to manually refresh and waiting for some times. If these operations still not works, can you please share some more detail about this table?

BTW, you can also take a look at the preview lakehouse schema feature limits if they meets to your scenario:

Lakehouse schemas (Preview) - Microsoft Fabric | Microsoft Learn

Regards,

Xiaoxin Sheng