Skip to content

Execute workflows with batch priority. #2005

Open

Description

@nicolascelys-mb

Feature request:

It will be nice to execute workflows indicating batch priority. It should work as described here:

https://discuss.google.dev/t/is-it-possible-to-set-priority-of-dataform-execution-to-batch/155123/2?u=nicolas-mb

Activity

  1. kolina commented on Aug 18, 2025

    @kolina
    Contributor

    Do you want to have this ability in the GCP Dataform or in the Dataform CLI?

  2. nicolascelys-mb commented on Aug 18, 2025

    @nicolascelys-mb
    Author

    it will be fabulous to achieve this.

    Edit dataform.json Configuration:

    Open your dataform.json file and add or modify the defaultConfig section:

    {
    "defaultConfig": {
    "bigquery": {
    "priority": "BATCH"
    }
    }
    }
    This sets BATCH as the default priority for all BigQuery operations in your Dataform project.

    1. Configure in config Block (Granular Control):

    For specific SQLX scripts, you can set the priority directly in the config block:

    config {
    type: "table",
    bigquery: {
    priority: "BATCH"
    }
    }

    -- Your SQL code here
    This allows you to control which scripts use BATCH priority.

  3. kolina commented on Aug 19, 2025

    @kolina
    Contributor

    Sure, but let me repeat my question: how do you run Dataform DAGs in production? Do you use Managed Dataform in GCP or you manage Dataform yourself and use the Dataform CLI?

  4. nicolascelys-mb commented on Aug 19, 2025

    @nicolascelys-mb
    Author

    I use GCP

  5. kolina commented on Aug 21, 2025

    @kolina
    Contributor

    We're working on the support of configuring batch priority in the GCP Dataform at the moment. Initially it'll be supported as configuration when starting a new workflow invocation (as follow up we may add default configuration in dataform.json / workflow_settings.yaml)

  6. nicolascelys-mb commented on Oct 10, 2025

    @nicolascelys-mb
    Author

    As a follow up, in GCP in the workflows, now has an option to unmark and leave the execution with batch priority. Pretty cool

  7. nicolascelys-mb commented on Oct 10, 2025

    @nicolascelys-mb
    Author

    I believe the documentation in Datafom of GCP should highlight this.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions