warehouse-snapshot
Manage warehouse snapshots
Authentication scope: fabric
List warehouse snapshots in a workspace
fabio warehouse-snapshot list --workspace <value>| Flag | Type | Required | Description |
|---|---|---|---|
--workspace |
string |
Yes | Workspace ID |
Read-only · Returns list
Show details of a warehouse snapshot
fabio warehouse-snapshot show --workspace <value> --id <value>| Flag | Type | Required | Description |
|---|---|---|---|
--workspace |
string |
Yes | Workspace ID |
--id |
string |
Yes | Warehouse snapshot ID |
Read-only · Returns object
create
Section titled “create”Create a new warehouse snapshot
fabio warehouse-snapshot create --workspace <value> --name <value> --warehouse-id <value>| Flag | Type | Required | Description |
|---|---|---|---|
--workspace |
string |
Yes | Workspace ID |
--name |
string |
Yes | Display name |
--warehouse-id |
string |
Yes | Source warehouse ID to snapshot |
--snapshot-datetime |
string |
No | Point-in-time for the snapshot in UTC (YYYY-MM-DDTHH:mm:ssZ); omit for the current time |
--description |
string |
No | Optional description |
--sensitivity-label |
string |
No | Sensitivity label ID to apply on creation |
Mutates state · Returns object
update
Section titled “update”Update warehouse snapshot properties (name and/or description)
fabio warehouse-snapshot update --workspace <value> --id <value>| Flag | Type | Required | Description |
|---|---|---|---|
--workspace |
string |
Yes | Workspace ID |
--id |
string |
Yes | Warehouse snapshot ID |
--name |
string |
No | New display name |
--description |
string |
No | New description |
Mutates state · Returns object
delete
Section titled “delete”Delete a warehouse snapshot
fabio warehouse-snapshot delete --workspace <value> --id <value>| Flag | Type | Required | Description |
|---|---|---|---|
--workspace |
string |
Yes | Workspace ID |
--id |
string |
Yes | Warehouse snapshot ID |
--hard-delete |
bool |
No | Permanently delete (cannot be recovered) |
Mutates state · Destructive · Returns void
Run a read-only T-SQL query against the snapshot’s SQL endpoint
fabio warehouse-snapshot query --workspace <value> --id <value>| Flag | Type | Required | Description |
|---|---|---|---|
--workspace |
string |
Yes | Workspace ID |
--id |
string |
Yes | Warehouse snapshot ID |
--sql |
string |
No | T-SQL query text (inline, @file, or piped via stdin) |
Read-only · Returns list
list-tables
Section titled “list-tables”List tables in the snapshot (schema-qualified)
fabio warehouse-snapshot list-tables --workspace <value> --id <value>| Flag | Type | Required | Description |
|---|---|---|---|
--workspace |
string |
Yes | Workspace ID |
--id |
string |
Yes | Warehouse snapshot ID |
--schema |
string |
No | Filter to a specific schema (default: all) |
Read-only · Returns list
describe-table
Section titled “describe-table”Describe a table’s columns in the snapshot
fabio warehouse-snapshot describe-table --workspace <value> --id <value> --table <value>| Flag | Type | Required | Description |
|---|---|---|---|
--workspace |
string |
Yes | Workspace ID |
--id |
string |
Yes | Warehouse snapshot ID |
--table |
string |
Yes | Table name (optionally schema-qualified: schema.table) |
Read-only · Returns list
Capture the estimated execution plan (SHOWPLAN_XML) for a query
fabio warehouse-snapshot plan --workspace <value> --id <value>| Flag | Type | Required | Description |
|---|---|---|---|
--workspace |
string |
Yes | Workspace ID |
--id |
string |
Yes | Warehouse snapshot ID |
--sql |
string |
No | T-SQL query text (inline, @file, or piped via stdin) |
Read-only · Returns object
connection-string
Section titled “connection-string”Print the snapshot’s SQL connection string (server + database)
fabio warehouse-snapshot connection-string --workspace <value> --id <value>| Flag | Type | Required | Description |
|---|---|---|---|
--workspace |
string |
Yes | Workspace ID |
--id |
string |
Yes | Warehouse snapshot ID |
Read-only · Returns object