Create and execute a SQL workflow in Dataform avis
23504 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
Nous ne pouvons pas certifier que les avis publiés proviennent de consommateurs qui ont acheté ou utilisé les produits. Les avis ne sont pas vérifiés par Google.