Invoke Dataform single sqlx using Cloud workflows

Google Cloud Data Analytics
1

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
2 Likes
2

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:

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