.show table mirroring operations command
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
This feature isn't supported.