refresh_sql_endpoint_metadata
Refreshes metadata of a SQL analytics endpoint by syncing from the underlying Lakehouse. Supports optional table recreation to resolve inconsistencies.
Instructions
Refresh metadata for a SQL analytics endpoint (sync from the underlying Lakehouse).
This is a long-running operation (LRO) that is polled to completion. Returns a list of per-table sync results.
Args:
workspace: Workspace name or GUID.
endpoint: SQL analytics endpoint name or GUID.
recreate_tables: When True, drop and recreate all tables during
the refresh. Use to resolve inconsistencies or force a clean
rebuild. Destructive — use with caution. Requires
FABRIC_MCP_ALLOW_DESTRUCTIVE=1 when enabled.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| workspace | Yes | ||
| endpoint | Yes | ||
| recreate_tables | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |