Go to All Forums

Connecting to BigQuery RestAPI via Rest API Transaction and OAuth

by miro

I'm trying to access biquery tables via BigQuery cloud.google.com/bigquery/docs/reference/rest/v2/, where the authentication should be viaOAuth. I thought that 'Rest API Transaction' would be a way to go, so I have created an OAuth provider with scope,..etc. I think that I have manage to authorise the provider against my GCP (Google Cloud Platform). 

What is strange is, that refresh token is empty and that 'access token expiration time' is the time when I have initially authorised the OAuth provider.

Another problem I can see that the monitoring job has 'The request requires user authentication. ' error.

 

Please, do you have an idea about what I'm doing wrong? 

Like (1) Reply
Replies (1)

Re: Connecting to BigQuery RestAPI via Rest API Transaction and OAuth

Hello,

The first step is to get the OAuth Provider configured correctly. Some providers may not use refresh tokens, but in your case GCP should show a refresh token and access token expiry time when configured correctly.

Please contact support so they can assist you with setting up the OAuth Provider.

Regards,

Kurian

Like (0) Reply

Was this post helpful?