Trigger execution

This document shows you how to manually trigger execution of your entire SQL workflow or only selected elements in your workflow.

You can execute the following elements of your SQL workflow:

  • All actions in your workflow
  • Selected actions
  • Actions with selected tags

Before you begin

  1. In the Google Cloud console, go to the Dataform page.

    Go to the Dataform page

  2. Select or create a repository.

  3. Select or create a development workspace.

  4. Develop your SQL workflow.

Required roles

To get the permissions that you need to manually trigger an execution, ask your administrator to grant you the Dataform Editor (roles/dataform.editor) IAM role on workflowInvocations. For more information about granting roles, see Manage access to projects, folders, and organizations.

You might also be able to get the required permissions through custom roles or other predefined roles.

Manually execute all actions in your workflow

To manually trigger execution of all actions in your workflow, follow these steps:

  1. Go to a development workspace.
  2. Click Start execution, then click All actions.
  3. Optional: To rebuild all tables from scratch, select the Run with full refresh option. Without this option, Dataform updates incremental tables without rebuilding them from scratch.
  4. Click Start execution.

Manually execute selected actions

To manually trigger execution of selected actions, follow these steps:

  1. Go to your development workspace.
  2. Click Start execution, then do either of the following:
    • Click Actions, then select an action that you want to execute.
    • Click Actions, then click Multiple actions.
  3. In the Start execution pane, do the following:
    1. In the Select actions to execute drop-down, select the actions that you want to execute.
    2. Optional: To execute the selected actions and their dependencies, select the Include dependencies option.
    3. Optional: To execute the selected actions and the actions that depend on them, select the Include dependents option.
    4. Optional: To rebuild all tables from scratch, select the Run with full refresh option.
    5. Click Start execution.

Manually execute actions with selected tags

To manually trigger execution of actions with selected tags, follow these steps:

  1. Go to your development workspace.
  2. Click Start execution, then do either of the following:
    • Click Tags, then select a tag that you want to execute.
    • Click Tags, then click Multiple tags.
  3. In the Tags tab, do the following:
    1. In the Select tags to execute drop-down, select the tags that you want to execute.
    2. Optional: To execute actions with the selected tags and their dependencies, select the Include dependencies option.
    3. Optional: To execute actions with the selected tags and the actions that depend on them, select the Include dependents option.
    4. Optional: To rebuild all tables from scratch, select the Run with full refresh option. Without this option, Dataform updates incremental tables without rebuilding them from scratch.
    5. Click Start execution.

What's next