In this article, we explain which IAM roles and permissions you need in Google BigQuery to access and view projects when querying data in Dataslayer.
When you begin working with BigQuery at Dataslayer, it’s essential to understand that accessing and viewing a project in Dataslayer for BigQuery requires specific IAM (Identity and Access Management) roles or permissions, which must be assigned to you by your client.
The exact roles and permissions you need will depend on the tasks you intend to perform in BigQuery. Below are some commonly used roles along with their respective permissions:
-
Viewer
This role is enough if you only need to view the project, datasets, and tables without running queries.
-
User
This role is suitable if you need to run queries or access job data. It also grants the permissions of the Viewer role.
-
Editor
If you need to create, update, or delete tables or views, this role would be needed in addition to the User role.
-
Owner
This provides the most comprehensive access, allowing you to manage datasets and control sharing, on top of the permissions in the Editor role.
You would typically need at least the Viewer role to see the project and its datasets.
However, in Dataslayer, if you need to perform more advanced actions like running queries or managing datasets and tables, you would need higher permissions like the User, Editor, or Owner roles.
For more detailed information about the various role types and their specific permissions, please refer to the BigQuery documentation on Basic Roles and Permissions and BigQuery IAM roles and permissions.
As always, please contact us via our live chat on our website or via email if you still have doubts or questions. We are happy to help!