# Google BigQuery JSON permissions for site visitors

**URL:** <https://forum.wixstudio.com/t/google-bigquery-json-permissions-for-site-visitors/394>\
**Category:** Ask the community\
**Tags:** question, code, wix-members-area, wix-stores\
**Created:** [May 2, 2023, 1:44am UTC](https://forum.wixstudio.com/t/google-bigquery-json-permissions-for-site-visitors/394 "2023-05-02T01:44:06Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![wg-app](https://avatars.discourse-cdn.com/v4/letter/w/a6a055/32.png) [@wg-app](https://forum.wixstudio.com/u/wg-app)\
**Post date:** [May 2, 2023, 1:44am UTC](https://forum.wixstudio.com/t/google-bigquery-json-permissions-for-site-visitors/394/1 "2023-05-02T01:44:06Z")

</div>

I am leveraging Google BigQuery to store my site data. Everything is working as expected. I am to the point now where I want to be able to grant site visitors Read access to some of the data stored in Google BigQuery. At the moment my JSON permissions just covers “Admins” and “Members”. I’m curious: Is there a role I can list that will cover site visitors?

Example of my JSON:  
{  
“id”: “viewSTMParticipantData”,  
“read”: [“Admin”, “Member”],  
“write”: [“Admin”, “Member”]  
}

---

<div class="post-metadata">

**Author:** ![anthony](https://sea1.discourse-cdn.com/wix/user_avatar/forum.wixstudio.com/anthony/32/79536_2.png) [@anthony](https://forum.wixstudio.com/u/anthony)\
**Post date:** [May 2, 2023, 2:10pm UTC](https://forum.wixstudio.com/t/google-bigquery-json-permissions-for-site-visitors/394/2 "2023-05-02T14:10:22Z")

</div>

Per this section of the GCP article it sounds like “Visitor” may work for your case: [https://support.wix.com/en/article/integrate-your-google-cloud-bigquery-database-with-your-wix-site#set-up-secrets](https://support.wix.com/en/article/integrate-your-google-cloud-bigquery-database-with-your-wix-site#set-up-secrets)

---

<div class="post-metadata">

**Author:** ![wg-app](https://avatars.discourse-cdn.com/v4/letter/w/a6a055/32.png) [@wg-app](https://forum.wixstudio.com/u/wg-app)\
**Post date:** [May 3, 2023, 2:08am UTC](https://forum.wixstudio.com/t/google-bigquery-json-permissions-for-site-visitors/394/3 "2023-05-03T02:08:11Z")

</div>

Ugh, you are so right. I completely missed that somehow. Thank you!