duckdb / dbt-duckdb

dbt (http://getdbt.com) adapter for DuckDB (http://duckdb.org)
Apache License 2.0
932 stars 89 forks source link

Data placed in 'main_' prefixed schema #457

Closed rossbowen closed 1 month ago

rossbowen commented 1 month ago

Whenever I specify a schema, e.g. raw, the data gets placed in a schema prefixed with main_, e.g. main_raw.

Take jaffle_shop_duckdb, if I specify a schema for my seeds to be placed into:

seeds: 
  +docs:
    node_color: '#cd7f32'
  +schema: seeds

I'd expect data to land in seeds.raw_customers but instead it lands in main_seeds.raw_customers.

jwills commented 1 month ago

yah this is a standard dbt thing https://docs.getdbt.com/docs/build/custom-schemas