Search code examples
google-cloud-platformgoogle-bigquery

Bigquery service account restricted to a dataset


Is it possible to create a bigquery service account to limit access to only 1 dataset? When I go through the service account generation process it appears to give access to an entire project and does not show options to limit to a specific data set.


Solution

  • Short answer is yes. But to do it you do not assign the privileges at the project level. You need to actually go and modify the dataset to do it. Check the documentation here: https://cloud.google.com/bigquery/docs/dataset-access-controls

    It outlines the process with a few different methods.