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-snowflake functionality, rather than a Big Idea better suited to a discussion

Describe the feature

It appears the cluster_by is only functionality for transient tables, Snowflake now supports it with dynamic tables. Can this be added to the dynamic table macros.

Describe alternatives you've considered

No response

Who will this benefit?

No response

Are you interested in contributing this feature?

No response

Anything else?

https://docs.snowflake.com/en/sql-reference/sql/create-dynamic-table