delta_classic

Search Shortcut cmd + k | ctrl + k

Documentation

delta_classic

Downloads 386this week

GitHub stars 5

Extension repository on GitHub

Extension descriptor (YAML)

Attach a directory of Delta tables as a single DuckDB database with automatic schema discovery

Maintainer(s): djouallah

Installing and Loading

INSTALL delta_classic FROM community;
LOAD delta_classic;

Example

-- Load required extensions
LOAD delta;
LOAD delta_classic;

-- Attach a directory of Delta tables as a single database
ATTACH '/path/to/delta/tables' AS mydb (TYPE delta_classic);

-- Query tables directly
SELECT * FROM mydb.main.orders LIMIT 10;

Delta Classic lets you attach a directory of Delta Lake tables as a single DuckDB database, instead of attaching each table individually. It discovers tables by scanning for subdirectories containing a _delta_log folder.

The extension supports two directory layouts:

Single-schema: the attached path directly contains Delta tables
Multi-schema: the attached path contains subdirectories, each treated as a schema, with Delta tables inside them

All Delta reading is delegated to the existing Delta extension via internal ATTACH … (TYPE DELTA). Supports PIN_SNAPSHOT and all storage backends (local filesystem, S3, ABFSS, GCS).