Skip to content

CLI Reference

tab view

View tabular data from a data file in a rich CLI format, or a directory of partitions of data files.

Paths may also use glob patterns such as data/date=*/*.parquet or s3://bucket/path/date=2026-01-*/*.

tab view $path [OPTIONS]

Options:

Option Description
-i / --input-format Input format (parquet, csv, tsv, jsonl, avro, sqlite, duckdb). Auto-detected from extension if omitted. SQLite and DuckDB input use {url}#{table_name}.
--sql SQL query to apply before displaying. The table is available as t. Mutually exclusive with --jmespath.
--jmespath / --jp JMESPath expression to apply to each row as JSON. Object outputs become columns; non-object outputs go to a value column. The result shape must stay consistent across rows.
--limit Maximum number of rows to display.
--skip Number of rows to skip from the beginning.
--max-cell-length Truncate cell contents longer than this. If omitted, max_cell_length from config is used when set.

tab schema

Display the schema of a tabular data file.

Paths may also use glob patterns.

tab schema $path [OPTIONS]

Options:

Option Description
-i / --input-format Input format (parquet, csv, tsv, jsonl, avro, sqlite, duckdb). Auto-detected from extension if omitted. SQLite and DuckDB input use {url}#{table_name}.

tab summary

Display summary information about a tabular data file.

Paths may also use glob patterns.

tab summary $path [OPTIONS]

Options:

Option Description
-i / --input-format Input format (parquet, csv, tsv, jsonl, avro, sqlite, duckdb). Auto-detected from extension if omitted. SQLite and DuckDB input use {url}#{table_name}.

tab convert

Convert tabular data from one format to another.

Input paths may also use glob patterns when the input format supports multi-file reads.

tab convert $src $dst [OPTIONS]

Options:

Option Description
-i / --input-format Input format (parquet, csv, tsv, jsonl, avro, sqlite, duckdb). Auto-detected from extension if omitted. SQLite and DuckDB input use {url}#{table_name}.
-o / --output-format Output format (parquet, csv, tsv, jsonl, avro). If not specified, inherits from input format.
--sql SQL query to apply before writing. The table is available as t. Mutually exclusive with --jmespath.
--jmespath / --jp JMESPath expression to apply to each row as JSON. Object outputs become columns; non-object outputs go to a value column. The result shape must stay consistent across rows.
-n / --num-partitions Number of output partitions. Creates a directory with partition files.

tab cat

Concatenate tabular data from multiple files.

Input paths may also use glob patterns.

tab cat $paths [OPTIONS]

Options:

Option Description
-i / --input-format Input format (parquet, csv, tsv, jsonl, avro, sqlite, duckdb). Auto-detected from extension if omitted. SQLite and DuckDB input use {url}#{table_name}.
-o / --output-format Output format (parquet, csv, tsv, jsonl, avro). If not specified, print Rich table in terminal.
--sql SQL query to apply after concatenation. The table is available as t. Mutually exclusive with --jmespath.
--jmespath / --jp JMESPath expression to apply to each row as JSON. Object outputs become columns; non-object outputs go to a value column. The result shape must stay consistent across rows.

Global options

Option Description
--az-url-authority-is-account Interpret az:// URL authority as storage account name instead of container name. See Cloud for more information.
--log-level Log level from {DEBUG, INFO, WARNING, ERROR, CRITICAL}. If omitted, uses log_level from config.