executeTask

Last updated: January 27, 2026

Manually executes a 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 execute	Yes
`retryLast`	Boolean	If true, retries the last failed run using RETRY LAST	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">

    <!-- Execute task -->
    <changeSet id="execute-task" author="examples">
        <pro-snowflake:executeTask taskName="MY_TASK"/>
    </changeSet>

    <!-- Execute task with fully qualified name -->
    <changeSet id="execute-task-qualified" author="examples">
        <pro-snowflake:executeTask
            catalogName="MYDB"
            schemaName="PUBLIC"
            taskName="MY_TASK"/>
    </changeSet>

    <!-- Retry last failed run -->
    <changeSet id="retry-task" author="examples">
        <pro-snowflake:executeTask taskName="MY_TASK" retryLast="true"/>
    </changeSet>

</databaseChangeLog>

{
  "databaseChangeLog": [
    {
      "changeSet": {
        "id": "execute-task",
        "author": "examples",
        "changes": [
          {
            "executeTask": {
              "taskName": "MY_TASK"
            }
          }
        ]
      }
    },
    {
      "changeSet": {
        "id": "execute-task-qualified",
        "author": "examples",
        "changes": [
          {
            "executeTask": {
              "catalogName": "MYDB",
              "schemaName": "PUBLIC",
              "taskName": "MY_TASK"
            }
          }
        ]
      }
    },
    {
      "changeSet": {
        "id": "retry-task",
        "author": "examples",
        "changes": [
          {
            "executeTask": {
              "taskName": "MY_TASK",
              "retryLast": true
            }
          }
        ]
      }
    }
  ]
}

databaseChangeLog:
  #Execute task
  - changeSet:
      id: execute-task
      author: examples
      changes:
        - executeTask:
            taskName: MY_TASK

  #Execute task with fully qualified name
  - changeSet:
      id: execute-task-qualified
      author: examples
      changes:
        - executeTask:
            catalogName: MYDB
            schemaName: PUBLIC
            taskName: MY_TASK

  #Retry last failed run
  - changeSet:
      id: retry-task
      author: examples
      changes:
        - executeTask:
            taskName: MY_TASK
            retryLast: true

--liquibase formatted sql

--changeset examples:executetask-1
```sql
-- Execute task
EXECUTE TASK MYDB.PUBLIC.MY_TASK;

--changeset examples:retry-last-failed-run
-- Retry last failed run
EXECUTE TASK MYDB.PUBLIC.MY_TASK RETRY LAST;
```

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

    <!-- Execute task -->
    <changeSet id="execute-task" author="examples">
        <pro-snowflake:executeTask taskName="MY_TASK"/>
    </changeSet>

    <!-- Execute task with fully qualified name -->
    <changeSet id="execute-task-qualified" author="examples">
        <pro-snowflake:executeTask
            catalogName="MYDB"
            schemaName="PUBLIC"
            taskName="MY_TASK"/>
    </changeSet>

    <!-- Retry last failed run -->
    <changeSet id="retry-task" author="examples">
        <pro-snowflake:executeTask taskName="MY_TASK" retryLast="true"/>
    </changeSet>

</databaseChangeLog>

{
  "databaseChangeLog": [
    {
      "changeSet": {
        "id": "execute-task",
        "author": "examples",
        "changes": [
          {
            "executeTask": {
              "taskName": "MY_TASK"
            }
          }
        ]
      }
    },
    {
      "changeSet": {
        "id": "execute-task-qualified",
        "author": "examples",
        "changes": [
          {
            "executeTask": {
              "catalogName": "MYDB",
              "schemaName": "PUBLIC",
              "taskName": "MY_TASK"
            }
          }
        ]
      }
    },
    {
      "changeSet": {
        "id": "retry-task",
        "author": "examples",
        "changes": [
          {
            "executeTask": {
              "taskName": "MY_TASK",
              "retryLast": true
            }
          }
        ]
      }
    }
  ]
}

databaseChangeLog:
  #Execute task
  - changeSet:
      id: execute-task
      author: examples
      changes:
        - executeTask:
            taskName: MY_TASK

  #Execute task with fully qualified name
  - changeSet:
      id: execute-task-qualified
      author: examples
      changes:
        - executeTask:
            catalogName: MYDB
            schemaName: PUBLIC
            taskName: MY_TASK

  #Retry last failed run
  - changeSet:
      id: retry-task
      author: examples
      changes:
        - executeTask:
            taskName: MY_TASK
            retryLast: true

--liquibase formatted sql

--changeset examples:executetask-1
```sql
-- Execute task
EXECUTE TASK MYDB.PUBLIC.MY_TASK;

--changeset examples:retry-last-failed-run
-- Retry last failed run
EXECUTE TASK MYDB.PUBLIC.MY_TASK RETRY LAST;
```

executeTask

Available attributes

XML

JSON

YAML

SQL

More like this