undropSchema

Last updated: January 27, 2026

Restores a dropped schema using Snowflake Time Travel. The schema must have been dropped within the data retention period.

Note: This change type does not support automatic rollback or database inspection features (snapshot, diff, diff-changelog, and generate-changelog commands).

Available attributes

Attribute	Type	Description	Required
`catalogName`	String	Name of the database containing the dropped schema	No
`schemaName`	String	Name of the schema to restore	Yes

<?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 undrop -->
    <changeSet id="undrop-schema" author="examples">
        <pro-snowflake:undropSchema schemaName="ANALYTICS"/>
    </changeSet>

    <!-- Undrop with catalog name -->
    <changeSet id="undrop-schema-with-catalog" author="examples">
        <pro-snowflake:undropSchema
                catalogName="PROD_DB"
                schemaName="STAGING"/>
    </changeSet>

</databaseChangeLog>

{
  "databaseChangeLog": [
    {
      "changeSet": {
        "id": "undrop-schema",
        "author": "examples",
        "changes": [
          {
            "undropSchema": {
              "schemaName": "ANALYTICS"
            }
          }
        ]
      }
    },
    {
      "changeSet": {
        "id": "undrop-schema-with-catalog",
        "author": "examples",
        "changes": [
          {
            "undropSchema": {
              "catalogName": "PROD_DB",
              "schemaName": "STAGING"
            }
          }
        ]
      }
    }
  ]
}

databaseChangeLog:
  # Basic undrop
  - changeSet:
      id: undrop-schema
      author: examples
      changes:
        - undropSchema:
            schemaName: ANALYTICS

  # Undrop with catalog name
  - changeSet:
      id: undrop-schema-with-catalog
      author: examples
      changes:
        - undropSchema:
            catalogName: PROD_DB
            schemaName: STAGING

--liquibase formatted sql

--changeset examples:basic-undrop
-- Basic undrop
UNDROP SCHEMA ANALYTICS;

--changeset examples:undrop-with-catalog-name
-- Undrop with catalog name
UNDROP SCHEMA PROD_DB.STAGING;

<?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 undrop -->
    <changeSet id="undrop-schema" author="examples">
        <pro-snowflake:undropSchema schemaName="ANALYTICS"/>
    </changeSet>

    <!-- Undrop with catalog name -->
    <changeSet id="undrop-schema-with-catalog" author="examples">
        <pro-snowflake:undropSchema
                catalogName="PROD_DB"
                schemaName="STAGING"/>
    </changeSet>

</databaseChangeLog>

{
  "databaseChangeLog": [
    {
      "changeSet": {
        "id": "undrop-schema",
        "author": "examples",
        "changes": [
          {
            "undropSchema": {
              "schemaName": "ANALYTICS"
            }
          }
        ]
      }
    },
    {
      "changeSet": {
        "id": "undrop-schema-with-catalog",
        "author": "examples",
        "changes": [
          {
            "undropSchema": {
              "catalogName": "PROD_DB",
              "schemaName": "STAGING"
            }
          }
        ]
      }
    }
  ]
}

databaseChangeLog:
  # Basic undrop
  - changeSet:
      id: undrop-schema
      author: examples
      changes:
        - undropSchema:
            schemaName: ANALYTICS

  # Undrop with catalog name
  - changeSet:
      id: undrop-schema-with-catalog
      author: examples
      changes:
        - undropSchema:
            catalogName: PROD_DB
            schemaName: STAGING

--liquibase formatted sql

--changeset examples:basic-undrop
-- Basic undrop
UNDROP SCHEMA ANALYTICS;

--changeset examples:undrop-with-catalog-name
-- Undrop with catalog name
UNDROP SCHEMA PROD_DB.STAGING;

undropSchema

Available attributes

XML example

JSON example

YAML example

SQL example

More like this