fdl — Frozen DuckLake CLI
Manage Frozen DuckLake catalogs — place a DuckLake catalog + Parquet files on object storage and anyone can query with a single DuckDB ATTACH. No database server required.
Quick Start
pip install frozen-ducklake
mkdir my_dataset && cd my_dataset
fdl init my_dataset
Add data, push, and serve:
fdl sql default "CREATE TABLE cities (name VARCHAR, country VARCHAR, pop INTEGER)"
fdl sql default "INSERT INTO cities VALUES ('Tokyo', 'Japan', 14000000), ('Shanghai', 'China', 24900000)"
fdl push default
fdl serve default
Query from DuckDB:
duckdb -c "ATTACH 'ducklake:http://localhost:4001/my_dataset/ducklake.duckdb' AS my_dataset;
SELECT * FROM my_dataset.main.cities ORDER BY pop DESC;"
Features
- init / push / pull — Git-like catalog management with conflict detection
- sql — Query and modify data directly from the command line
- run — Execute any command (dbt, dlt, Python) with auto-injected storage credentials
- expire — Snapshot retention and storage cleanup, runs automatically after writes
- serve — Built-in HTTP server with CORS and Range request support
- Python API — Call the same operations in-process from Dagster, Airflow, etc.
- Works with S3-compatible storage (AWS S3, Cloudflare R2, GCS, etc) and local directories
Install
pip install frozen-ducklake # pip
uv tool install frozen-ducklake # uv (recommended)
pipx install frozen-ducklake # pipx
Documentation
License
MIT
Metadata
Release files for frozen-ducklake 0.11.0
For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.
Source distribution (sdist)
| File | Size | Uploaded | Provenance | |
|---|---|---|---|---|
| frozen_ducklake-0.11.0.tar.gz | 117.1 kB | With provenance | Details |
Built distribution (wheel)
| File | Interpreter | ABI | Platform | Reset |
|---|---|---|---|---|
| frozen_ducklake-0.11.0-py3-none-any.whl | Python 3 | none | any | Details |
Total release size: 148.8 kB
Release files / frozen_ducklake-0.11.0.tar.gz
| Download URL | frozen_ducklake-0.11.0.tar.gz |
|---|---|
| Size | 117.1 kB |
| Tags | Source |
|
SHA-256 checksum How to use checksums |
cc429da583ed0b522c4883da333fa126df2927f4b34249506330b24f30fd41fd
|
|
BLAKE2b-256 checksum How to use checksums |
120b35c8ee37d29095ea8b2fb62036758c7967693770ff27a9703546ae23acd1
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
Yes |
| Uploaded via |
twine/6.1.0 CPython/3.13.12
|
Provenance
Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.
PyPI Publish Attestation
PyPI verified that this artifact, at this checksum, originated from the publisher listed below.
Signed by GitHub Actions, verified by PyPI on Jul 11, 2026.
Transparency logRelease files / frozen_ducklake-0.11.0-py3-none-any.whl
| Download URL | frozen_ducklake-0.11.0-py3-none-any.whl |
|---|---|
| Size | 31.7 kB |
| Tags | Python 3 |
|
SHA-256 checksum How to use checksums |
647d12a44c3e688436185d2df3eb5363708ef01a384768ff16274e237e4062ba
|
|
BLAKE2b-256 checksum How to use checksums |
838224878751a2ec55f4aab23363c9ba985fd50e916105c4115911f5067fdd51
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
Yes |
| Uploaded via |
twine/6.1.0 CPython/3.13.12
|
Provenance
Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.
PyPI Publish Attestation
PyPI verified that this artifact, at this checksum, originated from the publisher listed below.
Signed by GitHub Actions, verified by PyPI on Jul 11, 2026.
Transparency logSecurity for frozen-ducklake 0.11.0
Provenance
Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.
Full provenance
All 2 files in this release have been uploaded with provenance metadata.
Attestation for frozen_ducklake-0.11.0.tar.gz
PyPI Publish Attestation
PyPI verified that this artifact, at this checksum, originated from the publisher listed below.
Signed by GitHub Actions, verified by PyPI on Jul 11, 2026.
Transparency logA note on package security
PyPI is a repository for distributing packages, not a service for auditing them. While third-party security researchers and our staff do their best to detect and remove malicious packages, PyPI cannot guarantee the quality, security or suitability of any given package.
To learn more about protecting yourself from malicious actors, visit our package security documentation.