dropStream

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>