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)