Dataform で SQL ワークフローを作成して実行する のレビュー

Addanki Manorama · 26日前にレビュー済み

YU SHIOU CHI · 26日前にレビュー済み

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.

Weiner Carsten · 26日前にレビュー済み

Sushe Arpitha · 26日前にレビュー済み

PESU-EC-B.Tech 2023 AASHIKA SUKHINESH GOPALAN · 26日前にレビュー済み

Chinnamadakka Pallavi · 26日前にレビュー済み

V Avinash · 26日前にレビュー済み

Sai Teja Polampally · 26日前にレビュー済み

GOOD

Kandala Seshadri · 26日前にレビュー済み

Sai Teja Polampally · 26日前にレビュー済み

good

Anjum Tahaseen · 26日前にレビュー済み

V Avinash · 26日前にレビュー済み

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...

Sai meghana Pasupulati · 26日前にレビュー済み

the execution phase of the lab is not working

Omer Tulika · 26日前にレビュー済み

Sai Teja Polampally · 26日前にレビュー済み

CHANDANA BADIKOLU · 26日前にレビュー済み

Nayak Divya · 26日前にレビュー済み

Verma Akash · 26日前にレビュー済み

Best

Man Maru · 26日前にレビュー済み

worst labs

S RITHIKA · 26日前にレビュー済み

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

Alwis Anupiya · 26日前にレビュー済み

Bansal Shephali · 26日前にレビュー済み

Ramakrishnan Tejas · 26日前にレビュー済み

PESU-EC-B.Tech 2023 ADVAITH NAMBIAR · 26日前にレビュー済み

Sen Sujoy · 26日前にレビュー済み