alterTask

Alters an existing Snowflake task with comprehensive configuration options including comment, schedule, tags, contacts, session parameters, warehouse, execution settings, predecessors, conditional execution, state management, and more.

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 alter	Yes
`ifExists`	Boolean	If true, uses `IF EXISTS` clause to avoid errors if task doesn't exist	No
`newErrorIntegration`	String	Notification integration to call when task encounters errors	No
`newSuccessIntegration`	String	Notification integration to call when task completes successfully	No
`alterComment`	Nested	Modify or remove task comment	No
`alterSchedule`	Nested	Modify or remove task schedule	No
`alterTags`	Nested	Add or remove tags	No
`alterSessionParams`	Nested	Set or unset session parameters	No
`alterContacts`	Nested	Add or remove contacts	No
`alterAsClause`	Nested	Modify the SQL statement executed by the task	No
`alterWarehouse`	Nested	Change warehouse settings	No
`alterAllowOverlappingExecution`	Nested	Control concurrent execution	No
`alterState`	Nested	Suspend or resume task execution	No
`alterConfig`	Nested	Modify task configuration	No
`alterWhenClause`	Nested	Modify conditional execution	No
`alterOrder`	Nested	Manage task predecessors (dependencies)	No
`alterExecuteAsUser`	Nested	Change execution context	No
`alterFinalize`	Nested	Set or remove finalizer task	No
`alterTargetCompletionInterval`	Nested	Set target completion time (serverless tasks)	No

Nested elements

Each nested element represents a specific alteration operation. Only include the elements for the properties you want to modify.

alterComment - Modify or remove task comment:

Attribute	Type	Description	Required
`newComment`	String	New comment text	No*
`unsetComment`	Boolean	If true, removes the comment	No*

*Exactly one of newComment or unsetComment must be specified.

alterSchedule - Modify or remove task schedule:

Attribute	Type	Description	Required
`newSchedule`	String	New schedule (e.g., `15 MINUTES`, `USING CRON 0 9 * * * UTC`)	No*
`unsetSchedule`	Boolean	If true, removes the schedule	No*

*Exactly one of newSchedule or unsetSchedule must be specified.

alterTags - Add or remove tags:

Attribute	Type	Description	Required
`setTags`	MapWrapper	Key-value pairs of tags to set	No*
`unsetTags`	String	Space-separated tag names to unset (e.g., `environment department`)	No*

*Exactly one of setTags or unsetTags must be specified. Tags must exist before being set.

alterSessionParams - Set or unset session parameters:

Attribute	Type	Description	Required
`setSessionParams`	MapWrapper	Key-value pairs of session parameters (e.g., `QUERY_TAG`, `STATEMENT_TIMEOUT_IN_SECONDS`)	No*
`unsetSessionParams`	String	Space-separated parameter names to unset	No*

*Exactly one of setSessionParams or unsetSessionParams must be specified.

alterContacts - Add or remove contacts:

Attribute	Type	Description	Required
`setContacts`	MapWrapper	Key-value pairs mapping contact purposes to contact names	No*
`unsetContacts`	String	Space-separated contact purposes to unset	No*

*Exactly one of setContacts or unsetContacts must be specified. Valid purposes: steward, support, access_approval. Contacts must exist before being set.

alterAsClause - Modify the SQL statement executed by the task:

Attribute	Type	Description	Required
`newAsClause`	String	New SQL statement	Yes

alterWarehouse - Change warehouse settings:

Attribute	Type	Description	Required
`newWarehouseName`	String	New warehouse name	No*
`newUserTaskManagedInitialWarehouseSize`	String	Initial warehouse size for serverless tasks	No*
`unsetWarehouse`	Boolean	If true, removes warehouse assignment	No*

*Exactly one option must be specified.

alterAllowOverlappingExecution - Control concurrent execution:

Attribute	Type	Description	Required
`newAllowOverlappingExecution`	Boolean	If true, allows multiple task instances to run concurrently	No*
`unsetAllowOverlappingExecution`	Boolean	If true, removes this setting	No*