[[["容易理解","easyToUnderstand","thumb-up"],["確實解決了我的問題","solvedMyProblem","thumb-up"],["其他","otherUp","thumb-up"]],[["難以理解","hardToUnderstand","thumb-down"],["資訊或程式碼範例有誤","incorrectInformationOrSampleCode","thumb-down"],["缺少我需要的資訊/範例","missingTheInformationSamplesINeed","thumb-down"],["翻譯問題","translationIssue","thumb-down"],["其他","otherDown","thumb-down"]],["上次更新時間:2025-09-04 (世界標準時間)。"],[[["\u003cp\u003eDataform enables the development, testing, and version control of SQL workflows for data transformation in BigQuery.\u003c/p\u003e\n"],["\u003cp\u003eSQL workflows in Dataform consist of objects like data source declarations, tables, assertions, custom SQL operations, and includes.\u003c/p\u003e\n"],["\u003cp\u003eDataform visualizes SQL workflows as a Directed Acyclic Graph (DAG), displaying the objects and their relationships.\u003c/p\u003e\n"],["\u003cp\u003eYou can execute SQL workflows manually, or schedule them using release and workflow configurations, Cloud Composer, or Workflows and Cloud Scheduler.\u003c/p\u003e\n"],["\u003cp\u003eDataform allows for the customization of execution settings using compilation overrides and tags, creating isolated execution environments for workspaces.\u003c/p\u003e\n"]]],[],null,["# Overview of workflows\n\nThis document helps you understand the architecture and execution of\nworkflows in Dataform.\n\nYou can use Dataform to develop, test, and version control\nworkflows that you can run in BigQuery to transform data for\nanalytics purposes. You can develop workflows with\n[Dataform core](/dataform/docs/overview#dataform-core), using SQLX files and\noptionally JavaScript files, or with [JavaScript](/dataform/docs/javascript-in-dataform).\n\nA workflow can consist of the following objects:\n\n[Data source declarations](/dataform/docs/declare-source)\n: Declarations of BigQuery data sources that let you reference these\n data sources in Dataform table definitions and SQL operations.\n\n[Tables](/dataform/docs/create-tables)\n: Tables that you create in Dataform based on the declared\n data sources or other tables in your workflow. Dataform supports\n the following table types: table, incremental table, view, and materialized view.\n\n[Assertions](/dataform/docs/assertions)\n: Data quality test queries that you can use to validate table data.\n Dataform runs assertions every time it updates your workflow\n and it alerts you if any assertions fail.\n\n[Custom SQL operations](/dataform/docs/custom-sql)\n: SQL statements that Dataform runs in BigQuery as they are,\n without modification.\n\n[Includes](/dataform/docs/javascript-in-dataform#reuse_code_across_a_single_repository_with_includes)\n: JavaScript files with definitions of variables and functions that you can\n reuse across your workflow.\n\nVisualisation of a workflow\n---------------------------\n\nYou can view your workflow visualized in the form of a\nDirected Acyclic Graph (DAG). The DAG displays all objects of the workflow\ndefined in your workspace, and the relationships between them. You can zoom in\nand out and use drag-and-drop navigation in the DAG. If there are compilation\nerrors in your workflow, Dataform displays an error message\ninstead of the DAG.\n\nTo view the DAG of your workflow, in your workspace, click **Compiled graph**.\n\nExecution of a workflow\n-----------------------\n\nIn your development workspace, you can\n[manually trigger a run](/dataform/docs/trigger-execution) of your entire\nworkflow, a selection of actions, or a selection of tags.\n\nYou can schedule runs with Dataform\n[release configurations](/dataform/docs/configure-compilation#create-release-configuration)\nand [workflow configurations](/dataform/docs/schedule-runs#workflow-configurations).\nFirst, create a release configuration to create compilation results\nof your repository. Then, create a workflow configuration, select a\nrelease configuration, select workflow actions that you want to run,\nand set the run schedule.\n\nAlternatively, you can schedule runs either with\n[Cloud Composer](/dataform/docs/schedule-runs#composer), or with\n[Workflows and Cloud Scheduler](/dataform/docs/schedule-runs#workflows-cloud-scheduler).\n\nDuring execution, Dataform runs SQL queries in BigQuery,\nfollowing the order of object dependencies in your workflow.\nAfter execution, you can use your defined tables and views for all\nyour analytics purposes in BigQuery.\n\n### Execution configuration options\n\nTo run a specific group of your workflow actions, you can add\n[Dataform execution tags](/dataform/docs/configure-additional-actions#add-execution-tags)\nto the files you select. You can then\n[run only the files with a selected tag](/dataform/docs/trigger-execution#manually_execute_actions_with_selected_tags)\nwhen you manually trigger a run.\n\nBy default, Dataform runs your workflow with the execution\nsettings defined in the `dataform.json` file.\nYou can override these execution settings with compilation overrides.\n\nWith\n[workspace compilation overrides](/dataform/docs/configure-compilation#create-workspace-compilation-overrides),\nyou can turn workspaces into isolated\nexecution environments. This means that when you manually trigger execution in\na workspace, Dataform runs the output in an isolated location in\nBigQuery.\n\nTo create and run a single compilation result with compilation\noverrides you can pass requests\n[with the Dataform API](/dataform/docs/configure-compilation#configure-compilation-overrides-with-api).\n\nWith\n[release configurations](/dataform/docs/configure-compilation#create-release-configuration),\nyou can configure compilation overrides for your whole repository, as well as\nthe frequency of creating compilation results with the applied settings.\n\nTo learn more about ways to configure compilation and code lifecycle in\nDataform, see\n[Introduction to code lifecycle in Dataform](/dataform/docs/configure-compilation#intro-code-lifecycle).\n\nWhat's next\n-----------\n\n- To learn how to declare a data source, see [Declare a data source](/dataform/docs/declare-source).\n- To learn how to declare dependencies to define relationships between objects in your workflow, see [Set dependencies](/dataform/docs/dependencies).\n- To learn how to define custom SQL operations, see [Create operations](/dataform/docs/custom-sql).\n- To learn how to reuse variables and functions across your workflow with includes, see [Reuse code across a single repository with includes](/dataform/docs/javascript-in-dataform#reuse_code_across_a_single_repository_with_includes)."]]