Hi All,
Is there any way we can create a Materialized Views on DBT tool?
Hi Annie,
It depends on your use case - sometimes it can be achieved by simple ‘table’ materialisation. Whenever you run such model, it’ll recreate table with whatever is specified in model’s SELECT statement.
The complexity is usually needed in the WHERE expressions - to specify how the content of the table changes next time you recreate it with 'dbt run -m ', and with the scheduling setup (for example, if you use DAGs with Airflow or something similar to refresh your table periodically).
Cheers,
Tomaz