From the course: Advanced BigQuery
Join today to access over 25,300 courses taught by industry experts.
Permissions on BigQuery tables - BigQuery Tutorial
From the course: Advanced BigQuery
Permissions on BigQuery tables
- Previously, we granted the BigQuery Data Viewer permissions, to a non-admin user in our project. And this was done at the level of a dataset. This viewer can take a look at the tables and its overall information and can also preview its contents. However, does the user have the ability to query the tables? When we pull up a new editor and then attempt to run a rather simple query on one of the tables in the dataset to which this user has access. Let's just say a simple select star query. When we attempt to run this you'll observe that there is an additional permission that is the ability to create jobs which this user requires. This is separate from any permission which is assigned at the BigQuery level. And in order to allow this user to execute queries we'll need to head back to the admin user and over to IAM. Beyond the browser level permission at the project level, let's edit this user and then add in a…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.