Secure 5.2.1: createStage

createStage

Last updated: August 12, 2026

Creates a new stage in Snowflake. Stages are locations where data files are stored for loading into or unloading from tables.

Note: Automatic rollback drops the stage.

Available attributes

Name	Type	Description	Required
`catalogName`	String	Name of the catalog (database) where the stage is created	No
`schemaName`	String	Name of the schema where the stage is created	No
`stageName`	String	Name of the stage to create	Yes
`stageType`	String	Type of stage: `INTERNAL`, `AWS`, `AWS_COMPAT`, `AZURE`, or `GCP`	Yes
`comment`	String	Comment describing the stage	No
`replaceIfExists`	Boolean	Replace the stage if it exists using `OR REPLACE`	No
`stageParams`	Nested	Configuration for external stage locations	No
`fileFormat`	Nested	File format configuration	No
`directoryTableParams`	Nested	Directory table configuration for change tracking	No
`tags`	Nested	Key-value pairs of tags to apply	No

stageParams attributes

Configuration for external stage locations (nested element):

Attribute	Type	Description
`url`	String	External storage URL (S3, Azure, GCS)
`storageIntegration`	String	Named integration for authentication
`storageEncryptionType`	String	Encryption type (e.g., `AWS_SSE_S3`, `SNOWFLAKE_SSE`, `NONE`)
`endpoint`	String	Private/custom endpoint URL
`awsAccessPointArn`	String	AWS S3 Access Point ARN
`usePrivateLinkEndpoint`	Boolean	Use AWS PrivateLink endpoint
`awsCredentials`	Nested	AWS credentials (`awsKeyId`, `awsSecretKey`, `awsToken`, `awsRole`)
`azureCredentials`	Nested	Azure credentials (`azureSasToken`)

fileFormat attributes

File format configuration (nested element):

Attribute	Type	Description
`fileFormatName`	String	Reference to named file format
`fileFormatType`	String	Type: `CSV`, `JSON`, `AVRO`, `ORC`, `PARQUET`, `XML`, `CUSTOM`
`formatTypeOptions`	MapWrapper	Type-specific options (e.g., `SKIP_HEADER`, `COMPRESSION`)

directoryTableParams attributes

Directory table configuration for change tracking (nested element):

Attribute	Type	Description
`enable`	Boolean	Enable directory table
`autoRefresh`	Boolean	Automatically refresh directory
`refreshOnCreate`	Boolean	Refresh immediately on creation
`notificationIntegration`	String	Named notification integration

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

    <!-- Internal stage with file format and directory table -->
    <changeSet id="create-internal-stage" author="examples">
        <pro-snowflake:createStage stageName="DATA_STAGE" stageType="INTERNAL">
            <pro-snowflake:fileFormat fileFormatType="CSV">
                <pro-snowflake:formatTypeOptions>
                    <pro-snowflake:entry key="SKIP_HEADER" value="1"/>
                    <pro-snowflake:entry key="COMPRESSION" value="GZIP"/>
                </pro-snowflake:formatTypeOptions>
            </pro-snowflake:fileFormat>
            <pro-snowflake:stageParams storageEncryptionType="SNOWFLAKE_SSE"/>
            <pro-snowflake:directoryTableParams enable="true" autoRefresh="true"/>
        </pro-snowflake:createStage>
    </changeSet>

    <!-- AWS external stage with storage integration -->
    <changeSet id="create-aws-stage" author="examples">
        <pro-snowflake:createStage stageName="S3_STAGE" stageType="AWS" replaceIfExists="true">
            <pro-snowflake:stageParams
                    url="s3://my-bucket/data/"
                    storageIntegration="aws_integration"
                    storageEncryptionType="AWS_SSE_S3"/>
            <pro-snowflake:directoryTableParams enable="true"/>
        </pro-snowflake:createStage>
    </changeSet>

    <!-- Stage with tags -->
    <changeSet id="create-stage-with-tags" author="examples">
        <pro-snowflake:createStage stageName="TAGGED_STAGE" stageType="INTERNAL">
            <pro-snowflake:tags>
                <pro-snowflake:entry key="environment" value="production"/>
                <pro-snowflake:entry key="team" value="data-engineering"/>
            </pro-snowflake:tags>
        </pro-snowflake:createStage>
    </changeSet>

</databaseChangeLog>

{
  "databaseChangeLog": [
    {
      "changeSet": {
        "id": "create-internal-stage",
        "author": "examples",
        "changes": [
          {
            "createStage": {
              "stageName": "DATA_STAGE",
              "stageType": "INTERNAL",
              "fileFormat": {
                "fileFormatType": "CSV",
                "formatTypeOptions": {
                  "entries": [
                    {
                      "entry": {
                        "key": "SKIP_HEADER",
                        "value": "1"
                      }
                    },
                    {
                      "entry": {
                        "key": "COMPRESSION",
                        "value": "GZIP"
                      }
                    }
                  ]
                }
              },
              "stageParams": {
                "storageEncryptionType": "SNOWFLAKE_SSE"
              },
              "directoryTableParams": {
                "enable": true,
                "autoRefresh": true
              }
            }
          }
        ]
      }
    },
    {
      "changeSet": {
        "id": "create-aws-stage",
        "author": "examples",
        "changes": [
          {
            "createStage": {
              "stageName": "S3_STAGE",
              "stageType": "AWS",
              "replaceIfExists": true,
              "stageParams": {
                "url": "s3://my-bucket/data/",
                "storageIntegration": "aws_integration",
                "storageEncryptionType": "AWS_SSE_S3"
              },
              "directoryTableParams": {
                "enable": true
              }
            }
          }
        ]
      }
    }
  ]
}

databaseChangeLog:
  # Internal stage with file format and directory table
  - changeSet:
      id: create-internal-stage
      author: examples
      changes:
        - createStage:
            stageName: DATA_STAGE
            stageType: INTERNAL
            fileFormat:
              fileFormatType: CSV
              formatTypeOptions:
                entries:
                  - entry:
                      key: SKIP_HEADER
                      value: "1"
                  - entry:
                      key: COMPRESSION
                      value: GZIP
            stageParams:
              storageEncryptionType: SNOWFLAKE_SSE
            directoryTableParams:
              enable: true
              autoRefresh: true

  # AWS external stage with storage integration
  - changeSet:
      id: create-aws-stage
      author: examples
      changes:
        - createStage:
            stageName: S3_STAGE
            stageType: AWS
            replaceIfExists: true
            stageParams:
              url: s3://my-bucket/data/
              storageIntegration: aws_integration
              storageEncryptionType: AWS_SSE_S3
            directoryTableParams:
              enable: true

  # Stage with tags
  - changeSet:
      id: create-stage-with-tags
      author: examples
      changes:
        - createStage:
            stageName: TAGGED_STAGE
            stageType: INTERNAL
            tags:
              entries:
                - entry:
                    key: environment
                    value: production
                - entry:
                    key: team
                    value: data-engineering

--liquibase formatted sql

--changeset examples:internal-stage-with-file-format-and-directory-table
-- Internal stage with file format and directory table
CREATE STAGE PUBLIC.DATA_STAGE
  ENCRYPTION = (TYPE = 'SNOWFLAKE_SSE')
  DIRECTORY = (ENABLE = TRUE AUTO_REFRESH = TRUE)
  FILE_FORMAT = (TYPE = CSV SKIP_HEADER = 1 COMPRESSION = 'GZIP');

--changeset examples:aws-external-stage-with-storage-integration
-- AWS external stage with storage integration
CREATE OR REPLACE STAGE PUBLIC.S3_STAGE
  URL = 's3://my-bucket/data/'
  STORAGE_INTEGRATION = aws_integration
  ENCRYPTION = (TYPE = 'AWS_SSE_S3')
  DIRECTORY = (ENABLE = TRUE);

--changeset examples:stage-with-tags
-- Stage with tags
CREATE STAGE PUBLIC.TAGGED_STAGE
  WITH TAG (environment = 'production', team = 'data-engineering');

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

    <!-- Internal stage with file format and directory table -->
    <changeSet id="create-internal-stage" author="examples">
        <pro-snowflake:createStage stageName="DATA_STAGE" stageType="INTERNAL">
            <pro-snowflake:fileFormat fileFormatType="CSV">
                <pro-snowflake:formatTypeOptions>
                    <pro-snowflake:entry key="SKIP_HEADER" value="1"/>
                    <pro-snowflake:entry key="COMPRESSION" value="GZIP"/>
                </pro-snowflake:formatTypeOptions>
            </pro-snowflake:fileFormat>
            <pro-snowflake:stageParams storageEncryptionType="SNOWFLAKE_SSE"/>
            <pro-snowflake:directoryTableParams enable="true" autoRefresh="true"/>
        </pro-snowflake:createStage>
    </changeSet>

    <!-- AWS external stage with storage integration -->
    <changeSet id="create-aws-stage" author="examples">
        <pro-snowflake:createStage stageName="S3_STAGE" stageType="AWS" replaceIfExists="true">
            <pro-snowflake:stageParams
                    url="s3://my-bucket/data/"
                    storageIntegration="aws_integration"
                    storageEncryptionType="AWS_SSE_S3"/>
            <pro-snowflake:directoryTableParams enable="true"/>
        </pro-snowflake:createStage>
    </changeSet>

    <!-- Stage with tags -->
    <changeSet id="create-stage-with-tags" author="examples">
        <pro-snowflake:createStage stageName="TAGGED_STAGE" stageType="INTERNAL">
            <pro-snowflake:tags>
                <pro-snowflake:entry key="environment" value="production"/>
                <pro-snowflake:entry key="team" value="data-engineering"/>
            </pro-snowflake:tags>
        </pro-snowflake:createStage>
    </changeSet>

</databaseChangeLog>

{
  "databaseChangeLog": [
    {
      "changeSet": {
        "id": "create-internal-stage",
        "author": "examples",
        "changes": [
          {
            "createStage": {
              "stageName": "DATA_STAGE",
              "stageType": "INTERNAL",
              "fileFormat": {
                "fileFormatType": "CSV",
                "formatTypeOptions": {
                  "entries": [
                    {
                      "entry": {
                        "key": "SKIP_HEADER",
                        "value": "1"
                      }
                    },
                    {
                      "entry": {
                        "key": "COMPRESSION",
                        "value": "GZIP"
                      }
                    }
                  ]
                }
              },
              "stageParams": {
                "storageEncryptionType": "SNOWFLAKE_SSE"
              },
              "directoryTableParams": {
                "enable": true,
                "autoRefresh": true
              }
            }
          }
        ]
      }
    },
    {
      "changeSet": {
        "id": "create-aws-stage",
        "author": "examples",
        "changes": [
          {
            "createStage": {
              "stageName": "S3_STAGE",
              "stageType": "AWS",
              "replaceIfExists": true,
              "stageParams": {
                "url": "s3://my-bucket/data/",
                "storageIntegration": "aws_integration",
                "storageEncryptionType": "AWS_SSE_S3"
              },
              "directoryTableParams": {
                "enable": true
              }
            }
          }
        ]
      }
    }
  ]
}

databaseChangeLog:
  # Internal stage with file format and directory table
  - changeSet:
      id: create-internal-stage
      author: examples
      changes:
        - createStage:
            stageName: DATA_STAGE
            stageType: INTERNAL
            fileFormat:
              fileFormatType: CSV
              formatTypeOptions:
                entries:
                  - entry:
                      key: SKIP_HEADER
                      value: "1"
                  - entry:
                      key: COMPRESSION
                      value: GZIP
            stageParams:
              storageEncryptionType: SNOWFLAKE_SSE
            directoryTableParams:
              enable: true
              autoRefresh: true

  # AWS external stage with storage integration
  - changeSet:
      id: create-aws-stage
      author: examples
      changes:
        - createStage:
            stageName: S3_STAGE
            stageType: AWS
            replaceIfExists: true
            stageParams:
              url: s3://my-bucket/data/
              storageIntegration: aws_integration
              storageEncryptionType: AWS_SSE_S3
            directoryTableParams:
              enable: true

  # Stage with tags
  - changeSet:
      id: create-stage-with-tags
      author: examples
      changes:
        - createStage:
            stageName: TAGGED_STAGE
            stageType: INTERNAL
            tags:
              entries:
                - entry:
                    key: environment
                    value: production
                - entry:
                    key: team
                    value: data-engineering

--liquibase formatted sql

--changeset examples:internal-stage-with-file-format-and-directory-table
-- Internal stage with file format and directory table
CREATE STAGE PUBLIC.DATA_STAGE
  ENCRYPTION = (TYPE = 'SNOWFLAKE_SSE')
  DIRECTORY = (ENABLE = TRUE AUTO_REFRESH = TRUE)
  FILE_FORMAT = (TYPE = CSV SKIP_HEADER = 1 COMPRESSION = 'GZIP');

--changeset examples:aws-external-stage-with-storage-integration
-- AWS external stage with storage integration
CREATE OR REPLACE STAGE PUBLIC.S3_STAGE
  URL = 's3://my-bucket/data/'
  STORAGE_INTEGRATION = aws_integration
  ENCRYPTION = (TYPE = 'AWS_SSE_S3')
  DIRECTORY = (ENABLE = TRUE);

--changeset examples:stage-with-tags
-- Stage with tags
CREATE STAGE PUBLIC.TAGGED_STAGE
  WITH TAG (environment = 'production', team = 'data-engineering');

createStage

Available attributes

stageParams attributes

fileFormat attributes

directoryTableParams attributes

XML

JSON

YAML

SQL

More like this