Bewerken

Delen via


.show table mirroring operations command

Applies to: ✅ Microsoft Fabric

Check the table's mirroring policy operations mirroring status. Mirroring status allows you to verify the latency and status of your data export.

Syntax

.show table TableName operations mirroring-status

Learn more about syntax conventions.

Parameters

Name Type Required Description
TableName string ✔️ The name of the table for which to show the mirroring status.

Returns

Property Type Description
TableName string The name of the table.
IsEnabled bool A boolean value indicating whether or not the mirroring policy is enabled.
ExportProperties string A JSON string with various data export properties.
IsExportRunning bool A boolean value indicating whether or not the mirroring policy is running.
LastExportStartTime datetime The start time of the last export.
LastExportResult string The status of the last export result.
LastExportedDataTime datetime The time of the last data export.
Latency timespan The maximum amount of time in minutes between the last and next time new data was added to your logical copy.

Note

When the mirroring policy is enabled, tables can't be renamed.

Example

The following example requests operations mirroring status of the myTable table.

.show table myTable operations mirroring-status