Google OAuth for BigQuery stops working after few hours

There are two very good articles in the knowledge base that explain a lot about configuring Google OAuth and the same principle can be used when configuring OAuth for BigQuery connector. Initially, everything works well, but it looks like the refresh token stops working after a few hours, and we can’t figure out why. The only difference is that we want to use an internal user account.

Another big mystery for us is redirect URI. If oauthplayground is for development purposes only, which one should be used for production, especially in this case when we are using BigQuery connector with Are we missing something obvious?

We would already switch to a service account with a key but looks like that is not possible with a current BigQuery connector.

1 Like

This topic was automatically closed 180 days after the last reply. New replies are no longer allowed.