Invoke Dataform single sqlx using Cloud workflows

[arumawadu_hasi]

Hi All,

I'm invoking Dataform using Cloud workflows. I can invoke single sqlx file using tags(includedTags). But instead of tags, I want to invoke it using Dataform actions. Is there anyway? Please find the below yaml file.

- createWorkflowInvocation:

call: http.post

args:

   url: ${"https://dataform.googleapis.com/v1beta1/projects/" + project_id + "/locations/" + location + "/repositories/" + repository_id + "/workflowInvocations"}

auth:

   type: OAuth2

body:

   compilationResult: ${compilationResult.body.name}

      invocationConfig:

         includedTags:

            - employee_total

        transitiveDependenciesIncluded: true

result: workflowInvocation

[lsolatorio]

Hi @arumawadu_hasi, 

Thanks for reaching out! I understand you're looking for some guidance on creating a SQL workflow with Dataform.

I've attached a quickstart guide that walks you through the steps – it should help you get started.

In addition, I found this helpful post that tackles a similar challenge. It might offer some alternative approaches you might find useful.

Listing down a few more useful resources:

• Execute a workflow by using client libraries
• Load data from Cloud Storage to BigQuery using Workflows
• Schedule executions with Workflows and Cloud Scheduler

I hope I was able to provide you with useful insights.