I am currently trying to connect a BigQuery database to my Wix page. The external datasets showed up as expected, and I was able to query them via code in preview mode. However, when I try to visit the live site, I get a 500 Error. I made sure to set the permissions correctly like this:
"read": ["Admin", "Member", "Visitor"],
"write": ["Admin"]
The adapter interface (running on Cloud Run) confirms that everything is set up correctly. However, Cloud Run logs display the following error:
UnauthorizedError: You are not authorized at RoleAuthorizationService.authorizeRead (/usr/lib/app/main.js:8637:19)
I was unable to find any relevant information besides one post from another user. I also attempted to run the query in the backend with and without the elevate() function but ended up with the same results.
Any help would be appreciated!