executeTask

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>