Ehy @leonaltstadt,
Try to convert your OAuth consent screen to “External” and set to “Production”: This ensures refresh tokens don’t auto-expire after a week.
As a last resort, use a Service Account for Google Cloud APIs—this avoids OAuth refresh issues for BigQuery