SQL Analytics Endpoint

[Ar_Sh]

How to Sync SQL Analytics Endpoint Metadata in Microsoft Fabric manually?

[Shubham_rai955 · Accepted solution]

To manually sync SQL Analytics Endpoint metadata in Microsoft Fabric, just use the Refresh option in the Fabric portal.

UI method
Open your Lakehouse or SQL Database in Fabric, then switch to the SQL analytics endpoint view. In the Explorer toolbar or the Query editor, hit Refresh. This triggers an immediate metadata sync, scans the Delta or Parquet files, and updates the SQL schema without any code.

[Gpop13 · Accepted solution]

hi @Ar_Sh ,

I assume you are asking how to achieve this programatically? If yes, please check the resources below

https://blog.fabric.microsoft.com/en-us/blog/refresh-sql-analytics-endpoint-metadata-rest-api-now-in...

https://github.com/microsoft/fabric-toolbox/blob/main/samples/notebook-refresh-tables-in-sql-endpoin...

[Shubham_rai955 · Accepted solution]

To manually sync SQL Analytics Endpoint metadata in Microsoft Fabric, just use the Refresh option in the Fabric portal.

UI method
Open your Lakehouse or SQL Database in Fabric, then switch to the SQL analytics endpoint view. In the Explorer toolbar or the Query editor, hit Refresh. This triggers an immediate metadata sync, scans the Delta or Parquet files, and updates the SQL schema without any code.