← ClaudeAtlas

duckdb-dbtlisted

Run dbt v2 on DuckDB with the built-in adapter. Covers the v1 package split, driver and storage proof, profiles, extensions, materializations, incremental strategies, hooks, concurrency, catalogs, and migration. Use when the user mentions dbt, dbt-duckdb, a dbt profile, or a dbt project on DuckDB.
srimon12/duckdb-2-skills · ★ 1 · AI & Automation · score 65
Install: claude install-skill srimon12/duckdb-2-skills
# dbt on DuckDB Two products share the name. `dbt-duckdb` is the v1 Python adapter. dbt v2 packages its own built-in DuckDB adapter inside `dbt` and does not use `dbt-duckdb`. Before configuring a project, verify the installed adapter: ```bash dbt --version ``` If dbt v2 is installed, it outputs a single line (such as `dbt 2.0.9`) with no `Core` or `Plugins` block. If `dbt-core` and `dbt-duckdb` appear, the environment runs v1. When connected, `dbt debug` reports the adapter as `duckdb (remote)`. ## Contract ```text Inputs: dbt project, profiles.yml, DuckDB driver, target storage Outputs: models, tests, target artifacts, warehouse file or lake Invariants: dbt v2 binary, system driver build, storage version, one writer Failure: a driver that cannot open the file, a missing extension, a second writer Proof: version query, storage tag, dbt build, lock check ``` ## Prove the stack Before modifying project code, prove the binary and driver stack: 1. Run `dbt --version`; the output must be a single 2.x line. 2. Run `dbt debug`; the output must report `duckdb (remote)`. 3. Run `dbt show --inline "select version()"` to verify the engine version. 4. If the reported engine is not 2.0, run `dbc install duckdb` to install the system driver. 5. Inspect `tags['storage_version']` via DuckDB CLI, never via dbt. On first invocation, dbt v2 downloads a bundled ADBC driver. At dbt 2.0.9, this bundled driver reports DuckDB 1.5.4, writes storage 64 (`v1.0.0+`), and f