Failure for Establish connection between Retool and Google ServiceAccount for BigQuery Integration

🤝 Discussion
,
4

Hello @everett_smith
I was able to figure out a couple of things from my end and would love the Retool team to add this to their official documentation.

  1. Service account to be used for integrations must be created in the project where the cloud resource resides (e.g project_datalake).
  2. Permissions for the service account must be granted on the project level and not the resource level (e.g roles/bigquery.dataViewer and roles/bigquery.user should be granted to project_datalake and not the dataset containing tables of concern).

Best regards!

1 Like