Materialized view creation

Help
1

i have a dbt Cloud environment where i need to build a data model with materialized views and not normal views in snowflake.

The normal views in the presentation layer are running too slow and I’m unable to materialize a table as the source data keeps changing.

Has anyone done a materialized view before.

Thanks

2

Hi @anmuthu
dbt does not support creating materialized views, it uses Dynamic Tables instead.
For comparison please refer Dynamic tables compared to streams and tasks and to materialized views | Snowflake Documentation.

Dynamic tables are better suited for continuous transformations due to functionality like the ability to join, union, and aggregate on base tables, views , and other dynamic tables. Due to those features, they are also more aligned with what other data platforms are calling Materialized Views. Snowflake materialized views have lot of limitations.