jwills / target-duckdb

A Singer.io target for DuckDB
Other
17 stars 12 forks source link

Using :memory: as database path prevents dbt models from referencing each other. #14

Closed matsonj closed 1 year ago

matsonj commented 1 year ago

Describe the bug dbt models cannot see each other when using the :memory: database.

To Reproduce Steps to reproduce the behavior:

  1. create two models. table_one.sql & table_two.sql
  2. table_one.sql should be "SELECT 'test' AS value".
  3. table_two.sql should be "SELECT * FROM {{ ref( 'table_one' ) }}
  4. table_two will fail to build with following error: "Catalog Error: Table with name table_one does not exist"

Expected behavior dbt build should succeed.

Screenshots If applicable, add screenshots to help explain your problem.

Your environment

matsonj commented 1 year ago

oh crap wrong repo.