lakehouse
Manage lakehouses (tables, files, shortcuts)
Authentication scope: fabric
List lakehouses in a workspace
fabio lakehouse list --workspace <value>| Flag | Type | Required | Description |
|---|---|---|---|
--workspace |
string |
Yes | Workspace ID |
Output fields: id, displayName, description
Read-only · Returns list
Show details of a lakehouse
fabio lakehouse show --workspace <value> --id <value>| Flag | Type | Required | Description |
|---|---|---|---|
--workspace |
string |
Yes | Workspace ID |
--id |
string |
Yes | Lakehouse ID |
Output fields: id, displayName, description, properties
Read-only · Returns object
create
Section titled “create”Create a new lakehouse
fabio lakehouse create --workspace <value> --name <value>| Flag | Type | Required | Description |
|---|---|---|---|
--workspace |
string |
Yes | Workspace ID |
--name |
string |
Yes | Lakehouse display name |
--description |
string |
No | Optional description |
--enable-schemas |
bool |
No | Enable schemas (multi-schema lakehouse) |
--sensitivity-label |
string |
No | Sensitivity label ID to apply on creation |
Examples
fabio lakehouse create --workspace $WS --name "DataLake"Output fields: id, displayName
Mutates state · Returns object
update
Section titled “update”Update a lakehouse (rename/redescribe)
fabio lakehouse update --workspace <value> --id <value>| Flag | Type | Required | Description |
|---|---|---|---|
--workspace |
string |
Yes | Workspace ID |
--id |
string |
Yes | Lakehouse ID |
--name |
string |
No | New display name |
--description |
string |
No | New description |
Mutates state · Returns object
delete
Section titled “delete”Delete a lakehouse
fabio lakehouse delete --workspace <value> --id <value>| Flag | Type | Required | Description |
|---|---|---|---|
--workspace |
string |
Yes | Workspace ID |
--id |
string |
Yes | Lakehouse ID |
--hard-delete |
bool |
No | Permanently delete (cannot be recovered) |
Mutates state · Destructive · Returns void
list-tables
Section titled “list-tables”Aliases: tables
List tables in a lakehouse
fabio lakehouse list-tables --workspace <value> --id <value>| Flag | Type | Required | Description |
|---|---|---|---|
--workspace |
string |
Yes | Workspace ID |
--id |
string |
Yes | Lakehouse ID |
Examples
fabio lakehouse list-tables --workspace $WS --id $LH -o tableRead-only · Returns list
list-files
Section titled “list-files”Aliases: files
List files in a lakehouse
fabio lakehouse list-files --workspace <value> --id <value>| Flag | Type | Required | Description |
|---|---|---|---|
--workspace |
string |
Yes | Workspace ID |
--id |
string |
Yes | Lakehouse ID |
--path |
string |
No | Directory path to list (default: root) |
Examples
fabio lakehouse list-files --workspace $WS --id $LH --path Files/raw/Read-only · Returns list
Execute SQL against the lakehouse SQL endpoint
fabio lakehouse query --workspace <value> --id <value>| Flag | Type | Required | Description |
|---|---|---|---|
--workspace |
string |
Yes | Workspace ID |
--id |
string |
Yes | Lakehouse ID |
--sql |
string |
No | SQL query to execute (prefix with @ to read from file, omit to read from stdin) |
Read-only · Returns list
Capture the estimated execution plan (SHOWPLAN_XML) without executing the query
fabio lakehouse plan --workspace <value> --id <value>| Flag | Type | Required | Description |
|---|---|---|---|
--workspace |
string |
Yes | Workspace ID |
--id |
string |
Yes | Lakehouse ID |
--sql |
string |
No | SQL query to plan (prefix with @ to read from file, omit to read from stdin) |
Read-only · Returns object
queries-running
Section titled “queries-running”List currently running queries on the lakehouse SQL endpoint
fabio lakehouse queries-running --workspace <value> --id <value>| Flag | Type | Required | Description |
|---|---|---|---|
--workspace |
string |
Yes | Workspace ID |
--id |
string |
Yes | Lakehouse ID |
Read-only · Returns object
queries-frequent
Section titled “queries-frequent”List frequently-run queries (from queryinsights.frequently_run_queries)
fabio lakehouse queries-frequent --workspace <value> --id <value>| Flag | Type | Required | Description |
|---|---|---|---|
--workspace |
string |
Yes | Workspace ID |
--id |
string |
Yes | Lakehouse ID |
--top |
string |
No | Maximum rows to return (default: 100) |
Read-only · Returns object
queries-long-running
Section titled “queries-long-running”List long-running queries (from queryinsights.long_running_queries)
fabio lakehouse queries-long-running --workspace <value> --id <value>| Flag | Type | Required | Description |
|---|---|---|---|
--workspace |
string |
Yes | Workspace ID |
--id |
string |
Yes | Lakehouse ID |
--top |
string |
No | Maximum rows to return (default: 100) |
Read-only · Returns object
queries-history
Section titled “queries-history”List completed query history (from queryinsights.exec_requests_history)
fabio lakehouse queries-history --workspace <value> --id <value>| Flag | Type | Required | Description |
|---|---|---|---|
--workspace |
string |
Yes | Workspace ID |
--id |
string |
Yes | 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
pool-insights
Section titled “pool-insights”Report SQL pool state changes and sustained pressure events (from queryinsights.sql_pool_insights)
fabio lakehouse pool-insights --workspace <value> --id <value>| Flag | Type | Required | Description |
|---|---|---|---|
--workspace |
string |
Yes | Workspace ID |
--id |
string |
Yes | Lakehouse ID |
--top |
string |
No | Maximum rows to return (default: 100) |
Read-only · Returns object
table-health
Section titled “table-health”Report file-level storage health metrics for a table (runs sys.sp_get_table_health_metrics on the SQL analytics endpoint)
fabio lakehouse table-health --workspace <value> --id <value> --table <value>| Flag | Type | Required | Description |
|---|---|---|---|
--workspace |
string |
Yes | Workspace ID |
--id |
string |
Yes | Lakehouse ID |
--table |
string |
Yes | Fully-qualified table name to analyze (format schema.table; schema optional if dbo) |
Read-only · Returns object
upload
Section titled “upload”Upload files to a lakehouse (supports glob patterns for parallel upload)
fabio lakehouse upload --workspace <value> --id <value> --source-path <value> --dest-path <value>| Flag | Type | Required | Description |
|---|---|---|---|
--workspace |
string |
Yes | Workspace ID |
--id |
string |
Yes | Lakehouse ID |
--source-path |
string |
Yes | Local source path (supports glob patterns, e.g. ./data/*.csv) |
--dest-path |
string |
Yes | Remote destination path (directory when uploading multiple files) |
Examples
fabio lakehouse upload --workspace $WS --id $LH --source "data/*.parquet" --dest Files/raw/Mutates state · Returns object
download
Section titled “download”Download a file from a lakehouse
fabio lakehouse download --workspace <value> --id <value> --source-path <value> --dest-path <value>| Flag | Type | Required | Description |
|---|---|---|---|
--workspace |
string |
Yes | Workspace ID |
--id |
string |
Yes | Lakehouse ID |
--source-path |
string |
Yes | Remote source path |
--dest-path |
string |
Yes | Local destination path |
Examples
fabio lakehouse download --workspace $WS --id $LH --path Files/raw/report.csv --dest ./local/Read-only · Returns object
upload-table
Section titled “upload-table”Upload a local file and load it into a Delta table (upload + load-table in one step)
fabio lakehouse upload-table --workspace <value> --id <value> --source-path <value> --table <value>| Flag | Type | Required | Description |
|---|---|---|---|
--workspace |
string |
Yes | Workspace ID |
--id |
string |
Yes | Lakehouse ID |
--source-path |
string |
Yes | Local source file path (e.g., ./data.csv) |
--table |
string |
Yes | Table name |
--mode |
string |
No | Load mode: Overwrite or Append |
--format |
string |
No | File format: Csv, Parquet (auto-detected from extension if omitted) |
--schema |
string |
No | Schema name for multi-schema (schemas-enabled) lakehouses (beta; e.g., dbo) |
Examples
fabio lakehouse upload-table --workspace $WS --id $LH --source sales.csv --table sales --mode Overwrite --format CsvMutates state · Long-running operation · Returns object
load-table
Section titled “load-table”Load a file (already in the lakehouse) into a Delta table
fabio lakehouse load-table --workspace <value> --id <value> --source-path <value> --table <value>| Flag | Type | Required | Description |
|---|---|---|---|
--workspace |
string |
Yes | Workspace ID |
--id |
string |
Yes | Lakehouse ID |
--source-path |
string |
Yes | Relative path to the source file (e.g., Files/data.csv) |
--table |
string |
Yes | Table name |
--mode |
enum |
No | Load mode: Overwrite or Append Default: Overwrite. |
--format |
enum |
No | File format: Csv, Parquet Default: Csv. |
--wait |
bool |
No | Wait for completion (no-op: load-table always waits via LRO polling) |
--no-header |
bool |
No | CSV file does NOT have a header row (by default, header is assumed present) |
--delimiter |
string |
No | CSV delimiter character (default: comma) |
--schema |
string |
No | Schema name for multi-schema lakehouses (beta; e.g., dbo) |
Examples
fabio lakehouse load-table --workspace $WS --id $LH --path Files/raw/products.parquet --table products --mode Append --format ParquetMutates state · Returns void
copy-file
Section titled “copy-file”Copy files between lakehouses (supports glob patterns for parallel copy)
fabio lakehouse copy-file --source-workspace <value> --source-id <value> --source-path <value> --dest-workspace <value> --dest-id <value> --dest-path <value>| Flag | Type | Required | Description |
|---|---|---|---|
--source-workspace |
string |
Yes | Source workspace ID |
--source-id |
string |
Yes | Source lakehouse ID |
--source-path |
string |
Yes | Source file path (supports glob patterns, e.g. Files/data/*.csv) |
--dest-workspace |
string |
Yes | Destination workspace ID |
--dest-id |
string |
Yes | Destination lakehouse ID |
--dest-path |
string |
Yes | Destination path (directory when copying multiple files) |
Examples
fabio lakehouse copy-file --workspace $WS --id $LH --source "Files/raw/*.csv" --dest-workspace $WS2 --dest-id $LH2 --dest Files/imported/Mutates state · Returns object
move-file
Section titled “move-file”Move files between lakehouses (supports glob patterns for parallel move)
fabio lakehouse move-file --source-workspace <value> --source-id <value> --source-path <value> --dest-workspace <value> --dest-id <value> --dest-path <value>| Flag | Type | Required | Description |
|---|---|---|---|
--source-workspace |
string |
Yes | Source workspace ID |
--source-id |
string |
Yes | Source lakehouse ID |
--source-path |
string |
Yes | Source file path (supports glob patterns, e.g. Files/data/*.csv) |
--dest-workspace |
string |
Yes | Destination workspace ID |
--dest-id |
string |
Yes | Destination lakehouse ID |
--dest-path |
string |
Yes | Destination path (directory when moving multiple files) |
Examples
fabio lakehouse move-file --workspace $WS --id $LH --source "Files/staging/*" --dest Files/archive/Mutates state · Destructive · Returns void
copy-table
Section titled “copy-table”Copy a table between lakehouses
fabio lakehouse copy-table --source-workspace <value> --source-id <value> --source-table <value> --dest-workspace <value> --dest-id <value>| Flag | Type | Required | Description |
|---|---|---|---|
--source-workspace |
string |
Yes | Source workspace ID |
--source-id |
string |
Yes | Source lakehouse ID |
--source-table |
string |
Yes | Source table name (supports glob patterns) |
--dest-workspace |
string |
Yes | Destination workspace ID |
--dest-id |
string |
Yes | Destination lakehouse ID |
--dest-table |
string |
No | Destination table name (ignored for glob patterns) |
Examples
fabio lakehouse copy-table --workspace $WS --id $LH --table sales --dest-workspace $WS2 --dest-id $LH2Mutates state · Returns object
move-table
Section titled “move-table”Move a table between lakehouses (copy + delete source)
fabio lakehouse move-table --source-workspace <value> --source-id <value> --source-table <value> --dest-workspace <value> --dest-id <value>| Flag | Type | Required | Description |
|---|---|---|---|
--source-workspace |
string |
Yes | Source workspace ID |
--source-id |
string |
Yes | Source lakehouse ID |
--source-table |
string |
Yes | Source table name (supports glob patterns) |
--dest-workspace |
string |
Yes | Destination workspace ID |
--dest-id |
string |
Yes | Destination lakehouse ID |
--dest-table |
string |
No | Destination table name (ignored for glob patterns) |
Mutates state · Destructive · Returns void
Sync files between lakehouses (parallel, copies new/modified files)
fabio lakehouse sync --dest-workspace <value> --dest-id <value> --dest-path <value>| Flag | Type | Required | Description |
|---|---|---|---|
--source-workspace |
string |
No | Source workspace ID (omit when using –local) |
--source-id |
string |
No | Source lakehouse ID (omit when using –local) |
--source-path |
string |
No | Source path (e.g. Files/data or Tables/mytable; omit when using –local) |
--local |
string |
No | Local directory to sync from (alternative to –source-workspace/–source-id) |
--dest-workspace |
string |
Yes | Destination workspace ID |
--dest-id |
string |
Yes | Destination lakehouse ID |
--dest-path |
string |
Yes | Destination path |
--delete |
bool |
No | Delete files at destination that don’t exist in source |
--checksum |
bool |
No | Use Content-MD5 checksums for comparison (slower, requires HEAD per file) |
--include |
string |
No | Include only files matching these glob patterns (semicolon-separated) |
--exclude |
string |
No | Exclude files matching these glob patterns (semicolon-separated) |
--size-only |
bool |
No | Compare only by file size (skip ETag/checksum comparison) |
--no-overwrite |
bool |
No | Only copy files that don’t exist at destination (skip existing) |
--no-recursive |
bool |
No | Sync only top-level files (do not recurse into subdirectories) |
--max-delete |
integer |
No | Safety limit: abort deletions if more than NUM files would be deleted |
--existing |
bool |
No | Only update files that already exist at destination (don’t create new) |
--remove-source-files |
bool |
No | Delete source files after successful transfer (move semantics) |
--min-size |
string |
No | Skip files smaller than SIZE bytes (supports K, M, G suffixes) |
--max-size |
string |
No | Skip files larger than SIZE bytes (supports K, M, G suffixes) |
--itemize |
bool |
No | Show per-file actions on stderr (copy, skip, rename, delete) |
Examples
fabio lakehouse sync --source-workspace $WS --source-id $LH --source-path Files/data --dest-workspace $WS2 --dest-id $LH2 --dest-path Files/data --deletefabio lakehouse sync --source-workspace $WS --source-id $LH --source-path Files/data --dest-workspace $WS2 --dest-id $LH2 --dest-path Files/data --delete --checksumfabio lakehouse sync --source-workspace $WS --source-id $LH --source-path Files/data --dest-workspace $WS2 --dest-id $LH2 --dest-path Files/data --include "*.csv;*.parquet" --exclude "*.tmp;_delta_log/*"fabio lakehouse sync --local ./data/ --dest-workspace $WS --dest-id $LH --dest-path Files/dataMutates state · Returns object
create-directory
Section titled “create-directory”Create a directory in a lakehouse (DFS)
fabio lakehouse create-directory --workspace <value> --id <value> --path <value>| Flag | Type | Required | Description |
|---|---|---|---|
--workspace |
string |
Yes | Workspace ID |
--id |
string |
Yes | Lakehouse ID |
--path |
string |
Yes | Directory path to create (e.g. “Files/staging/incoming”) |
Mutates state · Returns object
delete-file
Section titled “delete-file”Delete a file from a lakehouse
fabio lakehouse delete-file --workspace <value> --id <value> --path <value>| Flag | Type | Required | Description |
|---|---|---|---|
--workspace |
string |
Yes | Workspace ID |
--id |
string |
Yes | Lakehouse ID |
--path |
string |
Yes | File path to delete |
Mutates state · Destructive · Returns void
delete-directory
Section titled “delete-directory”Recursively delete a directory from a lakehouse (DFS; irreversible)
fabio lakehouse delete-directory --workspace <value> --id <value> --path <value>| Flag | Type | Required | Description |
|---|---|---|---|
--workspace |
string |
Yes | Workspace ID |
--id |
string |
Yes | Lakehouse ID |
--path |
string |
Yes | Directory path to delete (e.g. “Files/staging”); deletes everything under it |
Mutates state · Destructive · Returns void
delete-table
Section titled “delete-table”Delete a table from a lakehouse
fabio lakehouse delete-table --workspace <value> --id <value> --table <value>| Flag | Type | Required | Description |
|---|---|---|---|
--workspace |
string |
Yes | Workspace ID |
--id |
string |
Yes | Lakehouse ID |
--table |
string |
Yes | Table name (supports glob patterns) |
Mutates state · Destructive · Returns void
create-shortcut
Section titled “create-shortcut”Create a shortcut (typed target flags per target type, or raw –target JSON)
fabio lakehouse create-shortcut --workspace <value> --id <value> --name <value> --path <value> --target-type <value>| Flag | Type | Required | Description |
|---|---|---|---|
--workspace |
string |
Yes | Workspace ID |
--id |
string |
Yes | Lakehouse ID |
--name |
string |
Yes | Shortcut name |
--path |
string |
Yes | Shortcut path (e.g., Tables or Files) |
--target-type |
enum |
Yes | Target type: OneLake, AdlsGen2, AmazonS3, AzureBlobStorage, GoogleCloudStorage, S3Compatible, Dataverse, ExternalDataShare, OneDriveSharePoint |
--target |
string |
No | Full target object as JSON (escape hatch; overrides the typed flags below) |
--connection-id |
string |
No | Connection ID (required for all cloud/external targets; optional for OneLake) |
--location |
string |
No | Storage location URL (AdlsGen2/AmazonS3/AzureBlobStorage/GoogleCloudStorage/S3Compatible/OneDriveSharePoint) |
--subpath |
string |
No | Subpath within the target location |
--bucket |
string |
No | Bucket name (S3Compatible only) |
--target-workspace |
string |
No | Target OneLake workspace ID (OneLake target) |
--target-item |
string |
No | Target OneLake item ID (OneLake target) |
--target-path |
string |
No | Target OneLake path, e.g. Tables/orders (OneLake target) |
--environment-domain |
string |
No | Dataverse environment domain (Dataverse target) |
--delta-lake-folder |
string |
No | Dataverse Delta Lake folder (Dataverse target) |
--update-sensitivity |
bool |
No | Update Fabric item sensitivity from source (OneDriveSharePoint target) |
--transform |
string |
No | Apply a data transformation, converting source files into a Delta table. Only csvToDelta is supported via the REST API (Parquet/JSON/ Excel and AI transforms are portal-only). Create the shortcut under Tables |
--transform-json |
string |
No | Full transform object as JSON (escape hatch; overrides –transform + csv flags) |
--csv-delimiter |
string |
No | CSV delimiter for csvToDelta (default ,; one of , ; tab | & space) |
--csv-no-header |
bool |
No | CSV files do NOT have a header row (csvToDelta; default: first row is the header) |
--csv-keep-error-files |
bool |
No | Do NOT skip source files with errors (csvToDelta; default: skip bad files) |
--transform-include-subfolders |
bool |
No | Recurse into subfolders of the target when transforming (default: top-level only) |
--conflict-policy |
string |
No | Conflict policy: Abort or GenerateUniqueName |
Examples
fabio lakehouse create-shortcut --workspace $WS --id $LH --name "external-data" --path Files/ --target-type adls --location "https://storageacct.dfs.core.windows.net/container" --subpath "data/2024/"Mutates state · Returns object
list-shortcuts
Section titled “list-shortcuts”List shortcuts in an item (hides DW-managed shortcuts by default)
fabio lakehouse list-shortcuts --workspace <value> --id <value>| Flag | Type | Required | Description |
|---|---|---|---|
--workspace |
string |
Yes | Workspace ID |
--id |
string |
Yes | Lakehouse ID |
--parent-path |
string |
No | Only list shortcuts under this parent path (e.g. Tables or Files/raw) |
--include-managed |
bool |
No | Include DW-managed shortcuts (internal OneLake refs under Tables/, hidden by default) |
Read-only · Returns list
get-shortcut
Section titled “get-shortcut”Get shortcut details
fabio lakehouse get-shortcut --workspace <value> --id <value> --name <value> --path <value>| Flag | Type | Required | Description |
|---|---|---|---|
--workspace |
string |
Yes | Workspace ID |
--id |
string |
Yes | Lakehouse ID |
--name |
string |
Yes | Shortcut name |
--path |
string |
Yes | Shortcut path |
Read-only · Returns object
delete-shortcut
Section titled “delete-shortcut”Delete a shortcut
fabio lakehouse delete-shortcut --workspace <value> --id <value> --name <value> --path <value>| Flag | Type | Required | Description |
|---|---|---|---|
--workspace |
string |
Yes | Workspace ID |
--id |
string |
Yes | Lakehouse ID |
--name |
string |
Yes | Shortcut name |
--path |
string |
Yes | Shortcut path |
Mutates state · Destructive · Returns void
bulk-create-shortcuts
Section titled “bulk-create-shortcuts”Bulk-create multiple shortcuts (LRO)
fabio lakehouse bulk-create-shortcuts --workspace <value> --id <value>| Flag | Type | Required | Description |
|---|---|---|---|
--workspace |
string |
Yes | Workspace ID |
--id |
string |
Yes | Lakehouse ID |
--file |
string |
No | Path to JSON file with array of shortcut requests |
--content |
string |
No | Inline JSON with array of shortcut requests |
--conflict-policy |
string |
No | Conflict policy: Abort, GenerateUniqueName, CreateOrOverwrite, OverwriteOnly |
Mutates state · Returns object
get-definition
Section titled “get-definition”Get the definition of a lakehouse
fabio lakehouse get-definition --workspace <value> --id <value>| Flag | Type | Required | Description |
|---|---|---|---|
--workspace |
string |
Yes | Workspace ID |
--id |
string |
Yes | Lakehouse ID |
--decode |
bool |
No | Decode base64 payloads inline (adds decodedPayload field) |
Read-only · Long-running operation · Returns object
update-definition
Section titled “update-definition”Update the definition of a lakehouse
fabio lakehouse update-definition --workspace <value> --id <value>| Flag | Type | Required | Description |
|---|---|---|---|
--workspace |
string |
Yes | Workspace ID |
--id |
string |
Yes | Lakehouse ID |
--file |
string |
No | Definition file path (reads file content) |
--content |
string |
No | Definition content (inline JSON) |
Mutates state · Long-running operation · Returns void
refresh-materialized-views
Section titled “refresh-materialized-views”Trigger a refresh of materialized lake views
fabio lakehouse refresh-materialized-views --workspace <value> --id <value>| Flag | Type | Required | Description |
|---|---|---|---|
--workspace |
string |
Yes | Workspace ID |
--id |
string |
Yes | Lakehouse ID |
Examples
fabio lakehouse refresh-materialized-views --workspace $WS --id $LAKEHOUSE_IDMutates state · Returns object
list-materialized-views-schedules
Section titled “list-materialized-views-schedules”List materialized lake view refresh schedules (named schedules for this lakehouse)
fabio lakehouse list-materialized-views-schedules --workspace <value> --id <value>| Flag | Type | Required | Description |
|---|---|---|---|
--workspace |
string |
Yes | Workspace ID |
--id |
string |
Yes | Lakehouse ID |
Read-only · Returns list
get-materialized-views-schedule
Section titled “get-materialized-views-schedule”Show a single materialized lake view refresh schedule by ID
fabio lakehouse get-materialized-views-schedule --workspace <value> --id <value> --schedule-id <value>| Flag | Type | Required | Description |
|---|---|---|---|
--workspace |
string |
Yes | Workspace ID |
--id |
string |
Yes | Lakehouse ID |
--schedule-id |
string |
Yes | Schedule ID |
Read-only · Returns object
create-materialized-views-schedule
Section titled “create-materialized-views-schedule”Create a schedule for materialized lake view refresh
fabio lakehouse create-materialized-views-schedule --workspace <value> --id <value>| Flag | Type | Required | Description |
|---|---|---|---|
--workspace |
string |
Yes | Workspace ID |
--id |
string |
Yes | Lakehouse ID |
--file |
string |
No | Schedule definition file path (JSON) |
--content |
string |
No | Schedule definition content (inline JSON) |
Examples
fabio lakehouse create-materialized-views-schedule --workspace $WS --id $LAKEHOUSE_ID --content '{"startDateTime":"2025-01-01T02:00:00","interval":1440,"enabled":true}'fabio lakehouse create-materialized-views-schedule --workspace $WS --id $LAKEHOUSE_ID --content '{"startDateTime":"2025-01-01T02:00:00","interval":1440,"enabled":true,"executionData":{"mlvExecutionDefinitionId":"$DEF_ID"}}'Mutates state · Returns object
update-materialized-views-schedule
Section titled “update-materialized-views-schedule”Update a schedule for materialized lake view refresh
fabio lakehouse update-materialized-views-schedule --workspace <value> --id <value> --schedule-id <value>| Flag | Type | Required | Description |
|---|---|---|---|
--workspace |
string |
Yes | Workspace ID |
--id |
string |
Yes | Lakehouse ID |
--schedule-id |
string |
Yes | Schedule ID |
--file |
string |
No | Schedule definition file path (JSON) |
--content |
string |
No | Schedule definition content (inline JSON) |
Examples
fabio lakehouse update-materialized-views-schedule --workspace $WS --id $LAKEHOUSE_ID --schedule-id $SCHED_ID --content '{"enabled":false}'fabio lakehouse update-materialized-views-schedule --workspace $WS --id $LAKEHOUSE_ID --schedule-id $SCHED_ID --content '{"executionData":{"mlvExecutionDefinitionId":"$DEF_ID"}}'Mutates state · Returns void
delete-materialized-views-schedule
Section titled “delete-materialized-views-schedule”Delete a schedule for materialized lake view refresh
fabio lakehouse delete-materialized-views-schedule --workspace <value> --id <value> --schedule-id <value>| Flag | Type | Required | Description |
|---|---|---|---|
--workspace |
string |
Yes | Workspace ID |
--id |
string |
Yes | Lakehouse ID |
--schedule-id |
string |
Yes | Schedule ID |
Examples
fabio lakehouse delete-materialized-views-schedule --workspace $WS --id $LAKEHOUSE_ID --schedule-id $SCHED_IDMutates state · Destructive · Returns void
list-execution-definitions
Section titled “list-execution-definitions”List materialized lake view execution definitions for a lakehouse
fabio lakehouse list-execution-definitions --workspace <value> --id <value>| Flag | Type | Required | Description |
|---|---|---|---|
--workspace |
string |
Yes | Workspace ID |
--id |
string |
Yes | Lakehouse ID |
Examples
fabio lakehouse list-execution-definitions --workspace $WS --id $LAKEHOUSE_IDRead-only · Returns list
show-execution-definition
Section titled “show-execution-definition”Show a materialized lake view execution definition
fabio lakehouse show-execution-definition --workspace <value> --id <value> --execution-definition-id <value>| Flag | Type | Required | Description |
|---|---|---|---|
--workspace |
string |
Yes | Workspace ID |
--id |
string |
Yes | Lakehouse ID |
--execution-definition-id |
string |
Yes | Materialized lake view execution definition ID |
Examples
fabio lakehouse show-execution-definition --workspace $WS --id $LAKEHOUSE_ID --execution-definition-id $DEF_IDRead-only · Returns object
create-execution-definition
Section titled “create-execution-definition”Create a materialized lake view execution definition
fabio lakehouse create-execution-definition --workspace <value> --id <value>| Flag | Type | Required | Description |
|---|---|---|---|
--workspace |
string |
Yes | Workspace ID |
--id |
string |
Yes | Lakehouse ID |
--file |
string |
No | Execution definition file path (JSON, must include displayName and currentLakehouseExecutionContext) |
--content |
string |
No | Execution definition content (inline JSON) |
Examples
fabio lakehouse create-execution-definition --workspace $WS --id $LAKEHOUSE_ID --content '{"displayName":"nightly-refresh","currentLakehouseExecutionContext":{"mode":"All"}}'Mutates state · Returns object
update-execution-definition
Section titled “update-execution-definition”Update a materialized lake view execution definition
fabio lakehouse update-execution-definition --workspace <value> --id <value> --execution-definition-id <value>| Flag | Type | Required | Description |
|---|---|---|---|
--workspace |
string |
Yes | Workspace ID |
--id |
string |
Yes | Lakehouse ID |
--execution-definition-id |
string |
Yes | Materialized lake view execution definition ID |
--file |
string |
No | Execution definition file path (JSON, only provided fields are updated) |
--content |
string |
No | Execution definition content (inline JSON) |
Examples
fabio lakehouse update-execution-definition --workspace $WS --id $LAKEHOUSE_ID --execution-definition-id $DEF_ID --content '{"description":"Updated"}'Mutates state · Returns void
delete-execution-definition
Section titled “delete-execution-definition”Delete a materialized lake view execution definition
fabio lakehouse delete-execution-definition --workspace <value> --id <value> --execution-definition-id <value>| Flag | Type | Required | Description |
|---|---|---|---|
--workspace |
string |
Yes | Workspace ID |
--id |
string |
Yes | Lakehouse ID |
--execution-definition-id |
string |
Yes | Materialized lake view execution definition ID |
Examples
fabio lakehouse delete-execution-definition --workspace $WS --id $LAKEHOUSE_ID --execution-definition-id $DEF_IDMutates state · Destructive · Returns void
run-table-maintenance
Section titled “run-table-maintenance”Run table maintenance on a lakehouse
fabio lakehouse run-table-maintenance --workspace <value> --id <value>| Flag | Type | Required | Description |
|---|---|---|---|
--workspace |
string |
Yes | Workspace ID |
--id |
string |
Yes | Lakehouse ID |
--file |
string |
No | Configuration file path (optional JSON) |
--content |
string |
No | Configuration content (optional inline JSON) |
Mutates state · Returns object
optimize-table
Section titled “optimize-table”Optimize a Delta table (V-Order compaction + optional Z-Order)
fabio lakehouse optimize-table --workspace <value> --id <value> --table <value>| Flag | Type | Required | Description |
|---|---|---|---|
--workspace |
string |
Yes | Workspace ID |
--id |
string |
Yes | Lakehouse ID |
--table |
string |
Yes | Table name to optimize |
--schema |
string |
No | Schema name (for multi-schema lakehouses) |
--vorder |
bool |
No | Enable V-Order optimization Default: true. |
--zorder |
string |
No | Columns for Z-Order clustering (comma-separated) |
Mutates state · Returns object
vacuum-table
Section titled “vacuum-table”Vacuum a Delta table (remove old files beyond retention period)
fabio lakehouse vacuum-table --workspace <value> --id <value> --table <value>| Flag | Type | Required | Description |
|---|---|---|---|
--workspace |
string |
Yes | Workspace ID |
--id |
string |
Yes | Lakehouse ID |
--table |
string |
Yes | Table name to vacuum |
--schema |
string |
No | Schema name (for multi-schema lakehouses) |
--retain-hours |
integer |
No | Retention period in hours (default: 168 = 7 days) Default: 168. |
Mutates state · Destructive · Returns object
table-schema
Section titled “table-schema”Show Delta table schema (reads from OneLake _delta_log without Spark/SQL)
fabio lakehouse table-schema --workspace <value> --id <value> --table <value>| Flag | Type | Required | Description |
|---|---|---|---|
--workspace |
string |
Yes | Workspace ID |
--id |
string |
Yes | Lakehouse ID |
--table |
string |
Yes | Table name |
Read-only · Returns object
iceberg-config
Section titled “iceberg-config”Get Iceberg REST Catalog configuration for a lakehouse
fabio lakehouse iceberg-config --workspace <value> --id <value>| Flag | Type | Required | Description |
|---|---|---|---|
--workspace |
string |
Yes | Workspace ID |
--id |
string |
Yes | Lakehouse ID |
Examples
fabio lakehouse iceberg-config --workspace $WS --id $LHRead-only · Returns object
iceberg-namespaces
Section titled “iceberg-namespaces”List table namespaces (schemas) via the Iceberg REST Catalog
fabio lakehouse iceberg-namespaces --workspace <value> --id <value>| Flag | Type | Required | Description |
|---|---|---|---|
--workspace |
string |
Yes | Workspace ID |
--id |
string |
Yes | Lakehouse ID |
Examples
fabio lakehouse iceberg-namespaces --workspace $WS --id $LHRead-only · Returns object
iceberg-namespace
Section titled “iceberg-namespace”Get metadata for a specific namespace via the Iceberg REST Catalog
fabio lakehouse iceberg-namespace --workspace <value> --id <value> --namespace <value>| Flag | Type | Required | Description |
|---|---|---|---|
--workspace |
string |
Yes | Workspace ID |
--id |
string |
Yes | Lakehouse ID |
--namespace |
string |
Yes | Namespace name (e.g. “dbo”) |
Read-only · Returns object
iceberg-tables
Section titled “iceberg-tables”List tables in a namespace via the Iceberg REST Catalog
fabio lakehouse iceberg-tables --workspace <value> --id <value> --namespace <value>| Flag | Type | Required | Description |
|---|---|---|---|
--workspace |
string |
Yes | Workspace ID |
--id |
string |
Yes | Lakehouse ID |
--namespace |
string |
Yes | Namespace name (e.g. “dbo”) |
Examples
fabio lakehouse iceberg-tables --workspace $WS --id $LH --namespace dboRead-only · Returns object
iceberg-table
Section titled “iceberg-table”Get table definition (schema, partitions, properties) via the Iceberg REST Catalog
fabio lakehouse iceberg-table --workspace <value> --id <value> --namespace <value> --table <value>| Flag | Type | Required | Description |
|---|---|---|---|
--workspace |
string |
Yes | Workspace ID |
--id |
string |
Yes | Lakehouse ID |
--namespace |
string |
Yes | Namespace name (e.g. “dbo”) |
--table |
string |
Yes | Table name |
Examples
fabio lakehouse iceberg-table --workspace $WS --id $LH --namespace dbo --table customersfabio lakehouse iceberg-table --workspace $WS --id $LH --namespace dbo --table sales --query "metadata.schemas[-1].fields[].{name: name, type: type}"Read-only · Returns object
iceberg-table-exists
Section titled “iceberg-table-exists”Check if a table exists via the Iceberg REST Catalog (lightweight HEAD)
fabio lakehouse iceberg-table-exists --workspace <value> --id <value> --namespace <value> --table <value>| Flag | Type | Required | Description |
|---|---|---|---|
--workspace |
string |
Yes | Workspace ID |
--id |
string |
Yes | Lakehouse ID |
--namespace |
string |
Yes | Namespace name (e.g. “dbo”) |
--table |
string |
Yes | Table name |
Examples
fabio lakehouse iceberg-table-exists --workspace $WS --id $LH --namespace dbo --table salesRead-only · Returns object
iceberg-namespace-exists
Section titled “iceberg-namespace-exists”Check if a namespace exists via the Iceberg REST Catalog (lightweight HEAD)
fabio lakehouse iceberg-namespace-exists --workspace <value> --id <value> --namespace <value>| Flag | Type | Required | Description |
|---|---|---|---|
--workspace |
string |
Yes | Workspace ID |
--id |
string |
Yes | Lakehouse ID |
--namespace |
string |
Yes | Namespace name (e.g. “dbo”) |
Read-only · Returns object
iceberg-credentials
Section titled “iceberg-credentials”Load vended storage credentials scoped to a specific table
fabio lakehouse iceberg-credentials --workspace <value> --id <value> --namespace <value> --table <value>| Flag | Type | Required | Description |
|---|---|---|---|
--workspace |
string |
Yes | Workspace ID |
--id |
string |
Yes | Lakehouse ID |
--namespace |
string |
Yes | Namespace name (e.g. “dbo”) |
--table |
string |
Yes | Table name |
Examples
fabio lakehouse iceberg-credentials --workspace $WS --id $LH --namespace dbo --table salesRead-only · Returns object
iceberg-stats
Section titled “iceberg-stats”Show table statistics from the latest Iceberg snapshot (record/file counts, size)
fabio lakehouse iceberg-stats --workspace <value> --id <value> --namespace <value> --table <value>| Flag | Type | Required | Description |
|---|---|---|---|
--workspace |
string |
Yes | Workspace ID |
--id |
string |
Yes | Lakehouse ID |
--namespace |
string |
Yes | Namespace name (e.g. “dbo”) |
--table |
string |
Yes | Table name |
Examples
fabio lakehouse iceberg-stats --workspace $WS --id $LH --namespace dbo --table salesRead-only · Returns object
iceberg-snapshots
Section titled “iceberg-snapshots”Show snapshot history for a table via the Iceberg REST Catalog
fabio lakehouse iceberg-snapshots --workspace <value> --id <value> --namespace <value> --table <value>| Flag | Type | Required | Description |
|---|---|---|---|
--workspace |
string |
Yes | Workspace ID |
--id |
string |
Yes | Lakehouse ID |
--namespace |
string |
Yes | Namespace name (e.g. “dbo”) |
--table |
string |
Yes | Table name |
Examples
fabio lakehouse iceberg-snapshots --workspace $WS --id $LH --namespace dbo --table salesRead-only · Returns object
list-livy-sessions
Section titled “list-livy-sessions”List Livy sessions for a lakehouse
fabio lakehouse list-livy-sessions --workspace <value> --id <value>| Flag | Type | Required | Description |
|---|---|---|---|
--workspace |
string |
Yes | Workspace ID |
--id |
string |
Yes | Lakehouse ID |
Read-only · Returns list
get-livy-session
Section titled “get-livy-session”Get details of a Livy session for a lakehouse
fabio lakehouse get-livy-session --workspace <value> --id <value> --livy-id <value>| Flag | Type | Required | Description |
|---|---|---|---|
--workspace |
string |
Yes | Workspace ID |
--id |
string |
Yes | Lakehouse ID |
--livy-id |
string |
Yes | Livy session ID |
Read-only · Returns object