Skip to main content

Check workflow execution

Check worflow execution​

In Dataform, a workflow defines the set of SQL queries that make up a data model. These queries are executed in a specific order to build tables in BigQuery. The complete execution of all these queries is referred to as a "workflow."

If you're not seeing the expected tables in BigQuery, or if tables appear incomplete, have missing dates, or other issues, the first thing to check is whether your workflows have been executed correctly and without errors.

screenshot

Above is an example of workflows executed over time. Some executions are marked in green, indicating success, while others are red, indicating errors. By examining the Source column, you can determine for eah row, whether a single model, an entire workspace, or a full workflow was executed. You can drill down into each execution to review the detailed execution of all the models of the workflow you have selected.

screenshot

Lastly, by clicking on a specific query, you can access detailed information about its process and failure raisons is thee is one. This is particularly useful for troubleshooting when a model hasn’t run as expected.

Check workflow execution after running GA4 installer​

note

This section is specifically for users who have authorized data processing for their historical GA4 data via the optional steps after using the GA4 installer. If you’re new to Dataform, we recommend reviewing the previous Overview and How to Check Workflow Execution sections first.

If you’re allowing GA4Dataform to process a relatively large GA4 dataset, running the Superform workflow may take several minutes, dozens of minutes, or even hours. If you can't see the table outputs in BigQuery, follow these steps to check your workflow execution:

  1. Access Dataform.
  2. Open the superform_analytics_* repository.
  3. Navigate to the Workflow Execution Logs section.

screenshot

If the workflow status is not green yet, you can click the Refresh button. Feel free to click it multiple times until the workflow completes successfully and turns green.