[CT-3330] [Bug] get_create_materialized_view_as_sql
is missing from Postgres 1.7 runtime in Cloud
#9016
Closed
2 tasks done
Labels
backport 1.7.latest
bug
Something isn't working
High Severity
bug with significant impact that should be resolved in a reasonable timeframe
regression
Is this a new bug in dbt-core?
Current Behavior
1.6 added Postgres support for materialized views. While 1.7 saw some ergonomic upgrades across the board, the previously working materialized views flow now can struggle to locate a default macro needed for this materalization.
The kicker is that this is a Cloud-only bug we're detecting. This bug is found only in Cloud, neither in CI/CD nor local tests in core.
Is this a caching problem? A macro space problem? Who's to say?
Expected Behavior
Materialized views build successfully (just as they do outside of core).
Steps To Reproduce
1.7.latest
dbt init
)my_second_dbt_model.sql
, simple convert the materialization fromtable
tomaterialized_view
.dbt run -s +my_second_dbt_model
Relevant log output
Environment
Which database adapter are you using with dbt?
postgres
Additional Context
I verified by hand materialized views are building just fine for other adapters, so this is a postgres-specific problem.
We also note that this works with postgres + 1.6 in Cloud.
One other piece of info is that the macro in question was moved (not altered, just moved). Whether this impacts the runtime or not is yet to be seen.
The text was updated successfully, but these errors were encountered: