datafusion-ducklake-cli 0.1.0

Interactive and scriptable SQL shell for datafusion-ducklake-provider.
Documentation 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35

# datafusion-ducklake-cli

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

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

Use DuckLake SQL to attach catalogs:

```sh
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://...`:

```sh
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.