30-12-21 11:10 AM
Hi all,
I'm having trouble getting the BigQuery Skill to work. More specifically I am receiving the following 403 error when trying to run the "BigQuery.datasets.get" action.
Internal : Unexpected error Error during Web API HTTP Request
HTTP Status Code: 403
HTTP Response Content: {
"error": {
"code": 403,
"message": "Request had insufficient authentication scopes.",
"errors": [
{
"message": "Insufficient Permission",
"domain": "global",
"reason": "insufficientPermissions"
}
],
"status": "PERMISSION_DENIED",
"details": [
{
"@type": "type.googleapis.com/google.rpc.ErrorInfo",
"reason": "ACCESS_TOKEN_SCOPE_INSUFFICIENT",
"domain": "googleapis.com",
"metadata": {
"method": "google.cloud.bigquery.v2.DatasetService.GetDataset",
"service": "bigquery.googleapis.com"
My colleague on the BigQuery side has assured me that the service account should have all necessary permissions.
The OAuth credential has been setup following the API release notes:
Username:
du-blueprism@xxxxx.iam.gserviceaccount.com
Password:
"--- BEGIN PRIVATE KEY ---- \n
xxxxxx
----END PRIVATE KEY ---- \n"
Anyone experiencing the same issues or could guide me as to what specific permissions are needed for the service account in order to get this to work?
I haven't changed any of the default API authentication settings that came with the Skill.
Br,
Seb
Answered! Go to Answer.
03-01-22 01:38 AM
Hi @Seb T,
I believe the Scope defined in the Common Authentication section is incorrect. Try changing it to:
https://www.googleapis.com/auth/bigquery
Cheers,
Eric
03-01-22 01:38 AM
Hi @Seb T,
I believe the Scope defined in the Common Authentication section is incorrect. Try changing it to:
https://www.googleapis.com/auth/bigquery
Cheers,
Eric
03-01-22 11:16 AM