Akshay Subramanian

Results 8 comments of Akshay Subramanian

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

After a little more digging you are correct views do work. When I wrap my view in a CTE however it fails. From this thread it looks like duckdb does...

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

Yes I'm doing the same: ``` WITH cte_expr AS ( SELECT tablename.first_select, tablename.second_select FROM schemaname.tablename ) SELECT * FROM cte_expr ``` When I add the tag: `+materialized: table` then I...

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

Sorry I should have been more clear. Yes the dbt run call succeeds. I think the view successfully gets created as well (I can see the view in Dbeaver). When...

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

sorry again I am not being specific enough. I am specifying the schema name: **materialized as view** ``` >>> con.execute("SELECT * FROM dev_asubramanian.tablename") Traceback (most recent call last): File "",...

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

It is a schema I created (unique schema for testing). But it has the same issue. ``` ### >>> con.execute("SELECT * FROM dev_asubramanian_1669766215.tablename") Traceback (most recent call last): File "",...

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

I am seeing issues when I try to open up the db with the duckdb cli: `./duckdb -init $HOME/analytics/dbt/gpa.duckdb` ``` Error: near line 1: Parser Error: syntax error at or...

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

just ignorance. How do I initialize an in-memory db from an existing duckdb file?

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

oh that is much simpler, thank you!