[Feature] (dbt-doris) Support async materialized views as a dbt materialization

[kosmag]

Search before asking

• I had searched in the issues and found no similar issues.

Description

Based on the documentation, currently dbt-doris supports the following three materialization types: view, table and incremental. view materialization type executes a CREATE VIEW AS statement.

However, there is no way to create a Doris async materialized view (CREATE MATERIALIZED VIEW ... REFRESH ... AS statement) from dbt.

My proposal is to add support in dbt-doris for materialized_view dbt materialization type (which corresponds to the built-in dbt materialization type, as in https://docs.getdbt.com/docs/build/materializations?version=2.0&name=Fusion#materialized-view), which would run the CREATE MATERIALIZED VIEW ... REFRESH ... AS statement.

Use case

Allow management of async materialized views via dbt.

Related issues

No response

Are you willing to submit PR?

• Yes I am willing to submit a PR!

Code of Conduct

• I agree to follow this project's Code of Conduct