topic Re: sqlEndPoint metadata refresh in Data Engineering

sqlEndPoint metadata refresh

smpa01 — Thu, 31 Jul 2025 02:46:05 GMT

curl -X POST \ "https://api.fabric.microsoft.com/v1/workspaces/<ws_id>/sqlEndpoints/<sql_enddpoint_id>/refreshMetadata" \ -H "Authorization: Bearer <your-access-token>" \ -H "Content-Type: application/json" \ -d '{"timeout": {"timeUnit": "Minutes", "value": 10}}'

I keep on getting Response code 200, I was expecting 202.

As a result, I am getting

{ "value": [ { "tableName": "test", "status": "NotRun", "startDateTime": "2025-07-31T00:07:15.0306056Z", "endDateTime": "2025-07-31T00:07:15.5150298Z", "lastSuccessfulSyncDateTime": "2025-06-05T02:29:01.543114Z", "error": null }]}

Why is it only returning TableSync Status and not triggering a refresh?

Do I understand that I need to make the service call immediately following a transaction such as following? Else it will show as NotRun if the background jobs deems it is not necessary to refresh the metadata?

def acid_transaction(): # do something def refresh_metadata (): # refresh metadata # pseudo workflow acid_transaction() ↓ refresh_metdata()

Re: sqlEndPoint metadata refresh

lbendlin — Thu, 31 Jul 2025 01:45:29 GMT

it believes that a refresh is not necessary in the current circumstances.

Re: sqlEndPoint metadata refresh

v-veshwara-msft — Thu, 07 Aug 2025 18:45:39 GMT

Hi @smpa01 ,

Thanks for sharing this in Microsoft Fabric Community.
As mentioned by @lbendlin , the behavior you're seeing is expected. The refreshMetadata call checks if a refresh is needed based on recent changes, and if it determines that there's no schema change or update requiring sync, it completes with a 200 response and status as NotRun.

This means the service has received the request but didn't find any reason to run the refresh job.

As you pointed out, if the preceding transaction didn't introduce any structural changes to the table, this outcome is expected.

Blog Reference : Refresh SQL analytics endpoint Metadata REST API (Generally Available) | Microsoft Fabric Blog | Microsoft Fabric

Please reach out for further assistance.

Thank you.

Re: sqlEndPoint metadata refresh

v-veshwara-msft — Mon, 11 Aug 2025 05:10:54 GMT

Hi @smpa01 ,

Just checking in to see if you query is resolved and if any responses were helpful.
Otherwise, feel free to reach out for further assistance.

Thank you.

Re: sqlEndPoint metadata refresh

v-veshwara-msft — Mon, 18 Aug 2025 05:53:53 GMT

Hi @smpa01 ,
Just wanted to check if the responses provided were helpful. If further assistance is needed, please reach out.
Thank you.

Re: sqlEndPoint metadata refresh

v-veshwara-msft — Fri, 22 Aug 2025 04:49:54 GMT

Hi @smpa01 ,

Following up to see if your query is resolved and if any of the responses helped.
If you're still facing issues, feel free to reach out.

Thank you.