warehouse

Manage warehouses and run SQL queries

Authentication scope: fabric

list

List warehouses in a workspace

fabio warehouse list --workspace <value>

Flag	Type	Required	Description
--workspace	string	Yes	Workspace ID

Output fields: id, displayName, description

Read-only · Returns list

show

Show details of a warehouse

fabio warehouse show --workspace <value> --id <value>

Flag	Type	Required	Description
--workspace	string	Yes	Workspace ID
--id	string	Yes	Warehouse ID

Output fields: id, displayName, description, properties

Read-only · Returns object

create

Create a new warehouse

fabio warehouse create --workspace <value> --name <value>

Flag	Type	Required	Description
--workspace	string	Yes	Workspace ID
--name	string	Yes	Warehouse display name
--description	string	No	Optional description
--sensitivity-label	string	No	Sensitivity label ID to apply on creation
--collation	string	No	Collation for the warehouse (create-time only). Values: Latin1_General_100_BIN2_UTF8 (case-sensitive, default) or Latin1_General_100_CI_AS_KS_WS_SC_UTF8 (case-insensitive)

Examples

fabio warehouse create --workspace $WS --name "SalesWarehouse"

Output fields: id, displayName

Mutates state · Returns object

update

Update warehouse properties (name and/or description)

fabio warehouse update --workspace <value> --id <value>

Flag	Type	Required	Description
--workspace	string	Yes	Workspace ID
--id	string	Yes	Warehouse ID
--name	string	No	New display name
--description	string	No	New description

Mutates state · Returns object

delete

Delete a warehouse

fabio warehouse delete --workspace <value> --id <value>

Flag	Type	Required	Description
--workspace	string	Yes	Workspace ID
--id	string	Yes	Warehouse ID
--hard-delete	bool	No	Permanently delete (cannot be recovered)

Mutates state · Destructive · Returns void

query

Execute a SQL query against a warehouse or SQL endpoint

fabio warehouse query --workspace <value> --id <value>

Flag	Type	Required	Description
--workspace	string	Yes	Workspace ID
--id	string	Yes	Warehouse or Lakehouse ID
--sql	string	No	SQL query to execute (prefix with @ to read from file, omit to read from stdin)

Examples

fabio warehouse query --workspace $WS --id $WH --sql "SELECT TOP 100 * FROM dbo.fact_sales ORDER BY order_date DESC"

fabio warehouse query --workspace $WS --id $WH --sql @queries/monthly_report.sql

Mutates state · Returns list

plan

Capture the estimated execution plan (SHOWPLAN_XML) without executing the query

fabio warehouse plan --workspace <value> --id <value>

Flag	Type	Required	Description
--workspace	string	Yes	Workspace ID
--id	string	Yes	Warehouse or Lakehouse ID
--sql	string	No	SQL query to plan (prefix with @ to read from file, omit to read from stdin)

Read-only · Returns object

connection-string

Get the connection string for a warehouse

fabio warehouse connection-string --workspace <value> --id <value>

Flag	Type	Required	Description
--workspace	string	Yes	Workspace ID
--id	string	Yes	Warehouse ID
--guest-tenant-id	string	No	Guest tenant ID (for cross-tenant access)
--private-link-type	string	No	Private link type (for private endpoint access)

Examples

fabio warehouse connection-string --workspace $WS --id $WH

Read-only · Returns object

get-sql-pools-config

Get SQL pools configuration for a workspace

fabio warehouse get-sql-pools-config --workspace <value>

Flag	Type	Required	Description
--workspace	string	Yes	Workspace ID

Read-only · Returns object

update-sql-pools-config

Update SQL pools configuration for a workspace

fabio warehouse update-sql-pools-config --workspace <value>

Flag	Type	Required	Description
--workspace	string	Yes	Workspace ID
--file	string	No	Path to JSON file with configuration (prefix with @)
--content	string	No	Inline JSON content

Mutates state · Returns void

get-audit-settings

Get SQL audit settings for a warehouse

fabio warehouse get-audit-settings --workspace <value> --id <value>

Flag	Type	Required	Description
--workspace	string	Yes	Workspace ID
--id	string	Yes	Warehouse ID

Read-only · Returns object

update-audit-settings

Update SQL audit settings for a warehouse

fabio warehouse update-audit-settings --workspace <value> --id <value>

Flag	Type	Required	Description
--workspace	string	Yes	Workspace ID
--id	string	Yes	Warehouse ID
--state	string	No	Audit state (e.g. Enabled, Disabled)
--retention-days	string	No	Retention period in days
--audit-actions	string	No	Comma-separated list of audit actions

Mutates state · Returns void

set-audit-actions

Set audit actions and groups for a warehouse

fabio warehouse set-audit-actions --workspace <value> --id <value>

Flag	Type	Required	Description
--workspace	string	Yes	Workspace ID
--id	string	Yes	Warehouse ID
--actions	string	No	Comma-separated list of audit actions and groups

Mutates state · Returns void

list-restore-points

List restore points for a warehouse

fabio warehouse list-restore-points --workspace <value> --id <value>

Flag	Type	Required	Description
--workspace	string	Yes	Workspace ID
--id	string	Yes	Warehouse ID

Examples

fabio warehouse list-restore-points --workspace $WS --id $WH -o table

Read-only · Returns list

create-restore-point

Create a restore point for a warehouse

fabio warehouse create-restore-point --workspace <value> --id <value>

Flag	Type	Required	Description
--workspace	string	Yes	Workspace ID
--id	string	Yes	Warehouse ID
--name	string	No	Display name for the restore point
--description	string	No	Optional description for the restore point

Examples

fabio warehouse create-restore-point --workspace $WS --id $WH --name "pre-migration"

Mutates state · Returns object

show-restore-point

Show details of a restore point

fabio warehouse show-restore-point --workspace <value> --id <value> --restore-point-id <value>

Flag	Type	Required	Description
--workspace	string	Yes	Workspace ID
--id	string	Yes	Warehouse ID
--restore-point-id	string	Yes	Restore point ID

Read-only · Returns object

update-restore-point

Update a restore point

fabio warehouse update-restore-point --workspace <value> --id <value> --restore-point-id <value>

Flag	Type	Required	Description
--workspace	string	Yes	Workspace ID
--id	string	Yes	Warehouse ID
--restore-point-id	string	Yes	Restore point ID
--name	string	No	New display name for the restore point
--description	string	No	New description for the restore point

Mutates state · Returns void

delete-restore-point

Delete a restore point

fabio warehouse delete-restore-point --workspace <value> --id <value> --restore-point-id <value>

Flag	Type	Required	Description
--workspace	string	Yes	Workspace ID
--id	string	Yes	Warehouse ID
--restore-point-id	string	Yes	Restore point ID

Mutates state · Destructive · Returns void

restore-to-point

Restore a warehouse to a restore point

fabio warehouse restore-to-point --workspace <value> --id <value> --restore-point-id <value>

Flag	Type	Required	Description
--workspace	string	Yes	Workspace ID
--id	string	Yes	Warehouse ID
--restore-point-id	string	Yes	Restore point ID

Mutates state · Destructive · Long-running operation · Returns object

queries-running

List currently running queries on a warehouse

fabio warehouse queries-running --workspace <value> --id <value>

Flag	Type	Required	Description
--workspace	string	Yes	Workspace ID
--id	string	Yes	Warehouse or Lakehouse ID

Read-only · Returns object

queries-frequent

List frequently-run queries (from queryinsights.frequently_run_queries)

fabio warehouse queries-frequent --workspace <value> --id <value>

Flag	Type	Required	Description
--workspace	string	Yes	Workspace ID
--id	string	Yes	Warehouse or Lakehouse ID
--top	string	No	Maximum rows to return (default: 100)

Read-only · Returns object

queries-long-running

List long-running queries (from queryinsights.long_running_queries)

fabio warehouse queries-long-running --workspace <value> --id <value>

Flag	Type	Required	Description
--workspace	string	Yes	Workspace ID
--id	string	Yes	Warehouse or Lakehouse ID
--top	string	No	Maximum rows to return (default: 100)

Read-only · Returns object

queries-history

List completed query history (from queryinsights.exec_requests_history)

fabio warehouse queries-history --workspace <value> --id <value>

Flag	Type	Required	Description
--workspace	string	Yes	Workspace ID
--id	string	Yes	Warehouse or Lakehouse ID
--top	string	No	Maximum rows to return (default: 100)
--label	string	No	Filter to queries tagged with this OPTION (LABEL = ‘…’) value

Read-only · Returns object

queries-kill

Kill a running query session by session ID

fabio warehouse queries-kill --workspace <value> --id <value> --session-id <value>

Flag	Type	Required	Description
--workspace	string	Yes	Workspace ID
--id	string	Yes	Warehouse or Lakehouse ID
--session-id	string	Yes	Session ID to terminate

Mutates state · Destructive · Returns object

pool-insights

Report SQL pool state changes and sustained pressure events (from queryinsights.sql_pool_insights)

fabio warehouse pool-insights --workspace <value> --id <value>

Flag	Type	Required	Description
--workspace	string	Yes	Workspace ID
--id	string	Yes	Warehouse or Lakehouse ID
--top	string	No	Maximum rows to return (default: 100)

Read-only · Returns object

statistics-list

List user-defined statistics on a warehouse or SQL endpoint

fabio warehouse statistics-list --workspace <value> --id <value>

Flag	Type	Required	Description
--workspace	string	Yes	Workspace ID
--id	string	Yes	Warehouse or Lakehouse ID
--table	string	No	Filter by table name (schema.table)

Read-only · Returns object

statistics-show

Show details of a statistic (header, density vector, histogram)

fabio warehouse statistics-show --workspace <value> --id <value> --name <value>

Flag	Type	Required	Description
--workspace	string	Yes	Workspace ID
--id	string	Yes	Warehouse or Lakehouse ID
--name	string	Yes	Statistic name to inspect

Read-only · Returns object

statistics-create

Create a user-defined statistic on a column

fabio warehouse statistics-create --workspace <value> --id <value> --table <value> --column <value> --name <value>

Flag	Type	Required	Description
--workspace	string	Yes	Workspace ID
--id	string	Yes	Warehouse or Lakehouse ID
--table	string	Yes	Schema-qualified table name (e.g., dbo.orders)
--column	string	Yes	Column name to create statistics on
--name	string	Yes	Name for the new statistic

Mutates state · Returns object

statistics-update

Update (refresh) an existing statistic

fabio warehouse statistics-update --workspace <value> --id <value> --name <value>

Flag	Type	Required	Description
--workspace	string	Yes	Workspace ID
--id	string	Yes	Warehouse or Lakehouse ID
--name	string	Yes	Statistic name to update

Mutates state · Returns object

statistics-delete

Delete a user-defined statistic

fabio warehouse statistics-delete --workspace <value> --id <value> --name <value>

Flag	Type	Required	Description
--workspace	string	Yes	Workspace ID
--id	string	Yes	Warehouse or Lakehouse ID
--name	string	Yes	Statistic name to delete

Mutates state · Returns object

get-retention

Report the configured data-retention (time-travel) period, in days

fabio warehouse get-retention --workspace <value> --id <value>

Flag	Type	Required	Description
--workspace	string	Yes	Workspace ID
--id	string	Yes	Warehouse ID

Read-only · Returns object

set-retention

Configure the data-retention (time-travel) period, in days (1-120)

fabio warehouse set-retention --workspace <value> --id <value> --days <value>

Flag	Type	Required	Description
--workspace	string	Yes	Workspace ID
--id	string	Yes	Warehouse ID
--days	string	Yes	Retention period in days (1-120). Decreasing it is irreversible (older history is garbage-collected)

Mutates state · Destructive · Returns void