Secure 6.0: Snowflake createSequence

Reference
Version · 6.0
Change Automation Reference

Snowflake createSequence

Last updated: September 29, 2026

Creates a new sequence in Snowflake. Sequences generate unique numeric values and are commonly used for auto-incrementing primary keys.

Note: Automatic rollback drops the sequence.

Available attributes

Attribute	Type	Description	Required
`catalogName`	String	Name of the catalog (database) where the sequence is created	No
`schemaName`	String	Name of the schema where the sequence is created	No
`sequenceName`	String	Name of the sequence to create	Yes
`orReplace`	Boolean	Replace the sequence if it exists using OR REPLACE*	No
`ifNotExists`	Boolean	Only create if the sequence doesn't exist using IF NOT EXISTS*	No
`startValue`	Long	Initial value for the sequence	No
`incrementBy`	Long	Value to increment by for each sequence value	No
`ordered`	Boolean	Guarantee ordered sequence values (true for ORDER)	No
`comment`	String	Comment describing the sequence	No

* orReplace and ifNotExists are mutually exclusive.

Snapshot and diff support

As of Liquibase Secure 6.0, Snowflake sequences round-trip through the database inspection commands. snapshot records the ordered and comment properties, diff reports a difference when either one differs, and generate-changelog emits pro-snowflake:createSequence with both attributes set.

Note: Snapshots taken before Liquibase Secure 6.0 do not record ordered or comment. Regenerate any stored snapshots of Snowflake databases that contain sequences. If you compare against an older snapshot, diff reports differences that do not exist.

generate-changelog does not emit minValue, maxValue, cycle, or cacheSize for Snowflake sequences. Snowflake rejects those attributes on CREATE SEQUENCE.

<?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">

    <!-- Basic sequence creation -->
    <changeSet id="create-sequence" author="examples">
        <pro-snowflake:createSequence sequenceName="ORDER_ID_SEQ"/>
    </changeSet>

    <!-- Sequence with IF NOT EXISTS -->
    <changeSet id="create-sequence-if-not-exists" author="examples">
        <pro-snowflake:createSequence
                sequenceName="CUSTOMER_ID_SEQ"
                ifNotExists="true"
                startValue="1000"
                incrementBy="1"/>
    </changeSet>

    <!-- Full-featured sequence -->
    <changeSet id="create-full-sequence" author="examples">
        <pro-snowflake:createSequence
                sequenceName="INVOICE_NUMBER_SEQ"
                startValue="100"
                incrementBy="5"
                ordered="true"
                comment="Generates unique invoice numbers"/>
    </changeSet>

</databaseChangeLog>

{
  "databaseChangeLog": [
    {
      "changeSet": {
        "id": "create-sequence",
        "author": "examples",
        "changes": [
          {
            "createSequence": {
              "sequenceName": "ORDER_ID_SEQ"
            }
          }
        ]
      }
    },
    {
      "changeSet": {
        "id": "create-sequence-if-not-exists",
        "author": "examples",
        "changes": [
          {
            "createSequence": {
              "sequenceName": "CUSTOMER_ID_SEQ",
              "ifNotExists": true,
              "startValue": 1000,
              "incrementBy": 1
            }
          }
        ]
      }
    },
    {
      "changeSet": {
        "id": "create-full-sequence",
        "author": "examples",
        "changes": [
          {
            "createSequence": {
              "sequenceName": "INVOICE_NUMBER_SEQ",
              "startValue": 100,
              "incrementBy": 5,
              "ordered": true,
              "comment": "Generates unique invoice numbers"
            }
          }
        ]
      }
    }
  ]
}

databaseChangeLog:
  # Basic sequence creation
  - changeSet:
      id: create-sequence
      author: examples
      changes:
        - createSequence:
            sequenceName: ORDER_ID_SEQ

  # Sequence with IF NOT EXISTS
  - changeSet:
      id: create-sequence-if-not-exists
      author: examples
      changes:
        - createSequence:
            sequenceName: CUSTOMER_ID_SEQ
            ifNotExists: true
            startValue: 1000
            incrementBy: 1

  # Full-featured sequence
  - changeSet:
      id: create-full-sequence
      author: examples
      changes:
        - createSequence:
            sequenceName: INVOICE_NUMBER_SEQ
            startValue: 100
            incrementBy: 5
            ordered: true
            comment: Generates unique invoice numbers

--liquibase formatted sql

--changeset examples:basic-sequence-creation
-- Basic sequence creation
CREATE SEQUENCE PUBLIC.ORDER_ID_SEQ;

--changeset examples:sequence-with-if-not-exists
-- Sequence with IF NOT EXISTS
CREATE SEQUENCE IF NOT EXISTS PUBLIC.CUSTOMER_ID_SEQ START WITH 1000 INCREMENT BY 1;

--changeset examples:full-featured-sequence
-- Full-featured sequence
CREATE SEQUENCE PUBLIC.INVOICE_NUMBER_SEQ START WITH 100 INCREMENT BY 5 ORDER COMMENT = 'Generates unique invoice numbers';

<?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">

    <!-- Basic sequence creation -->
    <changeSet id="create-sequence" author="examples">
        <pro-snowflake:createSequence sequenceName="ORDER_ID_SEQ"/>
    </changeSet>

    <!-- Sequence with IF NOT EXISTS -->
    <changeSet id="create-sequence-if-not-exists" author="examples">
        <pro-snowflake:createSequence
                sequenceName="CUSTOMER_ID_SEQ"
                ifNotExists="true"
                startValue="1000"
                incrementBy="1"/>
    </changeSet>

    <!-- Full-featured sequence -->
    <changeSet id="create-full-sequence" author="examples">
        <pro-snowflake:createSequence
                sequenceName="INVOICE_NUMBER_SEQ"
                startValue="100"
                incrementBy="5"
                ordered="true"
                comment="Generates unique invoice numbers"/>
    </changeSet>

</databaseChangeLog>

{
  "databaseChangeLog": [
    {
      "changeSet": {
        "id": "create-sequence",
        "author": "examples",
        "changes": [
          {
            "createSequence": {
              "sequenceName": "ORDER_ID_SEQ"
            }
          }
        ]
      }
    },
    {
      "changeSet": {
        "id": "create-sequence-if-not-exists",
        "author": "examples",
        "changes": [
          {
            "createSequence": {
              "sequenceName": "CUSTOMER_ID_SEQ",
              "ifNotExists": true,
              "startValue": 1000,
              "incrementBy": 1
            }
          }
        ]
      }
    },
    {
      "changeSet": {
        "id": "create-full-sequence",
        "author": "examples",
        "changes": [
          {
            "createSequence": {
              "sequenceName": "INVOICE_NUMBER_SEQ",
              "startValue": 100,
              "incrementBy": 5,
              "ordered": true,
              "comment": "Generates unique invoice numbers"
            }
          }
        ]
      }
    }
  ]
}

databaseChangeLog:
  # Basic sequence creation
  - changeSet:
      id: create-sequence
      author: examples
      changes:
        - createSequence:
            sequenceName: ORDER_ID_SEQ

  # Sequence with IF NOT EXISTS
  - changeSet:
      id: create-sequence-if-not-exists
      author: examples
      changes:
        - createSequence:
            sequenceName: CUSTOMER_ID_SEQ
            ifNotExists: true
            startValue: 1000
            incrementBy: 1

  # Full-featured sequence
  - changeSet:
      id: create-full-sequence
      author: examples
      changes:
        - createSequence:
            sequenceName: INVOICE_NUMBER_SEQ
            startValue: 100
            incrementBy: 5
            ordered: true
            comment: Generates unique invoice numbers

--liquibase formatted sql

--changeset examples:basic-sequence-creation
-- Basic sequence creation
CREATE SEQUENCE PUBLIC.ORDER_ID_SEQ;

--changeset examples:sequence-with-if-not-exists
-- Sequence with IF NOT EXISTS
CREATE SEQUENCE IF NOT EXISTS PUBLIC.CUSTOMER_ID_SEQ START WITH 1000 INCREMENT BY 1;

--changeset examples:full-featured-sequence
-- Full-featured sequence
CREATE SEQUENCE PUBLIC.INVOICE_NUMBER_SEQ START WITH 100 INCREMENT BY 5 ORDER COMMENT = 'Generates unique invoice numbers';

PreviousalterSequence NextalterSequenceComment

Snowflake createSequence

Available attributes

Snapshot and diff support

XML

JSON

YAML

SQL

More like this