Create and execute a SQL workflow in Dataform avis

SHIOU CHI . · Examiné il y a 27 jours

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. · Examiné il y a 27 jours

Arpitha S. · Examiné il y a 27 jours

AASHIKA SUKHINESH GOPALAN P. · Examiné il y a 27 jours

Pallavi C. · Examiné il y a 28 jours

Avinash V. · Examiné il y a 28 jours

Polampally S. · Examiné il y a 28 jours

GOOD

Seshadri K. · Examiné il y a 28 jours

Polampally S. · Examiné il y a 28 jours

good

Tahaseen A. · Examiné il y a 28 jours

Avinash V. · Examiné il y a 28 jours

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. · Examiné il y a 28 jours

the execution phase of the lab is not working

Tulika O. · Examiné il y a 28 jours

Polampally S. · Examiné il y a 28 jours

BADIKOLU C. · Examiné il y a 28 jours

Divya N. · Examiné il y a 28 jours

Akash V. · Examiné il y a 28 jours

Best

Maru M. · Examiné il y a 28 jours

worst labs

RITHIKA S. · Examiné il y a 28 jours

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

Anupiya A. · Examiné il y a 28 jours

Shephali B. · Examiné il y a 28 jours

Tejas R. · Examiné il y a 28 jours

ADVAITH NAMBIAR P. · Examiné il y a 28 jours

Sujoy S. · Examiné il y a 28 jours

Viprakshi G. · Examiné il y a 28 jours