How to Solve the Access Denies for Google BigQuery

Hi, GCP community members. I am a Data Analyst in an e-commerce corporation in South Korea.

In an attempt to provide SQL/BigQuery education to our team members, we tried to grant some limited authorities of use(BigQuery user authority) for the BigQuery database and tables to the team members so that they can write and print out some SQL queries through BigQuery but cannot revise the tables and scheduled query. However, as long as we granted the authorities to about twenty people simultaneously, I believe that GCP detected it as some inappropriate approach or hacking attempt. Even though it is shown that they have 17 to 24 authorities of use, their accesses to our company database tables are denied. It seems that GCP blocked the access. 

Can anyone help us with this problem? Due to the reason above, we cannot move on to the next step of our education.

Thank you! 🙂

0 0 398
0 REPLIES 0
Top Labels in this Space