How to force Lakehouse schema to SQL Endpoint ?

[VoltesDev]

Hello guys,

I have 2 big issues at this moment:

1. Within Fabric Notebook (PySpark), I'm creating delta tableto my Lakehouse. while I can see the new table in my Lakehouse, I cannot see it in SQL Endpoint tree. But I can run query on that table in SQL Endpoint.

2. In other existing table, I noticed field name is wrong, so I'm overwriting the table, also with Fabric Notebook (PySpark). In Lakehouse, I can see the field name already changed. But, again in SQL Endpoint is still with the "old" field name.

Anyone know how to force sync between Lakehouse and SQL Endpoint ?

Thanks,

[burakkaragoz]

Hi @VoltesDev 

You can try the following solutions to resolve such synchronization issues.

Refresh/Refresh Process: SQL Endpoint may need to be refreshed manually. Right-click on the SQL Endpoint view and select “Refresh”.
Cache Cleanup: Sometimes the Fabric system may have cache issues. Refresh your browser session or log out and log back in.
REFRESH TABLE Command: Run the following command from SQL Endpoint:
sqlREFRESH TABLE [table_name]

OneLake Synchronization Delay: In Fabric, it may take some time for OneLake to synchronize systems. Wait a few minutes and check again.
Clear Spark Cache: On Notebook, run these commands:
pythonspark.sql("REFRESH TABLE [table_name]")
# or
spark.catalog.refreshTable("[table_name]")

Force Update Table Metadata: Resave the table to force changes:
pythondf = spark. read.table("[table_name]")
df.write.mode("overwrite").saveAsTable("[table_name]")

Microsoft Support: If the problem persists, this behavior may be a Fabric service issue and you may need to contact Microsoft support.

These synchronization issues may occur from time to time as Fabric is a preview/new service.

[v-prasare]

Hi @VoltesDev, as we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for your issue worked? or let us know if you need any further assistance here?

Thanks,

Prashanth Are

MS Fabric community support

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and give Kudos if helped you resolve your que

[v-prasare]

Hi @VoltesDev,

as we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for your issue worked? or let us know if you need any further assistance here?

Thanks,

Prashanth Are

MS Fabric community support

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and give Kudos if helped you resolve your que

[lbendlin · Accepted solution]

try this https://www.obvience.com/blog/fix-sql-analytics-endpoint-sync-issues-in-microsoft-fabric-data-not-sh...