Getting 401 error for few users when querying data form big query

💬 Queries and Resources
, ,
1

I’m currently trying to debug an issue in Retool where the error message isn’t very clear. Some of our internal users are unable to view one of our client’s projects, while others can access it without any problem.

We query project data through BigQuery and display it in a table based on the client organization. The issue appears to affect only a few users within this specific org. I’ve tested fetching the projects in my own Retool account, and it works as expected. We also reviewed the Retool permissions for the affected users, and everything appears to be configured correctly. We tried removing the affected users and adding them again to see if permissions refresh but nothing changed

In the affected users’ accounts, we’re seeing a 401 error (screenshot attached below). Since the query and code seem fine, it’s been challenging to identify the root cause. Could you please assist with troubleshooting or suggest how we can further investigate and resolve this?

1error (1)

3

Hi @Aditya_Sharma,

This sounds like a permissions issue with the specific users.

Can you share a screenshot of the permissions for the user to show that they do have all permissions for the BigQuery query that is being used?

Is there any auth configuration on the Google/BigQuery side of the API that might be returning the 401 error because the requests is coming from an unauthorized request source/user?