Help with BigQuery API skill - Insufficient permission

[SebT]

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

[ewilson · Accepted solution]

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

[SebT]

That did the trick @Eric Wilson !

Thank you very much.

Br,
Seb​