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
Display the table's mirroring policy.
Syntax
.show table TableName policy mirroring
Learn more about syntax conventions.
Parameters
| Name | Type | Required | Description |
|---|---|---|---|
| TableName | string |
✔️ | The name of the table for which to show the policy details. |
Returns
Returns a JSON representation of the policy.
Example
The following example requests information about the myTable table mirroring policy.
.show table myTable policy mirroring
Output
| PolicyName | EntityName | Policy | ChildEntities | EntityType |
|---|---|---|---|---|
| MirroringPolicy | [a9c1234-b1c2-34d9-a9c1-b23c45d3e2fg3].[MyTable] | {"ConnectionStrings": ["https://example.microsoft.com/aaaabbbb-0000-cccc/66aa66aa-bb77-cc88-dd99-00ee00ee00ee/Tables/myTable/;******"], "Format": "parquet", "IsEnabled": true,"Partitions": null, "PathFormat": null, "Backfill": false, | ||
| "EffectiveDateTime": null, "TargetLatencyInMinutes": 180} | Table |