Hi,
My queries for the data store Anonymous users ...
# announcementsv
victorious-library-28522
07/30/2023, 3:39 PMHi,
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 PMPerhaps you have table level permissions? Which data warehouse are you trying to connect to?
v
victorious-library-28522
07/30/2023, 3:43 PMBig Query
w
white-fireman-22476
07/30/2023, 3:43 PMYou 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 PMI have configured dataset level permission
w
white-fireman-22476
07/30/2023, 3:44 PMWithin 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 PMI 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 PMDoes the service account have big query metadata viewer permissions?
white-fireman-22476
07/30/2023, 3:52 PMAlso needs big query jobs user and big query data viewer permissions
v
victorious-library-28522
07/30/2023, 3:53 PMit 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 PMYes
white-fireman-22476
07/30/2023, 3:54 PMFor the Schema viewer certainly and perhaps the cause of the experiment page also being broken
v
victorious-library-28522
07/30/2023, 3:55 PMokay will try by adding it as well. Thanks
👍 1
73 Views