External Database Authorization Error

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!

Hi @f-pitterling, hope all is well.

I could run wixData operations like query, by suppressing the permission etc:

let options = {
  "suppressAuth": true,
  "suppressHooks": true
}

Although, not sure how to run it without the options parameter, like their example at the bottom of the page.

Best,