[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.