dropStream

Last updated: January 27, 2026

Drops an existing stream in Snowflake. Streams track DML changes made to tables, views, and other objects for change data capture (CDC) workflows.

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 catalog (database) containing the stream	No
`schemaName`	String	Name of the schema containing the stream	No
`streamName`	String	Name of the stream to drop	Yes
`ifExists`	Boolean	Only execute if the stream exists	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">

    <changeSet id="drop-stream" author="examples">
        <!-- Drop stream with IF EXISTS -->
        <pro-snowflake:dropStream streamName="MY_STREAM" ifExists="true"/>
    </changeSet>

</databaseChangeLog>

{
  "databaseChangeLog": [
    {
      "changeSet": {
        "id": "drop-stream",
        "author": "examples",
        "changes": [
          {
            "dropStream": {
              "streamName": "MY_STREAM",
              "ifExists": true
            }
          }
        ]
      }
    }
  ]
}

databaseChangeLog:
  - changeSet:
      id: drop-stream
      author: examples
      changes:
        - dropStream:
            streamName: MY_STREAM
            ifExists: true

--liquibase formatted sql

--changeset examples:dropstream-1
DROP STREAM IF EXISTS MYDB.PUBLIC.MY_STREAM;

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

    <changeSet id="drop-stream" author="examples">
        <!-- Drop stream with IF EXISTS -->
        <pro-snowflake:dropStream streamName="MY_STREAM" ifExists="true"/>
    </changeSet>

</databaseChangeLog>

{
  "databaseChangeLog": [
    {
      "changeSet": {
        "id": "drop-stream",
        "author": "examples",
        "changes": [
          {
            "dropStream": {
              "streamName": "MY_STREAM",
              "ifExists": true
            }
          }
        ]
      }
    }
  ]
}

databaseChangeLog:
  - changeSet:
      id: drop-stream
      author: examples
      changes:
        - dropStream:
            streamName: MY_STREAM
            ifExists: true

--liquibase formatted sql

--changeset examples:dropstream-1
DROP STREAM IF EXISTS MYDB.PUBLIC.MY_STREAM;

dropStream

Available attributes

XML

JSON

YAML

SQL

More like this