Hi All,
I am working on a project where I need to connect to Google BigQuery.
I installed the Simba BigQuery driver and set the connection. The connection was successful.
However, when I try to run the workflow, it errors out saying : "[Simba][BigQuery] (131) Unable to authenticate with Google BigQuery Storage API. Check your account permissions.
"
I do have permissions to all the tables which I am connecting.
Are you using the BQ tool or a generic ODBC? If you are using a generic ODBC how are you connecting? If you are not connecting via username/password combo (or via SAML directly through ODBC64) are you connecting via client key/client secret? Does the client have the necessary permissions in BQ?
I am using Generic ODBC. I am connecting via user authentication, giving the confirmation key.
After providing the key, I selected the Catalog(Project) and Datasets. I have confirmed my access with the team and I have proper access to those datasets
Test your permissions in BQ in the GCP console.
I checked the permissions to the given Datasets in the console as well as in Tableau by directly connecting datasets. I do have the access to these datasets.