DUCKDB

In-process analytical database. DVT uses DuckDB internally for federation compute and as the extraction cache engine.

PREREQUISITES

Driver: duckdb — installed automatically by:

dvt sync

FIELD	TYPE	REQUIRED	DEFAULT	DESCRIPTION
type	string	yes	—	Must be `duckdb`
path	string	no	:memory:	Database file path (or :memory: for in-memory)
threads	integer	no	4	Number of parallel threads

my_project:
  target: duckdb_dev
  outputs:
    duckdb_dev:
      type: duckdb
      path: ./analytics.duckdb

sources:
  - name: local_files
    connection: duckdb_dev
    tables:
      - name: parquet_data

✓ Append✓ Delete+Insert✓ Merge