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:

  1. Set the Windsor app as a Trusted App and then exempt Trusted Apps from reauthentication https://support.google.com/a/answer/7281227?hl=en.
  2. 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

Access all your data from various sources in one place. Get started for free with a 30-day trial.
g logo
fb logo
big query data
youtube logo
power logo
looker logo