Snowflake createSequence

Last updated: March 26, 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.

Known limitations:

This change type does not support database inspection features (snapshot, diff, diff-changelog, and generate-changelog commands).
The Liquibase createSequence change type is not compatible for Snowflake users in Liquibase Secure 5.1 using YAML or JSON change type formats. This does not affect XML change types at all. If you’re connecting to a Snowflake database, Liquibase automatically detects that you are using the Snowflake createSequence change type and breaks backwards compatibility with the Liquibase createSequence change type. We recommend upgrading to Liquibase Secure 5.1.1 to use createView with YAML and JSON change type formats successfully.

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.

<?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';

Snowflake createSequence

Available attributes

XML

JSON

YAML

SQL

More like this