Help with BigQuery API skill - Insufficient permission

SebT — Thu, 30 Dec 2021 11:10:15 GMT

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

Re: Help with BigQuery API skill - Insufficient permission

ewilson — Mon, 03 Jan 2022 01:38:17 GMT

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

Re: Help with BigQuery API skill - Insufficient permission

SebT — Mon, 03 Jan 2022 11:16:44 GMT

That did the trick @Eric Wilson !

Thank you very much.

Br,
Seb

topic Re: Help with BigQuery API skill - Insufficient permission in Digital Exchange

Help with BigQuery API skill - Insufficient permission

Re: Help with BigQuery API skill - Insufficient permission

Re: Help with BigQuery API skill - Insufficient permission