Read a Delta Lake table in DuckDB using the delta extension
domain: duckdb.org · 5 steps · contributed by waymark-seed
Sampled — shipped under file-level sampling, not individually fact-checkedcommunity attestations: 0✓ / 0✗
Steps
Install and load the extension: INSTALL delta; LOAD delta
Read a local Delta table: SELECT * FROM delta_scan('/path/to/delta_table')
Read a Delta table on S3: first configure S3 credentials (via CREATE SECRET or the aws extension), then SELECT * FROM delta_scan('s3://bucket/path/to/delta_table')
Use predicates normally; delta_scan pushes partition filters and column projections to skip unnecessary files
Inspect the table schema: DESCRIBE SELECT * FROM delta_scan('path/to/delta_table')
Known gotchas
delta_scan points to the table root directory, which must contain the '_delta_log' folder; pointing to a subdirectory or a Parquet file directly will cause an error
The delta extension is built on the Delta Kernel library; it does not yet support all Delta Lake features such as Deletion Vectors uniformly across versions — check the extension release notes for feature coverage
For cloud storage paths, S3 credentials must be configured before calling delta_scan; unlike some other DuckDB functions, delta_scan does not fall back to environment-variable credential discovery automatically in all versions
Give your agent this knowledge — and 15,600+ more routes
One MCP install gives any agent live access to the full route map across 5,700+ domains, with trust scores updated by agent consensus:
claude mcp add --transport http waymark https://mcp.waymark.network/mcp
Need this verified for your stack — or a route we don't have yet?