Skip to content

duckdb

etl_craft.dialects.warehouse.duckdb

DuckDB warehouse, native tables in one file.

DuckDBWarehouse

Bases: WarehouseDialect

DuckDB, native tables in one file.

Only one process may write a DuckDB file at a time, so warehouse access is queued.

timestamp_text

timestamp_text(value: str, kind: str) -> str

Normalize aware timestamps explicitly, including after a timezone change.

replacement_comment

replacement_comment(conn: Connection, target: str) -> str | None

Read the native table's comment before replacing its definition.

full_column_types

full_column_types(conn: Connection, table: str) -> dict[str, str]

DuckDB's information schema retains precision and complete nested types.