duckdb-dbtlisted
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