demo-dbt-duckdb-external-materialization

This project should show case all of the external materializations provided in the dbt-duckdb

Setup

• Adapt profile file to write to a database:

path: "./database.duckdb"

• To create base data outcomment the following line in the dbt_project.yaml

on-run-start: "INSTALL tpch; LOAD tpch; CALL dbgen(sf = 1);"

• start the first model to create the data

dbt run -select setup

Structure

List of the options

• files

  • parquet (direct) (default)
    • todo?
  • json
  • csv

• Plugins

  • sqlalchemy (via pandas)
  • excel (via pandas)