Secure 6.0: Snowflake alterSequence

Reference
Version · 6.0
Change Automation Reference

Snowflake alterSequence

Last updated: September 29, 2026

Modifies properties of an existing sequence in Snowflake. This allows you to change the increment value and ordering behavior without recreating the sequence.

Note: This change type does not support automatic rollback.

Available attributes

Attribute	Type	Description	Required
`catalogName`	String	Name of the catalog (database) containing the sequence	No
`schemaName`	String	Name of the schema containing the sequence	No
`sequenceName`	String	Name of the sequence to alter	Yes
`ifExists`	Boolean	Don't error if the sequence doesn't exist using IF EXISTS	No
`incrementBy`	Long	New value to increment by for each sequence value*	No
`ordered`	Boolean	New ordering behavior (true for ORDER, false for NOORDER)*	No

* At least one of incrementBy or ordered must be specified.

Snapshot and diff support

As of Liquibase Secure 6.0, diff detects differences in the ordered property of a Snowflake sequence, and diff-changelog generates a corrective pro-snowflake:alterSequence changeset. When incrementBy and ordered both differ, Liquibase combines them into a single changeset, because Snowflake sets both in one ALTER SEQUENCE statement.

Note: Snowflake does not allow changing a sequence from NOORDER to ORDER. When diff finds that difference, Liquibase logs a warning and generates no changeset. Drop and recreate the sequence to enable ORDER. The reverse direction, ORDER to NOORDER, generates a changeset normally.

Two further differences do not produce a changeset:

A comment difference generates a separate pro-snowflake:alterSequenceComment changeset instead of pro-snowflake:alterSequence.
A difference in startValue, minValue, or maxValue is reported in the log only. Snowflake requires you to drop and recreate the sequence to change these, so diff-changelog does not generate a changeset for them.

<?xml version="1.0" encoding="UTF-8"?>
<databaseChangeLog
        xmlns="http://www.liquibase.org/xml/ns/dbchangelog"
        xmlns:pro-snowflake="http://www.liquibase.org/xml/ns/pro-snowflake"
        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
        xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog
        http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-latest.xsd
        http://www.liquibase.org/xml/ns/pro-snowflake
        http://www.liquibase.org/xml/ns/pro-snowflake/liquibase-pro-snowflake-latest.xsd">

    <!-- Change increment -->
    <changeSet id="alter-sequence-increment" author="examples">
        <pro-snowflake:alterSequence
                sequenceName="ORDER_ID_SEQ"
                incrementBy="10"/>
    </changeSet>

    <!-- Change ordering -->
    <changeSet id="alter-sequence-ordering" author="examples">
        <pro-snowflake:alterSequence
                sequenceName="ORDER_ID_SEQ"
                ordered="false"/>
    </changeSet>

    <!-- Change both with IF EXISTS -->
    <changeSet id="alter-sequence-both" author="examples">
        <pro-snowflake:alterSequence
                sequenceName="INVOICE_SEQ"
                ifExists="true"
                incrementBy="5"
                ordered="true"/>
    </changeSet>

</databaseChangeLog>

{
  "databaseChangeLog": [
    {
      "changeSet": {
        "id": "alter-sequence-increment",
        "author": "examples",
        "changes": [
          {
            "alterSequence": {
              "sequenceName": "ORDER_ID_SEQ",
              "incrementBy": 10
            }
          }
        ]
      }
    },
    {
      "changeSet": {
        "id": "alter-sequence-ordering",
        "author": "examples",
        "changes": [
          {
            "alterSequence": {
              "sequenceName": "ORDER_ID_SEQ",
              "ordered": false
            }
          }
        ]
      }
    },
    {
      "changeSet": {
        "id": "alter-sequence-both",
        "author": "examples",
        "changes": [
          {
            "alterSequence": {
              "sequenceName": "INVOICE_SEQ",
              "ifExists": true,
              "incrementBy": 5,
              "ordered": true
            }
          }
        ]
      }
    }
  ]
}

databaseChangeLog:
  # Change increment
  - changeSet:
      id: alter-sequence-increment
      author: examples
      changes:
        - alterSequence:
            sequenceName: ORDER_ID_SEQ
            incrementBy: 10

  # Change ordering
  - changeSet:
      id: alter-sequence-ordering
      author: examples
      changes:
        - alterSequence:
            sequenceName: ORDER_ID_SEQ
            ordered: false

  # Change both with IF EXISTS
  - changeSet:
      id: alter-sequence-both
      author: examples
      changes:
        - alterSequence:
            sequenceName: INVOICE_SEQ
            ifExists: true
            incrementBy: 5
            ordered: true

--liquibase formatted sql

--changeset examples:change-increment
-- Change increment
ALTER SEQUENCE PUBLIC.ORDER_ID_SEQ SET INCREMENT BY 10;

--changeset examples:change-ordering
-- Change ordering
ALTER SEQUENCE PUBLIC.ORDER_ID_SEQ SET NOORDER;

--changeset examples:change-both-with-if-exists
-- Change both with IF EXISTS
ALTER SEQUENCE IF EXISTS PUBLIC.INVOICE_SEQ SET INCREMENT BY 5 ORDER;

<?xml version="1.0" encoding="UTF-8"?>
<databaseChangeLog
        xmlns="http://www.liquibase.org/xml/ns/dbchangelog"
        xmlns:pro-snowflake="http://www.liquibase.org/xml/ns/pro-snowflake"
        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
        xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog
        http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-latest.xsd
        http://www.liquibase.org/xml/ns/pro-snowflake
        http://www.liquibase.org/xml/ns/pro-snowflake/liquibase-pro-snowflake-latest.xsd">

    <!-- Change increment -->
    <changeSet id="alter-sequence-increment" author="examples">
        <pro-snowflake:alterSequence
                sequenceName="ORDER_ID_SEQ"
                incrementBy="10"/>
    </changeSet>

    <!-- Change ordering -->
    <changeSet id="alter-sequence-ordering" author="examples">
        <pro-snowflake:alterSequence
                sequenceName="ORDER_ID_SEQ"
                ordered="false"/>
    </changeSet>

    <!-- Change both with IF EXISTS -->
    <changeSet id="alter-sequence-both" author="examples">
        <pro-snowflake:alterSequence
                sequenceName="INVOICE_SEQ"
                ifExists="true"
                incrementBy="5"
                ordered="true"/>
    </changeSet>

</databaseChangeLog>

{
  "databaseChangeLog": [
    {
      "changeSet": {
        "id": "alter-sequence-increment",
        "author": "examples",
        "changes": [
          {
            "alterSequence": {
              "sequenceName": "ORDER_ID_SEQ",
              "incrementBy": 10
            }
          }
        ]
      }
    },
    {
      "changeSet": {
        "id": "alter-sequence-ordering",
        "author": "examples",
        "changes": [
          {
            "alterSequence": {
              "sequenceName": "ORDER_ID_SEQ",
              "ordered": false
            }
          }
        ]
      }
    },
    {
      "changeSet": {
        "id": "alter-sequence-both",
        "author": "examples",
        "changes": [
          {
            "alterSequence": {
              "sequenceName": "INVOICE_SEQ",
              "ifExists": true,
              "incrementBy": 5,
              "ordered": true
            }
          }
        ]
      }
    }
  ]
}

databaseChangeLog:
  # Change increment
  - changeSet:
      id: alter-sequence-increment
      author: examples
      changes:
        - alterSequence:
            sequenceName: ORDER_ID_SEQ
            incrementBy: 10

  # Change ordering
  - changeSet:
      id: alter-sequence-ordering
      author: examples
      changes:
        - alterSequence:
            sequenceName: ORDER_ID_SEQ
            ordered: false

  # Change both with IF EXISTS
  - changeSet:
      id: alter-sequence-both
      author: examples
      changes:
        - alterSequence:
            sequenceName: INVOICE_SEQ
            ifExists: true
            incrementBy: 5
            ordered: true

--liquibase formatted sql

--changeset examples:change-increment
-- Change increment
ALTER SEQUENCE PUBLIC.ORDER_ID_SEQ SET INCREMENT BY 10;

--changeset examples:change-ordering
-- Change ordering
ALTER SEQUENCE PUBLIC.ORDER_ID_SEQ SET NOORDER;

--changeset examples:change-both-with-if-exists
-- Change both with IF EXISTS
ALTER SEQUENCE IF EXISTS PUBLIC.INVOICE_SEQ SET INCREMENT BY 5 ORDER;

PreviousUseWarehouse NextcreateSequence

Snowflake alterSequence

Available attributes

Snapshot and diff support

XML

JSON

YAML

SQL

More like this