Create and execute a SQL workflow in Dataform Reviews

Impossible to finish, unable to start the execution, error : "API request error: Service account must be set when strict act as checks are enabled. " even if we give all possible roles in IAM...

Paul B. · Reviewed 15 days ago

Benny G. · Reviewed 15 days ago

Not working, the permissions are not granted and the last task is not possible to complete.

Iván Marcelo U. · Reviewed 15 days ago

B NEEHARIKA P. · Reviewed 15 days ago

Madhav B. · Reviewed 15 days ago

B NEEHARIKA P. · Reviewed 15 days ago

bad

Avanee U. · Reviewed 15 days ago

Permissions on principal service acct don't get applied. This error is returned: 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.

Eric L. · Reviewed 15 days ago

enforcment has to be disabled to complete lab, please modify instructions

Sathya N. · Reviewed 15 days ago

Nandani S. · Reviewed 15 days ago

Many problems with the permisions of the service account. The step by step was not working on IAM permisions.

Guilherme H. · Reviewed 15 days ago

Harini s. · Reviewed 15 days ago

Perfect,

Pasupulati S. · Reviewed 15 days ago

Valentin M. · Reviewed 15 days ago

Gustavo L. · Reviewed 15 days ago

Cannot complete Lab because of error: 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.

Martina B. · Reviewed 15 days ago

last part didnt work

Alexander K. · Reviewed 15 days ago

shivakumar y. · Reviewed 15 days ago

Vaidurya S. · Reviewed 15 days ago

permission issues

Bob S. · Reviewed 15 days ago

Hi, I am unable to complete the lab 'Create and execute a SQL workflow in Dataform' due to a broken lab environment — this is not a user error. The issue: The Qwiklabs project has an org policy 'iam.managed.disableServiceAccountApiKeyCreation' that is ENFORCED at the parent organization level. This policy blocks Dataform from executing workflows with a service account, throwing the error: 'API request error: Service account must be set when strict act as checks are enabled.' I have tried everything: - Granted the Dataform service account all required BigQuery roles (Job User, Data Editor, Data Viewer) - Added Service Account Token Creator role - Tried executing with user credentials, Qwiklabs User Service Account, and Default Dataform service account - Restarted the lab multiple times - The org policy cannot be edited as the student account does not have orgpolicy.policies.update permission The lab is impossible to complete in this state. Please either fix the lab environment, override the org policy for this lab's project, or grant me credit for Task 6 manually. Project ID: qwiklabs-gcp-04-df1be1f9c280 Lab: Create and execute a SQL workflow in Dataform Course: Introduction to Data Engineering on Google Cloud Thank you.

AASHIKA A P. · Reviewed 15 days ago

Shresht A. · Reviewed 15 days ago

Pillalamarri S. · Reviewed 15 days ago

SAMUEL M. · Reviewed 15 days ago

Alexandre L. · Reviewed 15 days ago