.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