I created a zap which reads data from Google BigQuery. The BigQuery connector is requiring me to re-authenticate every day (it seems to last 12hrs) otherwise the zap fails. It’s not sustainable for me to authenticate every day. Is there a way to change the authentication expiration?
Question
Frequent BigQuery Authentication
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.
+11- Community Manager
Hi
Sorry to hear of the troubles with Google BigQuery here! I found a bug report for a similar issue where the Google BigQuery account connection expires if the Google account isn’t logged into for a while. But the bug report doesn’t mention that the account expires every 12 hours so I’m not 100% certain that this is the same bug that’s affecting you here. Have you logged into your Google BigQuery account recently - separately from logging in to reconnect the account via Zapier?
If not can you try logging in and confirm whether that then allows the connection to persist for longer than 12 hours?
If you’ve logged in recently but it still expires then it’s likely a different issue. Looking at Google BigQuery’s API documentation it states the following possible reasons for token expiry:
A refresh token might stop working for one of these reasons:
- The user has revoked your app's access.
- The refresh token has not been used for six months.
- The user changed passwords and the refresh token contains Gmail scopes.
- The user account has exceeded a maximum number of granted (live) refresh tokens.
- If an admin set any of the services requested in your app's scopes to Restricted (the error is
admin_policy_enforced).- For Google Cloud Platform APIs - the session length set by the admin could have been exceeded.
Do you just have one Zap that’s using the connection to Google BigQuery or are there multiple Zaps using the same connection? You can verify this by checking the number of Zaps using the connection from the Apps page in your Zapier account.
If there’s only one Zap connected, do you think any of the above reasons might be behind the frequent expiration of the authentication token? If not, I’d recommend reaching out to our Support team as they’ll be able to investigate the authentication logs for the Zap to better determine what the cause of the issue is. You can get in touch with them here: https://zapier.com/app/get-help
Looking forward to hearing from you!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.