Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Applies to: 
SQL analytics endpoint in Microsoft Fabric
Mirrored databases in Microsoft Fabric
SQL database in Microsoft Fabric
Returns the details of the most recent update to the current SQL analytics endpoint in Microsoft Fabric. Use this DMV to determine the last successful SQL analytics endpoint metadata sync.
| Column name | Data type | Description |
|---|---|---|
object_id |
int | The object_id of the current SQL analytics endpoint. |
latest_log_version |
bigint | The highest Delta transaction log version of the table that was updated. |
latest_checkpoint_version |
bigint | The latest Delta checkpoint version that was processed. |
last_update_time_utc |
datetime | Timestamp for the last time the table was updated with new data, in the UTC time zone. |
is_blocked |
bit | Indicates whether the last attempt at the table update was blocked (1) or successful (0). |
Remarks
As of May 2026, if you are on the new version of the metadata sync, then you can use the sys.dm_db_external_tables_log_status dynamic management view (DMV) to get the details of the most recent update to the SQL analytics endpoint.
Permissions
You should have access to a SQL analytics endpoint in Microsoft Fabric within a Fabric workspace with Contributor or above permissions.
Examples
Use sys.dm_db_external_tables_log_status to check the latest SQL analytics endpoint metadata sync.
SELECT *
FROM sys.dm_db_external_tables_log_status;