[Feature]: "ORDER" | "NOORDER" setting for the identity column

[kanomaxb]

Company Name

No response

Use Cases or Problem Statement

In one of recent releases Snowflake decided that identity columns (and sequences) will no longer keep order by default. There is a new setting to enforce this order, it's called "ORDER" https://docs.snowflake.com/en/sql-reference/sql/create-table

Category

category:resource

Object type(s)

No response

Proposal

In addition to start_num and step_num, the identity definition should also have order property.

How much impact is this issue causing?

Medium

Additional Information

No response

Would you like to implement a fix?

• [ ] Yeah, I'll take it 😎

[sfc-gh-jmichalak]

Hi @kanomaxb 👋

We'll add this feature while reworking the table resource. We'll go through the documentation and make sure all fields are possible to set in the configuration.

[rorydonaldson]

Hello, is there any updates on when this is expected to be implemented?

[sfc-gh-asawicki]

Hey, we will share the roadmap for the next months in early May (check https://github.com/snowflakedb/terraform-provider-snowflake/blob/main/ROADMAP.md#23042025-v200-release---ga).

[jmkacz]

@sfc-gh-jmichalak @sfc-gh-asawicki I am keenly interested in snowflake_table being promoted from a preview feature to a stable feature. You mention that you are "reworking the table resource". Is this something being done internally within Snowflake, or is this something I could contribute to?

[sfc-gh-jmichalak]

Hi @jmkacz, this resource is more challenging than others because of things like column order, nested attributes, etc. It requires thoughtful discussions and designs. We prefer reworking tables ourselves, but we don't have a timeline for now.