How to fix the error “Reauthentication is needed” when sending data to BigQuery
Error overview
You might encounter this error when working with BigQuery destination tasks on Windsor onboard
Reauthentication is needed.
This error is caused by the expiration of the OAuth token you provided when adding/editing your BigQuery destination task(s). Specifically, this issue occurs when the session length configured in your Google Workspace admin console expires. Once the session ends, the authenticating user’s OAuth token becomes invalid, causing authentication failures and the error message above.
Troubleshooting steps
To resolve this error, your Google Workspace administrator needs to adjust the Reauthentication policy settings to extend the session length for Google Cloud services.
Visit https://support.google.com/a/answer/9368756 for more details.
There are two options to mitigate it:
- Set the Windsor app as a Trusted App and then exempt Trusted Apps from reauthentication https://support.google.com/a/answer/7281227?hl=en.
- Change settings to ‘Never require reauthentication for any app.’
Once you have changed your settings in Google Admin, please reconnect your Google account in the affected destination tasks.
If the issue persists, contact our customer support for further assistance.
Tired of juggling fragmented data? Try Windsor.ai today to create a single source of truth
