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.