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

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