[CT-2865] [Feature] Postgres: Support overwriting tables and views with materialized views

[damian3031]

Is this your first time submitting a feature request?

• I have read the expectations for open source contributors
• I have searched the existing issues, and I could not find an existing issue for this feature
• I am requesting a straightforward extension of existing dbt functionality, rather than a Big Idea better suited to a discussion

Describe the feature

Support overwriting tables and views with materialized views in Postgres adapter.

Describe alternatives you've considered

No response

Who will this benefit?

No response

Are you interested in contributing this feature?

Yes I am

Anything else?

No response

[alison985]

Does this exist for non-postgres SQL dialects? Why just overwriting tables and views with materialized views?

In general I think dbt needs a way to nicely migrate a table to a view and vice versa. The DROP of the table to make it a view and vice versa currently has no good path/workflow in dbt.

[Fleid]

Hi @damian3031 - thanks so much for the quick intervention, but we're already planning to enable that in 1.7 ourselves (releasing it early in a beta somewhere in August).

Sadly we can't re-purpose your work, as we are currently refactoring the first internal implementation of MVs that your contribution is based on. We sincerely appreciate your efforts, and hopefully you'll be able to test the new iteration later this summer.