Skip to content

Destination BigQuery: Check should fail if we have insufficient permissions #16992

@edgao

Description

@edgao

from https://github.com/airbytehq/oncall/issues/640

destinatoin-bigquery failed with:

com.google.api.client.googleapis.json.GoogleJsonResponseException: 403 Forbidden POST https://www.googleapis.com/bigquery/v2/projects/<redacted> { "code" : 403, "errors" : [ { "domain" : "global", "message" : "Access Denied: Dataset <redacted>: Permission bigquery.tables.create denied on dataset <redacted> (or it may not exist).", "reason" : "accessDenied" } ], "message" : "Access Denied: Dataset <redacted>: Permission bigquery.tables.create denied on dataset <redacted> (or it may not exist).", "status" : "PERMISSION_DENIED" } at com.google.api.client.googleapis.json.GoogleJsonResponseException.from(GoogleJsonResponseException.java:146) at com.google.api.client.googleapis.services.json.AbstractGoogleJsonClientRequest.newExceptionOnError(AbstractGoogleJsonClientRequest.java:118) at com.google.api.client.googleapis.services.json.AbstractGoogleJsonClientRequest.newExceptionOnError(AbstractGoogleJsonClientRequest.java:37) at com.google.api.client.googleapis.services.AbstractGoogleClientRequest$1.interceptResponse(AbstractGoogleClientRequest.java:428) at com.google.api.client.http.HttpRequest.execute(HttpRequest.java:1111) at com.google.api.client.googleapis.services.AbstractGoogleClientRequest.executeUnparsed(AbstractGoogleClientRequest.java:514) at com.google.api.client.googleapis.services.AbstractGoogleClientRequest.executeUnparsed(AbstractGoogleClientRequest.java:455) at com.google.api.client.googleapis.services.AbstractGoogleClientRequest.execute(AbstractGoogleClientRequest.java:565) at com.google.cloud.bigquery.spi.v2.HttpBigQueryRpc.create(HttpBigQueryRpc.java:185) ... 16 more 

Normalization also failed:

Database Error Access Denied: Project <redacted>: User does not have bigquery.datasets.create permission in project <redacted>.,retryable=<null>,timestamp=1663764411243 

Metadata

Metadata

Assignees

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions