Create and execute a SQL workflow in Dataform Reviews

it is not working in last step

shabnam h. · Reviewed около 2 месяцев ago

Devesh B. · Reviewed около 2 месяцев ago

Ansar A. · Reviewed около 2 месяцев ago

Moganti Pavani S. · Reviewed около 2 месяцев ago

Katipally S. · Reviewed около 2 месяцев ago

Donthireddy K. · Reviewed около 2 месяцев ago

good

Tahaseen A. · Reviewed около 2 месяцев ago

Marcin D. · Reviewed около 2 месяцев ago

Moganti Pavani S. · Reviewed около 2 месяцев ago

Muttafeen .. · Reviewed около 2 месяцев ago

not satisfied because in every try the last step shows an api error everytime . pls fix this issue

Nipun J. · Reviewed около 2 месяцев ago

Manorama A. · Reviewed около 2 месяцев ago

SHIOU CHI . · Reviewed около 2 месяцев ago

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. · Reviewed около 2 месяцев ago

Arpitha S. · Reviewed около 2 месяцев ago

AASHIKA SUKHINESH GOPALAN P. · Reviewed около 2 месяцев ago

Pallavi C. · Reviewed около 2 месяцев ago

Avinash V. · Reviewed около 2 месяцев ago

Polampally S. · Reviewed около 2 месяцев ago

GOOD

Seshadri K. · Reviewed около 2 месяцев ago

Polampally S. · Reviewed около 2 месяцев ago

good

Tahaseen A. · Reviewed около 2 месяцев ago

Avinash V. · Reviewed около 2 месяцев ago

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. · Reviewed около 2 месяцев ago

the execution phase of the lab is not working

Tulika O. · Reviewed около 2 месяцев ago