I’m trying to create a new data source in Quick, but I’ve been running into some issues and could use your help.
I successfully connected to BigQuery and was able to create a dataset based on this data source. However, after a few days, when I returned to the dataset and tried to update the query, I received the error message: “Your OAuth token has expired.”
I attempted to refresh/update the data source, but the same error keeps appearing. After that, the dataset stopped refreshing properly.
Has anyone experienced this issue before or knows how to resolve it?
Hello @david.oliveira, there are a few different routes you can try to resolve this.
You can try to delete the initial data source and retry the whole authorization flow. I’d imagine you will probably hit the same error, but it might be worth a try.
Go through the Google Cloud account security settings and see if you can fix authorization from Google.
Create a service account in the Google Cloud Console linked to BigQuery and use that as your Quick data source instead. This might bypass the error you are seeing.
Another alternative that might be a little annoying would be to use AWS AppFlow and create a Pipeline to ingest the BigQuery data into something like S3. Then using Athena, create a data source directly in Amazon that will connect more easily with AWS.
Hopefully we can resolve the issue without some big work-around, but these are some of the things I was thinking of to fix this.
Just checking back in since we haven’t heard from you in a bit. I wanted to see if the guidance shared earlier helped resolve your question, or if you found a solution in the meantime.
If you still have any additional questions related to your initial post, feel free to share them. Otherwise, any update you’re able to provide within the next 3 business days would be helpful for the community.
Since I haven’t received any further updates from you, I’ll treat this inquiry as complete for now. If you have any additional questions, feel free to create a new post in the community and link this discussion for context.
