Editar

sys.dm_db_external_tables_log_status (Transact-SQL)

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;