fabric-cli

table examples

Supported commands: fab table -h

Checking Delta table schema

Display the schema of a Delta table in .Lakehouse, .Warehouse, .MirroredDatabase, .SemanticModel (requires enable), .SQLDatabase and .KQLDatabase (requires enable).

fab:/ws1.Workspace$ table schema lh1.Lakehouse/Tables/dbo/tdelta
fab:/ws1.Workspace$ table schema wh1.Warehouse/Tables/dbo/tdelta
fab:/ws1.Workspace$ table schema mir1.MirroredDatabase/Tables/dbo/tdelta
fab:/ws1.Workspace$ table schema sm1.SemanticModel/Tables/tdelta
fab:/ws1.Workspace$ table schema sql1.SQLDatabase/Tables/dbo/tdelta
fab:/ws1.Workspace$ table schema kql1.KQLDatabase/Tables/tdelta

Loading parquet/csv data into a Lakehouse Delta table

Load data into a Lakehouse table. Not yet supported in schema-enabled Lakehouse.

# [csv] load table from folder
fab:/ws1.Workspace/lh1.Lakehouse$ table load Tables/tdeltacsv --file Files/csv

# [csv] load table from specific file, using append mode
fab:/ws1.Workspace/lh1.Lakehouse$ table load Tables/tdeltacsv --file Files/csv/employees.csv --mode append

# [csv] load table with different delimiter and no header
fab:/ws1.Workspace/lh1.Lakehouse$ table load Tables/tdeltacsvnoh --file Files/csvnoh --format format=csv,header=false,delimiter=';'

# [parquet] load using parquet format
fab:/ws1.Workspace/lh1.Lakehouse$ table load Tables/tdeltaparquet --file Files/parquet --format format=parquet --mode append

# [parquet] using extension to filter
fab:/ws1.Workspace/lh1.Lakehouse$ table load Tables/tdeltaparquet --file Files/parquet --format format=parquet --extension '.parquet'

Optimizing Lakehouse Delta tables

Optimize a Delta table in the Lakehouse. Lakehouse only.

# run table optimize compaction
fab:/ws1.Workspace/lh1.Lakehouse$ table optimize Tables/tdelta

# run table optimize with vorder and zorder
fab:/ws1.Workspace/lh1.Lakehouse$ table optimize Tables/tdelta --vorder --zorder col1,col2

Vacuuming Lakehouse Delta tables

Vacuum a Delta table in the Lakehouse by removing old files. Lakehouse only.

# vacuum a table (defaul 7 days)
fab:/ws1.Workspace/lh1.Lakehouse$ table vacuum Tables/tdelta

# vacuum a table, custom retention period in hours
fab:/ws1.Workspace/lh1.Lakehouse$ table vacuum Tables/tdelta --retain_n_hours 182

See all examples