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.
Switch services using the Version drop-down list. Learn more about navigation.
Applies to: ✅ Microsoft Fabric
Displays mirroring policy operations statistics for a table. Mirroring statistics helps you verify the latency and status of your data export.
Syntax
.show table TableName operations mirroring-statistics
Learn more about syntax conventions.
Parameters
| Name | Type | Required | Description |
|---|---|---|---|
| TableName | string |
✔️ | The name of the table for which to show the operations mirroring statistics. |
Returns
| Property | Type | Description |
|---|---|---|
| TableName | string |
The name of the table. |
| IsEnabled | bool |
Indicates whether the mirroring policy is enabled. |
| ManagedIdentityIdentifier | string |
The identifier of the managed identity. |
| IsExportRunning | bool |
Indicates whether 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. |
| CompletionPercentage | int |
The percentage of a task or operation completed. |
| PendingDataSize | int |
The size of data in bytes that's pending ingestion or processing. |
Note
When the mirroring policy is enabled, tables can't be renamed.
Example
The following example requests operations mirroring-statistics of the MTelemetry table.
.show table MTelemetry operations mirroring-statistics
Output
| TableName | IsEnabled | ManagedIdentityIdentifier | IsExportRunning | LastExportStartTime | LastExportResult | LastExportedDataTime | Latency | CompletionPercentage | PendingDataSize |
|---|---|---|---|---|---|---|---|---|---|
| MTelemetry | true | false | 2025-04-09 18:42:37.3760 | Completed | 2025-04-09 16:47:07.8420 | 00:00:00 | 100 | 0 |