[CT-2880] Defer not working with dbt 1.4 and 1.5

dbt-labs / dbt-rpc

A server that can compile and run queries in the context of a dbt project. Additionally, it provides methods that can be used to list and terminate running processes.

https://docs.getdbt.com/reference/commands/rpc

Apache License 2.0

19 stars 8 forks source link

[CT-2880] Defer not working with dbt 1.4 and 1.5 #147

Closed gshank closed 1 year ago

gshank commented 1 year ago

The ref in a model used with defer is not resolving properly for dbt 1.4.

dbt run -s baz --defer --state prod

In 1.3 it uses the prod table: create table development.dbt_jyeo.baz as ( select from analytics.marts.foo union all select from analytics.marts.bar )

in 1.4 it doesn't resolve properly: create table development.dbt_jyeo.baz as ( select from development.dbt_jyeo.foo union all select from development.dbt_jyeo.bar )

yuna-tang commented 1 year ago

We have the same issue with dbt 1.4 too. We have rolled back to dbt 1.3 to be able to use the --defer in the cloud IDE.