dropTask

Drops an existing Snowflake task.

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

Available attributes

Name

Type

Description

Required

catalogName

String

Name of the catalog (database) containing the task

No

schemaName

String

Name of the schema containing the task

No

taskName

String

Name of the task to drop

Yes

ifExists

Boolean

If true, only drops the task if it exists using IF 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">
  <!-- Drop task with IF EXISTS -->
  <changeSet id="drop-task" author="examples">
    <pro-snowflake:dropTask taskName="MY_TASK" ifExists="true"/>
  </changeSet>
  <!-- Drop task with fully qualified name -->
  <changeSet id="drop-task-qualified" author="examples">
    <pro-snowflake:dropTask
            catalogName="MYDB"
            schemaName="PUBLIC"
            taskName="MY_TASK"
            ifExists="true"/>
  </changeSet>
</databaseChangeLog>

dropTask - Liquibase