Last updated: July 13, 2026
Drops an existing stage in Snowflake.
Note: This change type does not support automatic rollback.
Attribute | Type | Description | Required |
| String | Name of the catalog (database) containing the stage | No |
| String | Name of the schema containing the stage | No |
| String | Name of the stage to drop | Yes |
| Boolean | Don't error if the stage doesn't exist | No |
<?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">
<!-- Drop stage -->
<changeSet id="drop-stage" author="examples">
<pro-snowflake:dropStage stageName="OLD_STAGE"/>
</changeSet>
<!-- Drop stage with IF EXISTS -->
<changeSet id="drop-stage-if-exists" author="examples">
<pro-snowflake:dropStage stageName="TEMP_STAGE" ifExists="true"/>
</changeSet>
</databaseChangeLog>{
"databaseChangeLog": [
{
"changeSet": {
"id": "drop-stage",
"author": "examples",
"changes": [
{
"dropStage": {
"stageName": "OLD_STAGE"
}
}
]
}
},
{
"changeSet": {
"id": "drop-stage-if-exists",
"author": "examples",
"changes": [
{
"dropStage": {
"stageName": "TEMP_STAGE",
"ifExists": true
}
}
]
}
}
]
}databaseChangeLog:
# Drop stage
- changeSet:
id: drop-stage
author: examples
changes:
- dropStage:
stageName: OLD_STAGE
# Drop stage with IF EXISTS
- changeSet:
id: drop-stage-if-exists
author: examples
changes:
- dropStage:
stageName: TEMP_STAGE
ifExists: true--liquibase formatted sql
--changeset examples:drop-stage
-- Drop stage
DROP STAGE PUBLIC.OLD_STAGE;
--changeset examples:drop-stage-with-if-exists
-- Drop stage with IF EXISTS
DROP STAGE IF EXISTS PUBLIC.TEMP_STAGE;
<?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">
<!-- Drop stage -->
<changeSet id="drop-stage" author="examples">
<pro-snowflake:dropStage stageName="OLD_STAGE"/>
</changeSet>
<!-- Drop stage with IF EXISTS -->
<changeSet id="drop-stage-if-exists" author="examples">
<pro-snowflake:dropStage stageName="TEMP_STAGE" ifExists="true"/>
</changeSet>
</databaseChangeLog>{
"databaseChangeLog": [
{
"changeSet": {
"id": "drop-stage",
"author": "examples",
"changes": [
{
"dropStage": {
"stageName": "OLD_STAGE"
}
}
]
}
},
{
"changeSet": {
"id": "drop-stage-if-exists",
"author": "examples",
"changes": [
{
"dropStage": {
"stageName": "TEMP_STAGE",
"ifExists": true
}
}
]
}
}
]
}databaseChangeLog:
# Drop stage
- changeSet:
id: drop-stage
author: examples
changes:
- dropStage:
stageName: OLD_STAGE
# Drop stage with IF EXISTS
- changeSet:
id: drop-stage-if-exists
author: examples
changes:
- dropStage:
stageName: TEMP_STAGE
ifExists: true--liquibase formatted sql
--changeset examples:drop-stage
-- Drop stage
DROP STAGE PUBLIC.OLD_STAGE;
--changeset examples:drop-stage-with-if-exists
-- Drop stage with IF EXISTS
DROP STAGE IF EXISTS PUBLIC.TEMP_STAGE;