Forum Discussion
Forbidden Issue with fabric sql endpoint tables
Hi YashRaj5
It looks like a SQL Endpoint sync / OneLake permissions issue, not a data issue. The tables still exist in the Lakehouse (since Spark can read them), but the SQL Analytics Endpoint is unable to index or access them, which results in the 403 Forbidden error and missing tables in the endpoint.Recommended Fixes / Workarounds
Validate OneLake folder permissions
Make sure your identity has at least ReadAll on the specific table folders.
SQL Endpoint uses these permissions even if you are Workspace Admin.Trigger Lakehouse → SQL Endpoint metadata refresh
Refresh the SQL Analytics Endpoint in the Fabric UI
Or open the Lakehouse and run a small Spark notebook write (this often forces a sync)
Check table folder structure
Confirm the problematic tables are under:/Tables/<table_name>If they were manually written under /Files, SQL endpoint will not pick them up.
Recreate the table metadata
As you tested, copying data to another lakehouse or recreating a shortcut works, which confirms metadata corruption.
You can also try recreating the table in the same lakehouse:df.write.format("delta").mode("overwrite").saveAsTable("table_name")If the issue persists, log a Fabric support ticket
This issue matches an active Fabric bug where a few Delta tables fail to sync to SQL endpoints while others work fine.
Hi YashRaj5
It looks like a SQL Endpoint sync / OneLake permissions issue, not a data issue. The tables still exist in the Lakehouse (since Spark can read them), but the SQL Analytics Endpoint is unable to index or access them, which results in the 403 Forbidden error and missing tables in the endpoint.
Recommended Fixes / Workarounds
Validate OneLake folder permissions
Make sure your identity has at least ReadAll on the specific table folders.
SQL Endpoint uses these permissions even if you are Workspace Admin.Trigger Lakehouse → SQL Endpoint metadata refresh
Refresh the SQL Analytics Endpoint in the Fabric UI
Or open the Lakehouse and run a small Spark notebook write (this often forces a sync)
Check table folder structure
Confirm the problematic tables are under:/Tables/<table_name>If they were manually written under /Files, SQL endpoint will not pick them up.
Recreate the table metadata
As you tested, copying data to another lakehouse or recreating a shortcut works, which confirms metadata corruption.
You can also try recreating the table in the same lakehouse:df.write.format("delta").mode("overwrite").saveAsTable("table_name")If the issue persists, log a Fabric support ticket
This issue matches an active Fabric bug where a few Delta tables fail to sync to SQL endpoints while others work fine.
Thanks for the prompt response.
But all the steps you have mentioned above were already implemented, and I am also Admin on the workspace where I am facing the issue, so not sure the permissions will be applied in that case.
But eventually we found that there was an option called 'Data Access Mode' at the SQL endpoint level that was somehow causing issue, after some trial and error it started working. Thanks
