Refresh docs on materialized views

[dataders]

Contributions

• I have read the contribution docs, and understand what's expected of me.

Link to the page on docs.getdbt.com requiring updates

• https://docs.getdbt.com/reference/resource-configs/postgres-configs#materialized-views
• https://docs.getdbt.com/reference/resource-configs/snowflake-configs#dynamic-tables
• https://docs.getdbt.com/reference/resource-configs/bigquery-configs#materialized-view
• https://docs.getdbt.com/reference/resource-configs/databricks-configs#materialized-views-and-streaming-tables

What part(s) of the page would you like to see updated?

Tasks

Beta Give feedback

1. perhaps add a standalone generic "materialized view page"?
2. revert Remove references to materialized views in dbt-bigquery #3812 and update and detail MV and DT support #3779 and bring back BigQuery MVs
3. versionblock current MV/DT caveats into 1.6, create new 1.7 block with the remaining caveats
4. discuss in more detail the concept
5. update materialized view / dynamic table docs to reflect caveats that no longer

Additional information

Following on from #3593, #3779 and #4045

[runleonarun]

reached out to @dataders to understand whether this is a docs request or Anders has got it covered. Also if docs team support is needed, some of the bullets need more info