datafusion-ducklake-cli

datafusion-ducklake-cli installs ducklake-cli, an interactive and scriptable SQL shell for datafusion-ducklake-provider.

cargo install datafusion-ducklake-cli
ducklake-cli --execute "SELECT 1"

Use DuckLake SQL to attach catalogs:

ducklake-cli
ducklake> ATTACH 'ducklake:sqlite:metadata.sqlite' AS lake (DATA_PATH 'data/');
ducklake> SELECT * FROM lake.main.numbers;

For S3-compatible object stores, install with the feature and register the store before attaching a catalog whose DATA_PATH points at s3://...:

cargo install datafusion-ducklake-cli --features object-store-s3
DUCKLAKE_S3_ENDPOINT=http://localhost:9000 \
DUCKLAKE_S3_ACCESS_KEY_ID=minioadmin \
DUCKLAKE_S3_SECRET_ACCESS_KEY=minioadmin \
ducklake-cli \
  --object-store-url s3://my-bucket \
  --s3-region us-east-1 \
  --s3-allow-http true \
  --s3-path-style

See the repository docs/cli.md and docs/sql-reference.md files for the full command reference and supported DuckLake SQL surface.

datafusion-ducklake-cli 0.2.0

datafusion-ducklake-cli