Josh Wills comments

Results 174 comments of


                                            Josh Wills

Dbt models that are materialized as views result in catalog error (table cannot be found)

hrm, that surprises me, we test that logic pretty thoroughly I just verified it works locally; can you post your `duckdb` config from `profiles.yml` and the version of dbt-duckdb you're...

Dbt models that are materialized as views result in catalog error (table cannot be found)

I don't understand- how do you wrap a view in a CTE? Isn't it dbt's job to turn the SELECT query into a view for you? I do stuff like:...

Dbt models that are materialized as views result in catalog error (table cannot be found)

Yeah I can't get it to fail, here's what I'm running with: An `ingest.sql` model: ``` {{ config(materialized='view') }} WITH input AS ( select * from {{ source('csvs', 'test') }}...

Dbt models that are materialized as views result in catalog error (table cannot be found)

oh interesting-- I always query `SELECT * FROM .`; maybe that's the difference? And you're saying for some reason `SELECT * FROM ` works correctly _unless_ the view in question...

Dbt models that are materialized as views result in catalog error (table cannot be found)

(For relations that aren't defined in the `main` schema, which is the default for DuckDB)

Dbt models that are materialized as views result in catalog error (table cannot be found)

hrm, and I'm assuming "dev_asubramanian_1669766215" isn't a schema you created?

Dbt models that are materialized as views result in catalog error (table cannot be found)

well that is really weird. I almost wonder if there is like a character encoding issue somewhere-- for whatever reason, DuckDB doesn't seem to believe that the name of that...

Dbt models that are materialized as views result in catalog error (table cannot be found)

I think it’s having issues replaying the WAL which again might be an encoding-related problem

Dbt models that are materialized as views result in catalog error (table cannot be found)

He's asking about the cli tho, which is just `duckdb /path/to/the/existing/file.db` Thank you @Mause for spotting the `-init` arg that I missed!

refactoring-external-materialization

Ah these are all good questions, will inline some comments shortly