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?