dbt-duckdb icon indicating copy to clipboard operation
dbt-duckdb copied to clipboard

Published 20 hours ago • verified publisher icon duckdb

DuckDB relation failing as Python model return type

Open Soloniss opened this issue 1 year ago • 1 comments

When returning a DuckDB relation as a return type for my python model I get an error stating that the dataframe cannot be found

Catalog Error: Table with name df does not exist! Did you mean "pg_depend"? LINE 1: ... my_transform__dbt_tmp" as select * from df

However, after converting the relation to a pandas dataframe or arrow table, things work as expected. My assumption is there's something wrong with the DuckDB connection which closes the relation, or the relation being out of scope. Any tips here?

Soloniss avatar Oct 31 '24 22:10 Soloniss