Forum Discussion
Different behaviour between SQL database and SQL Analytics endpoint
Hi pmscorca ,
To align the SQL Analytics Endpoint with the SQL Database Editor, you need to explicitly call the Fabric REST API refreshMetadata operation. This forces the endpoint to sync its schema with the latest definitions.You don’t use this API inside the SQL Database Editor or SQL Analytics Endpoint UI directly it’s a REST API call that you trigger from your own automation or client code. In practice, you’d use it in one of these places:
1. Fabric Pipelines → Add a Web activity after your ingestion/transform steps to call the refreshMetadata API, so the SQL Analytics Endpoint is always aligned before downstream reporting.
2. Notebooks → Use Python (with requests or http libraries) to call the API as part of your workflow.
3. External scripts → PowerShell, Python, or any HTTP client can invoke the endpoint. This is common if you’re orchestrating refreshes outside Fabric.
4. CI/CD automation → Integrate the call into deployment pipelines so schema changes are automatically reflected in the SQL Analytics Endpoint.
For more details, you can refer to the official documentation:
Items - Refresh Sql Endpoint Metadata - REST API (SQLEndpoint) | Microsoft Learn
Thank you.
Hi,
I already refreshed both the SQL Database Editor and the SQL Analytics Endpoint Editor some time ago, but the SQL Analytics Endpoint isn't aligned with the SQL Database Editor yet.
I don't understand how triggering the SQL Endpoint Metadata Refresh API.
Thanks
Hi pmscorca ,
To align the SQL Analytics Endpoint with the SQL Database Editor, you need to explicitly call the Fabric REST API refreshMetadata operation. This forces the endpoint to sync its schema with the latest definitions.
You don’t use this API inside the SQL Database Editor or SQL Analytics Endpoint UI directly it’s a REST API call that you trigger from your own automation or client code. In practice, you’d use it in one of these places:
1. Fabric Pipelines → Add a Web activity after your ingestion/transform steps to call the refreshMetadata API, so the SQL Analytics Endpoint is always aligned before downstream reporting.
2. Notebooks → Use Python (with requests or http libraries) to call the API as part of your workflow.
3. External scripts → PowerShell, Python, or any HTTP client can invoke the endpoint. This is common if you’re orchestrating refreshes outside Fabric.
4. CI/CD automation → Integrate the call into deployment pipelines so schema changes are automatically reflected in the SQL Analytics Endpoint.
For more details, you can refer to the official documentation:
Items - Refresh Sql Endpoint Metadata - REST API (SQLEndpoint) | Microsoft Learn
Thank you.