Create and execute a SQL workflow in Dataform recensioni

There seems to be an IAM mismatch or a missing IAM grant in this lab. Starting execution is Task 6 Returns "API request error: Service account must be set when strict act as checks are enabled." Dataflow SA had required roles student_03_e6b31a9720cb@cloudshell:~ (qwiklabs-gcp-00-27fd27a21e5f)$ gcloud projects get-iam-policy qwiklabs-gcp-00-27fd27a21e5f \ --flatten="bindings[].members" \ --format='table(bindings.role)' \ --filter="bindings.members:service-471919455656@gcp-sa-dataform.iam.gserviceaccount.com" ROLE: roles/bigquery.dataEditor ROLE: roles/bigquery.dataViewer ROLE: roles/bigquery.jobUser ROLE: roles/dataform.serviceAgent and had been selected to be used for execution. What finally worked (by help of Gemini): I used the Compute Engine SA (instead of the Dataform Service Agent) and allowed this to impersonate the Dataform SA gcloud iam service-accounts add-iam-policy-binding \ 471919455656-compute@developer.gserviceaccount.com \ --member="serviceAccount:service-471919455656@gcp-sa-dataform.iam.gserviceaccount.com" \ --role="roles/iam.serviceAccountTokenCreator" This finally worked.

Carsten W. · Recensione inserita 22 giorni fa

Arpitha S. · Recensione inserita 22 giorni fa

AASHIKA SUKHINESH GOPALAN P. · Recensione inserita 22 giorni fa

Pallavi C. · Recensione inserita 22 giorni fa

Avinash V. · Recensione inserita 22 giorni fa

Polampally S. · Recensione inserita 22 giorni fa

GOOD

Seshadri K. · Recensione inserita 22 giorni fa

Polampally S. · Recensione inserita 22 giorni fa

good

Tahaseen A. · Recensione inserita 22 giorni fa

Avinash V. · Recensione inserita 22 giorni fa

Please make the updation for the last step, its showing "API request error: Dataform does not have the necessary permissions to run your workload using end user credentials. Please grant the necessary permissions to Dataform and then retry." even though made the complete process perfectly...

Pasupulati S. · Recensione inserita 22 giorni fa

the execution phase of the lab is not working

Tulika O. · Recensione inserita 22 giorni fa

Polampally S. · Recensione inserita 22 giorni fa

BADIKOLU C. · Recensione inserita 22 giorni fa

Divya N. · Recensione inserita 22 giorni fa

Akash V. · Recensione inserita 22 giorni fa

Best

Maru M. · Recensione inserita 22 giorni fa

worst labs

RITHIKA S. · Recensione inserita 22 giorni fa

Couldn't complete the lab due to errors that I can't fix

Anupiya A. · Recensione inserita 22 giorni fa

Shephali B. · Recensione inserita 22 giorni fa

Tejas R. · Recensione inserita 22 giorni fa

ADVAITH NAMBIAR P. · Recensione inserita 22 giorni fa

Sujoy S. · Recensione inserita 22 giorni fa

Viprakshi G. · Recensione inserita 22 giorni fa

worst lab

MADHUMITHA N V P. · Recensione inserita 22 giorni fa