dropTask

Last updated: January 27, 2026

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>

{
  "databaseChangeLog": [
    {
      "changeSet": {
        "id": "drop-task",
        "author": "examples",
        "changes": [
          {
            "dropTask": {
              "taskName": "MY_TASK",
              "ifExists": true
            }
          }
        ]
      }
    },
    {
      "changeSet": {
        "id": "drop-task-qualified",
        "author": "examples",
        "changes": [
          {
            "dropTask": {
              "catalogName": "MYDB",
              "schemaName": "PUBLIC",
              "taskName": "MY_TASK",
              "ifExists": true
            }
          }
        ]
      }
    }
  ]
}

databaseChangeLog:
  #Drop task with IF EXISTS
  - changeSet:
      id: drop-task
      author: examples
      changes:
        - dropTask:
            taskName: MY_TASK
            ifExists: true

  #Drop task with fully qualified name
  - changeSet:
      id: drop-task-qualified
      author: examples
      changes:
        - dropTask:
            catalogName: MYDB
            schemaName: PUBLIC
            taskName: MY_TASK
            ifExists: true

--liquibase formatted sql

--changeset examples:droptask-1
```sql
-- Drop task with IF EXISTS
DROP TASK IF EXISTS MYDB.PUBLIC.MY_TASK;

--changeset examples:drop-task-without-if-exists
-- Drop task without IF EXISTS
DROP TASK MYDB.PUBLIC.MY_TASK;
```

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

{
  "databaseChangeLog": [
    {
      "changeSet": {
        "id": "drop-task",
        "author": "examples",
        "changes": [
          {
            "dropTask": {
              "taskName": "MY_TASK",
              "ifExists": true
            }
          }
        ]
      }
    },
    {
      "changeSet": {
        "id": "drop-task-qualified",
        "author": "examples",
        "changes": [
          {
            "dropTask": {
              "catalogName": "MYDB",
              "schemaName": "PUBLIC",
              "taskName": "MY_TASK",
              "ifExists": true
            }
          }
        ]
      }
    }
  ]
}

databaseChangeLog:
  #Drop task with IF EXISTS
  - changeSet:
      id: drop-task
      author: examples
      changes:
        - dropTask:
            taskName: MY_TASK
            ifExists: true

  #Drop task with fully qualified name
  - changeSet:
      id: drop-task-qualified
      author: examples
      changes:
        - dropTask:
            catalogName: MYDB
            schemaName: PUBLIC
            taskName: MY_TASK
            ifExists: true

--liquibase formatted sql

--changeset examples:droptask-1
```sql
-- Drop task with IF EXISTS
DROP TASK IF EXISTS MYDB.PUBLIC.MY_TASK;

--changeset examples:drop-task-without-if-exists
-- Drop task without IF EXISTS
DROP TASK MYDB.PUBLIC.MY_TASK;
```

dropTask

Available attributes

XML

JSON

YAML

SQL

More like this