Get hands-on experience with 20+ free Google Cloud products and $300 in free credit for new customers.

How to Categorize BigQuery Jobs by Dataform Routine

Hi there,

I have a Jobs table (JOBS_BY_PROJECT from INFORMATION_SCHEMA) in my BigQuery. I want to differentiate and categorize these jobs based on the Dataform routine from which they were executed. I tried identifying it using the labels and job execution ID, but it doesn’t indicate the Dataform workflow.

GuilhermeKaneda_0-1730220756041.png

How could I retrieve the workflow or version of a Dataform job?

GuilhermeKaneda_1-1730220836332.png

Thanks,
Guilherme

0 1 200
1 REPLY 1