Using Checkpoints in a Workflow | Vantage Analyst - Using Checkpoints - Teradata Analytic Apps - Vantage Analyst

Vantage Analyst User Guide

Teradata Analytic Apps
Vantage Analyst
Release Number
May 2022
English (United States)
Last Update
Product Category
Teradata Applications

You can add a checkpoint to nodes on a workflow. As the system executes the workflow, it saves your progress at each checkpoint. In the event of a failure, you can edit the workflow and resume execution from the checkpoint instead of the Start node.

Only workflows for which you have enabled the Allow resumable execution option can be resumed. See Creating a Workflow.

Canceling Resumable Workflows

If a workflow has failed but is resumable, it may be canceled by the following actions:
Action Description
The workflow is scheduled to execute in the future. The scheduled workflow executes as normal.

The system cancels the resumable workflow.

You execute a new instance of the workflow. The system prompts for confirmation.

If you execute a new instance, the system cancels the resumable workflow.

You delete a resumable workflow or its sub-workflow. The system prompts for confirmation.

If you you delete the resumable workflow, it cannot be resumed.

If you delete its sub-workflow, the system cancels the parent workflow.

Editing Resumable Workflows

When a resumable workflow fails, you can edit the nodes to resolve the failure. For example, you can modify contents of an SQL node and resume the workflow from the checkpoint.

When editing a resumable workflow that that has failed, making any of the following changes will cancel the resumable execution:
  • Adding or removing nodes
  • Adding or removing checkpoints
  • Changing connectors
  • Editing a sub-workflow

Checkpointing Specific Nodes

You can add checkpoints to all nodes except Start and End.

By default, when adding sub-workflows that contain nodes with checkpoints, the entire sub-workflow will be used as a checkpoint. When a sub-workflow successfully completes, you cannot resume from a checkpoint within the sub-workflow. To ensure that the sub-workflow is not re-executed (in case of a failure later in the parent workflow), the entire sub-workflow is automatically designated as a checkpoint in the parent workflow. You can disable this automatic checkpoint, if needed.

When resuming a workflow, the system starts from the checkpoint prior to the failed node.