Open mstelter52 opened 1 month ago
Hi @amychen1776 👋 . Sorry to @ you out of blue but saw you were the last to touch this ticket. I also need this functionality. Do you know if this feature is already on the roadmap and/or under active development? If not I may have time to contribute a PR for this one.
cc: @j-choe
On a related note I would not want to implement the feature using the legacy method of clustering that is used for tables now. CREATE DYNAMIC TABLE
supports a CLUSTER BY
parameter I would prefer to use. Looks like there is already discussion about migrating table creation to use this as well in this ticket.
Is this your first time submitting a feature request?
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