Secure 5.2.1: alterStageParams

alterStageParams

Last updated: August 12, 2026

Modifies the storage parameters of an existing external stage in Snowflake (AWS, Azure, GCP).

Note: This change type does not support automatic rollback.

Available attributes

Attribute	Type	Description	Required
`catalogName`	String	Name of the catalog (database) containing the stage	No
`schemaName`	String	Name of the schema containing the stage	No
`stageName`	String	Name of the stage to alter	Yes
`stageType`	String	Type of stage: `AWS`, `AWS_COMPAT`, `AZURE`, or `GCP`	Yes
`ifExists`	Boolean	Don't error if the stage doesn't exist	No
`newStageParams`	Nested	New storage parameters to apply	Yes

newStageParams attributes

New storage parameters to apply (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`)

<?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 encryption type -->
    <changeSet id="alter-stage-encryption" author="examples">
        <pro-snowflake:alterStageParams stageName="S3_STAGE" stageType="AWS">
            <pro-snowflake:newStageParams storageEncryptionType="NONE"/>
        </pro-snowflake:alterStageParams>
    </changeSet>

    <!-- Change storage integration with IF EXISTS -->
    <changeSet id="alter-stage-integration" author="examples">
        <pro-snowflake:alterStageParams stageName="S3_STAGE" stageType="AWS" ifExists="true">
            <pro-snowflake:newStageParams storageIntegration="new_aws_integration"/>
        </pro-snowflake:alterStageParams>
    </changeSet>

    <!-- Change URL -->
    <changeSet id="alter-stage-url" author="examples">
        <pro-snowflake:alterStageParams stageName="S3_STAGE" stageType="AWS">
            <pro-snowflake:newStageParams url="s3://new-bucket/data/"/>
        </pro-snowflake:alterStageParams>
    </changeSet>

</databaseChangeLog>

{
  "databaseChangeLog": [
    {
      "changeSet": {
        "id": "alter-stage-encryption",
        "author": "examples",
        "changes": [
          {
            "alterStageParams": {
              "stageName": "S3_STAGE",
              "stageType": "AWS",
              "newStageParams": {
                "storageEncryptionType": "NONE"
              }
            }
          }
        ]
      }
    },
    {
      "changeSet": {
        "id": "alter-stage-integration",
        "author": "examples",
        "changes": [
          {
            "alterStageParams": {
              "stageName": "S3_STAGE",
              "stageType": "AWS",
              "ifExists": true,
              "newStageParams": {
                "storageIntegration": "new_aws_integration"
              }
            }
          }
        ]
      }
    },
    {
      "changeSet": {
        "id": "alter-stage-url",
        "author": "examples",
        "changes": [
          {
            "alterStageParams": {
              "stageName": "S3_STAGE",
              "stageType": "AWS",
              "newStageParams": {
                "url": "s3://new-bucket/data/"
              }
            }
          }
        ]
      }
    }
  ]
}

databaseChangeLog:
  # Change encryption type
  - changeSet:
      id: alter-stage-encryption
      author: examples
      changes:
        - alterStageParams:
            stageName: S3_STAGE
            stageType: AWS
            newStageParams:
              storageEncryptionType: NONE

  # Change storage integration with IF EXISTS
  - changeSet:
      id: alter-stage-integration
      author: examples
      changes:
        - alterStageParams:
            stageName: S3_STAGE
            stageType: AWS
            ifExists: true
            newStageParams:
              storageIntegration: new_aws_integration

  # Change URL
  - changeSet:
      id: alter-stage-url
      author: examples
      changes:
        - alterStageParams:
            stageName: S3_STAGE
            stageType: AWS
            newStageParams:
              url: s3://new-bucket/data/

--liquibase formatted sql

--changeset examples:change-encryption-type
-- Change encryption type
ALTER STAGE PUBLIC.S3_STAGE SET ENCRYPTION = (TYPE = 'NONE');

--changeset examples:change-storage-integration-with-if-exists
-- Change storage integration with IF EXISTS
ALTER STAGE IF EXISTS PUBLIC.S3_STAGE SET STORAGE_INTEGRATION = new_aws_integration;

--changeset examples:change-url
-- Change URL
ALTER STAGE PUBLIC.S3_STAGE SET URL = 's3://new-bucket/data/';

<?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 encryption type -->
    <changeSet id="alter-stage-encryption" author="examples">
        <pro-snowflake:alterStageParams stageName="S3_STAGE" stageType="AWS">
            <pro-snowflake:newStageParams storageEncryptionType="NONE"/>
        </pro-snowflake:alterStageParams>
    </changeSet>

    <!-- Change storage integration with IF EXISTS -->
    <changeSet id="alter-stage-integration" author="examples">
        <pro-snowflake:alterStageParams stageName="S3_STAGE" stageType="AWS" ifExists="true">
            <pro-snowflake:newStageParams storageIntegration="new_aws_integration"/>
        </pro-snowflake:alterStageParams>
    </changeSet>

    <!-- Change URL -->
    <changeSet id="alter-stage-url" author="examples">
        <pro-snowflake:alterStageParams stageName="S3_STAGE" stageType="AWS">
            <pro-snowflake:newStageParams url="s3://new-bucket/data/"/>
        </pro-snowflake:alterStageParams>
    </changeSet>

</databaseChangeLog>

{
  "databaseChangeLog": [
    {
      "changeSet": {
        "id": "alter-stage-encryption",
        "author": "examples",
        "changes": [
          {
            "alterStageParams": {
              "stageName": "S3_STAGE",
              "stageType": "AWS",
              "newStageParams": {
                "storageEncryptionType": "NONE"
              }
            }
          }
        ]
      }
    },
    {
      "changeSet": {
        "id": "alter-stage-integration",
        "author": "examples",
        "changes": [
          {
            "alterStageParams": {
              "stageName": "S3_STAGE",
              "stageType": "AWS",
              "ifExists": true,
              "newStageParams": {
                "storageIntegration": "new_aws_integration"
              }
            }
          }
        ]
      }
    },
    {
      "changeSet": {
        "id": "alter-stage-url",
        "author": "examples",
        "changes": [
          {
            "alterStageParams": {
              "stageName": "S3_STAGE",
              "stageType": "AWS",
              "newStageParams": {
                "url": "s3://new-bucket/data/"
              }
            }
          }
        ]
      }
    }
  ]
}

databaseChangeLog:
  # Change encryption type
  - changeSet:
      id: alter-stage-encryption
      author: examples
      changes:
        - alterStageParams:
            stageName: S3_STAGE
            stageType: AWS
            newStageParams:
              storageEncryptionType: NONE

  # Change storage integration with IF EXISTS
  - changeSet:
      id: alter-stage-integration
      author: examples
      changes:
        - alterStageParams:
            stageName: S3_STAGE
            stageType: AWS
            ifExists: true
            newStageParams:
              storageIntegration: new_aws_integration

  # Change URL
  - changeSet:
      id: alter-stage-url
      author: examples
      changes:
        - alterStageParams:
            stageName: S3_STAGE
            stageType: AWS
            newStageParams:
              url: s3://new-bucket/data/

--liquibase formatted sql

--changeset examples:change-encryption-type
-- Change encryption type
ALTER STAGE PUBLIC.S3_STAGE SET ENCRYPTION = (TYPE = 'NONE');

--changeset examples:change-storage-integration-with-if-exists
-- Change storage integration with IF EXISTS
ALTER STAGE IF EXISTS PUBLIC.S3_STAGE SET STORAGE_INTEGRATION = new_aws_integration;

--changeset examples:change-url
-- Change URL
ALTER STAGE PUBLIC.S3_STAGE SET URL = 's3://new-bucket/data/';

alterStageParams

Available attributes

newStageParams attributes

XML

JSON

YAML

SQL

More like this