This is the experimental DuckDB extension for Delta. It is built using the (also experimental) Delta Kernel. The extension (currently) offers read support for delta tables, both local and remote.
The supported platforms are:
linux_amd64
andlinux_amd64_gcc4
osx_amd64
andosx_arm64
Support for the other DuckDB platforms is work-in-progress
NOTE: this extension requires the latest stable version of DuckDB, v0.10.3.
This extension is distributed as a binary extension. To use it, simply use one of its functions from DuckDB and the extension will be autoloaded:
FROM delta_scan('s3://some/delta/table');
Note that using DuckDB Secrets for S3 authentication is supported:
CREATE SECRET (TYPE S3, provider credential_chain);
FROM delta_scan('s3://some/delta/table/with/auth');
To scan a local table, use the full path prefixes with file://
FROM delta_scan('file:///some/path/on/local/machine');
While still experimental, many (scanning) features/optimizations are already supported in this extension as it reuses most of DuckDB's regular parquet scanning logic:
- multithreaded scans and parquet metadata reading
- data skipping/filter pushdown
- skipping row-groups in file (based on parquet metadata)
- skipping complete files (based on delta partition info)
- projection pushdown
- scanning tables with deletion vectors
- all primitive types
- structs
- S3 support with secrets
More features coming soon!
See the Extension Template for generic build instructions
There are various tests available for the delta extension:
- Delta Acceptence Test (DAT) based tests in
/test/sql/dat
- delta-kernel-rs based tests in
/test/sql/delta_kernel_rs
- Generated data based tests in
tests/sql/generated
(generated using delta-rs, PySpark, and DuckDB)
To run the first 2 sets of tests:
make test_debug
or in release mode
make test
To also run the tests on generated data:
make generate-data
GENERATED_DATA_AVAILABLE=1 make test