To manually trigger a run of all the actions in your workflow,
follow these steps:
Go to a development workspace.
Click Start execution.
Click Actions > Multiple actions.
In the Authentication section, authorize the
execution with your Google Account user credentials or a service
account.
To use your Google Account user credentials
(Preview), select
Execute with user credentials.
To use a service account, select
Execute with selected service account, and then select a service account.
Select All actions.
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.
Click Start execution. If you selected Execute with user credentials
for your authentication method, you must
authorize your Google Account
(Preview).
Manually run selected actions
To manually trigger a run of selected actions, follow these steps:
Go to your development workspace.
Click Start execution, then do either of the following:
Click Actions, then select an action that you want to run.
Click Actions > Multiple actions.
In the Authentication section, authorize the
execution with your Google Account user credentials or a service
account.
To use your Google Account user credentials
(Preview), select
Execute with user credentials.
To use a service account, select
Execute with selected service account, and then select a service account.
Verify that Selection of actions is selected.
In the Select actions to execute menu, select the actions
that you want to run.
Optional: To run the selected actions and their dependencies,
select the Include dependencies option.
Optional: To run the selected actions and the actions that
depend on them, select the Include dependents option.
Optional: To rebuild all tables from scratch, select
the Run with full refresh option.
Click Start execution. If you selected Execute with my user
credentials for your authentication method, you must
authorize your Google Account
(Preview).
Manually run actions with selected tags
To manually trigger a run of actions with selected tags, follow these
steps:
Go to your development workspace.
Click Start execution, then do either of the following:
Click Tags, then select a tag that you want to run.
Click Tags > Multiple tags.
In the Authentication section, authorize the
execution with your Google Account user credentials or a service
account.
To use your Google Account user credentials
(Preview), select
Execute with user credentials.
To use a service account, select
Execute with selected service account, and then select a service account.
Verify that Selection of tags is selected.
In the Select tags to execute menu, select the tags
that you want to run.
Optional: To run the actions with the selected tags and
their dependencies, select the Include dependencies option.
Optional: To run the actions with the selected tags and the actions
that depend on them, select the Include dependents option.
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.
Click Start execution. If you selected Execute with my user
credentials for your authentication method, you must
authorize your Google Account
(Preview).
Authorize your Google Account
To authenticate the resource with your
Google Account
user credentials, you must manually grant permission for BigQuery
pipelines to get the access token for your Google Account and access the source
data on your behalf. You can grant manual approval with the OAuth dialog
interface.
You only need to give permission to BigQuery pipelines once.
To revoke the permission that you granted, follow these steps:
[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Hard to understand","hardToUnderstand","thumb-down"],["Incorrect information or sample code","incorrectInformationOrSampleCode","thumb-down"],["Missing the information/samples I need","missingTheInformationSamplesINeed","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2025-08-25 UTC."],[[["\u003cp\u003eThis document details how to manually trigger the execution of your SQL workflow in Dataform, including the ability to execute all actions, selected actions, or actions with selected tags.\u003c/p\u003e\n"],["\u003cp\u003eYou can choose to execute all actions within your workflow by navigating to your development workspace and selecting the "All actions" option under "Start execution".\u003c/p\u003e\n"],["\u003cp\u003eTo execute specific actions, you can manually select individual or multiple actions from the "Actions" menu, and optionally include their dependencies or dependents in the execution.\u003c/p\u003e\n"],["\u003cp\u003eExecuting actions based on tags is possible by selecting one or multiple tags from the "Tags" menu, with the option to include dependent or dependencies in the execution.\u003c/p\u003e\n"],["\u003cp\u003eYou can opt to rebuild all tables from scratch using the "Run with full refresh" option when executing actions, or skip the full rebuild to update only incremental tables.\u003c/p\u003e\n"]]],[],null,["# Manually trigger runs\n\nThis document shows you how to manually trigger runs of your entire\nworkflow or only selected elements in your workflow.\n\nYou can trigger a run for the following elements of your workflow:\n\n- All actions in your workflow\n- Selected actions\n- Actions with selected tags\n\nBefore you begin\n----------------\n\n1. In the Google Cloud console, go to the **Dataform** page.\n\n [Go to the Dataform page](https://console.cloud.google.com/bigquery/dataform)\n2. Select or [create a repository](/dataform/docs/create-repository).\n\n3. Select or [create a development workspace](/dataform/docs/create-workspace).\n\n4. Develop your workflow.\n\n### Required roles\n\n\nTo get the permissions that\nyou need to manually trigger a run ,\n\nask your administrator to grant you the\nfollowing IAM roles on workflowInvocations:\n\n- [Dataform Editor](/iam/docs/roles-permissions/dataform#dataform.editor) (`roles/dataform.editor`)\n- [BigQuery Job User](/iam/docs/roles-permissions/bigquery#bigquery.jobUser) (`roles/bigquery.jobUser`)\n\n\nFor more information about granting roles, see [Manage access to projects, folders, and organizations](/iam/docs/granting-changing-revoking-access).\n\n\nYou might also be able to get\nthe required permissions through [custom\nroles](/iam/docs/creating-custom-roles) or other [predefined\nroles](/iam/docs/roles-overview#predefined).\n\nManually run all the actions in your workflow\n---------------------------------------------\n\nTo manually trigger a run of all the actions in your workflow,\nfollow these steps:\n\n1. Go to a development workspace.\n2. Click **Start execution**.\n3. Click **Actions \\\u003e Multiple actions**.\n4. In the **Authentication** section, authorize the\n execution with your Google Account user credentials or a service\n account.\n\n - To use your Google Account user credentials ([Preview](/products#product-launch-stages)), select **Execute with user credentials**.\n - To use a service account, select **Execute with selected service account**, and then select a service account.\n5. Select **All actions**.\n\n6. Optional: To rebuild all tables from scratch, select the\n **Run with full refresh** option. Without this option, Dataform\n updates incremental tables without rebuilding them from scratch.\n\n7. Click **Start execution** . If you selected **Execute with user credentials**\n for your authentication method, you must\n [authorize your Google Account](#authorize-google-account)\n ([Preview](/products#product-launch-stages)).\n\nManually run selected actions\n-----------------------------\n\nTo manually trigger a run of selected actions, follow these steps:\n\n1. Go to your development workspace.\n2. Click **Start execution**, then do either of the following:\n\n - Click **Actions**, then select an action that you want to run.\n - Click **Actions \\\u003e Multiple actions**.\n3. In the **Authentication** section, authorize the\n execution with your Google Account user credentials or a service\n account.\n\n - To use your Google Account user credentials ([Preview](/products#product-launch-stages)), select **Execute with user credentials**.\n - To use a service account, select **Execute with selected service account**, and then select a service account.\n4. Verify that **Selection of actions** is selected.\n\n5. In the **Select actions to execute** menu, select the actions\n that you want to run.\n\n6. Optional: To run the selected actions and their dependencies,\n select the **Include dependencies** option.\n\n7. Optional: To run the selected actions and the actions that\n depend on them, select the **Include dependents** option.\n\n8. Optional: To rebuild all tables from scratch, select\n the **Run with full refresh** option.\n\n9. Click **Start execution** . If you selected **Execute with my user\n credentials** for your authentication method, you must\n [authorize your Google Account](#authorize-google-account)\n ([Preview](/products#product-launch-stages)).\n\nManually run actions with selected tags\n---------------------------------------\n\nTo manually trigger a run of actions with selected tags, follow these\nsteps:\n\n1. Go to your development workspace.\n2. Click **Start execution**, then do either of the following:\n\n - Click **Tags**, then select a tag that you want to run.\n - Click **Tags \\\u003e Multiple tags**.\n3. In the **Authentication** section, authorize the\n execution with your Google Account user credentials or a service\n account.\n\n - To use your Google Account user credentials ([Preview](/products#product-launch-stages)), select **Execute with user credentials**.\n - To use a service account, select **Execute with selected service account**, and then select a service account.\n4. Verify that **Selection of tags** is selected.\n\n5. In the **Select tags to execute** menu, select the tags\n that you want to run.\n\n6. Optional: To run the actions with the selected tags and\n their dependencies, select the **Include dependencies** option.\n\n7. Optional: To run the actions with the selected tags and the actions\n that depend on them, select the **Include dependents** option.\n\n8. Optional: To rebuild all tables from scratch, select\n the **Run with full refresh** option. Without this option, Dataform\n updates incremental tables without rebuilding them from scratch.\n\n9. Click **Start execution** . If you selected **Execute with my user\n credentials** for your authentication method, you must\n [authorize your Google Account](#authorize-google-account)\n ([Preview](/products#product-launch-stages)).\n\nAuthorize your Google Account\n-----------------------------\n\n|\n| **Preview**\n|\n|\n| This product or feature is subject to the \"Pre-GA Offerings Terms\" in the General Service Terms section\n| of the [Service Specific Terms](/terms/service-terms#1).\n|\n| Pre-GA products and features are available \"as is\" and might have limited support.\n|\n| For more information, see the\n| [launch stage descriptions](/products#product-launch-stages).\n| **Note:** To request support or provide feedback for this feature, contact [dataform-preview-support@google.com](mailto:dataform-preview-support@google.com).\n\nTo authenticate the resource with your\n[Google Account](/iam/docs/principals-overview#google-account)\nuser credentials, you must manually grant permission for BigQuery\npipelines to get the access token for your Google Account and access the source\ndata on your behalf. You can grant manual approval with the OAuth dialog\ninterface.\n\nYou only need to give permission to BigQuery pipelines once.\n\nTo revoke the permission that you granted, follow these steps:\n\n1. Go to your [Google Account page](https://myaccount.google.com/).\n2. Click **BigQuery Pipelines**.\n3. Click **Remove access**.\n\n| **Warning:** Revoking access permissions prevents any future pipeline runs that this Google Account owns across all regions.\n\nWhat's next\n-----------\n\n- To learn how Dataform runs incremental tables and how to configure an incremental table, see [Configure an incremental table](/dataform/docs/create-tables#configure-incremental-table).\n- To learn how to view execution logs, see [Monitor execution logs](/dataform/docs/monitor-runs#monitor-execution-logs).\n- To learn how to schedule runs with Workflows and Cloud Scheduler, see [Schedule runs with Workflows and Cloud Scheduler](/dataform/docs/schedule-runs#workflows-cloud-scheduler).\n- To learn how to schedule runs with Cloud Composer, see [Schedule runs with Cloud Composer](/dataform/docs/schedule-runs#composer)."]]