Dynamic Table Clustering Keys

[juliankeppel]

Company Name

No response

Use Cases or Problem Statement

We use this TF provider for various resources. One of them are dynamic tables. We now have a new requirement to cluster one of our dynamic tables. I tried that but got the following error:

│ Error: Value for unconfigurable attribute
│ 
│   ...redacted...
│   ...redacted...
│    ....redacted..
│ 
│ Can't configure a value for "cluster_by": its value will be decided
│ automatically based on the result of applying this configuration.

After checking the documentation, I saw that the attribute is read-only.

Category

category:resource, category:preview

Object type(s)

resource:dynamic_table

Proposal

Make it possible to define cluster keys for dynamic tables like it is already for regular tables.

Additional Information

No response

Would you like to implement a fix?

• Yeah, I'll take it 😎

[sfc-gh-jmichalak]

Hi @juliankeppel 👋

Thanks for reporting this feature request. I added this to our internal list. In the meantime, please use the execute resource.

[juliankeppel]

This workaround works for us:

resource "snowflake_execute" "my_table" {
  execute = "ALTER DYNAMIC TABLE ${snowflake_dynamic_table.my_table.fully_qualified_name} CLUSTER BY (COLUMN_1, COLUMN_2, COLUMN_3)"
  revert  = "ALTER DYNAMIC TABLE ${snowflake_dynamic_table.my_table.fully_qualified_name} DROP CLUSTERING KEY"
  depends_on = [snowflake_dynamic_table.my_table]
}