https://www.growthbook.io/ logo
v

victorious-library-28522

07/30/2023, 3:39 PM
Hi, My queries for the data store Anonymous users are working fine but I get “Access Denied error” in the experiment queries. Can anyone help?
w

white-fireman-22476

07/30/2023, 3:42 PM
Perhaps you have table level permissions? Which data warehouse are you trying to connect to?
v

victorious-library-28522

07/30/2023, 3:43 PM
Big Query
w

white-fireman-22476

07/30/2023, 3:43 PM
You should be able to click and see the queries that were run on the experiment and see which tables they access
v

victorious-library-28522

07/30/2023, 3:43 PM
I have configured dataset level permission
w

white-fireman-22476

07/30/2023, 3:44 PM
Within big query you can go to each table and check their permissions with the growthbook service account
v

victorious-library-28522

07/30/2023, 3:48 PM
I have confirmed the dataset level permissions. And the anonymous users queries are working fine. However, I am getting this error in Schema browser
w

white-fireman-22476

07/30/2023, 3:51 PM
Does the service account have big query metadata viewer permissions?
Also needs big query jobs user and big query data viewer permissions
v

victorious-library-28522

07/30/2023, 3:53 PM
it does have big query data viewer and big query job user. Is big query meta data also necessary ?
w

white-fireman-22476

07/30/2023, 3:53 PM
Yes
For the Schema viewer certainly and perhaps the cause of the experiment page also being broken
v

victorious-library-28522

07/30/2023, 3:55 PM
okay will try by adding it as well. Thanks
👍 1