Assign access control to a BigQuery Dataset.

0 votes
What's the mechanism for controlling access to a dataset? Can I configure access controls at the time of creation of dataset itself?
Nov 15, 2019 in GCP by anonymous
• 5,840 points
269 views

1 answer to this question.

0 votes

You can apply access controls during dataset creation by calling the datasets.insert API method.

Access controls cannot be applied during dataset creation in the GCP Console, the classic BigQuery web UI, or the command-line tool.

To assign access controls to a dataset using the console:

  1. Select a dataset from Resources, then click Share dataset near the right side of the window.

  2. In the Share dataset panel, in the Dataset permissions tab, click Add members.

  3. In the Add members panel, enter the entity you want to add into the New members text box. You can add any of the following entities:

    • Google account e-mail: Grants an individual Google account access to the dataset

    • Google Group: Grants all members of a Google group access to the dataset

    • Google Apps Domain: Grants all users and groups in a Google domain access to the dataset

    • Service account: Grants a service account access to the dataset

    • Anybody: Enter "allUsers" to grant access to the general public

    • All Google accounts: Enter "allAuthenticatedUsers" to grant access to any user signed in to a Google Account

  4. For Select a role, select BigQuery and choose an appropriate pre-defined IAM role for the new members.

  5. Click Done.

answered Nov 15, 2019 by Sirajul
• 54,020 points

Related Questions In GCP

0 votes
1 answer
0 votes
1 answer
0 votes
1 answer

Can I give a user access to cloud storage who doesn't have a GCP account?

Yes, you could certainly do this.  You can ...READ MORE

answered Nov 5, 2019 in GCP by Sirajul
• 54,020 points
134 views
0 votes
1 answer

How do I create a BigQuery Dataset using the console?

To create a dataset: Open the BigQuery web ...READ MORE

answered Nov 15, 2019 in GCP by anonymous
• 54,020 points
65 views
0 votes
1 answer

Permissions required to update a dataset.

At a minimum, to update dataset properties, ...READ MORE

answered Nov 15, 2019 in GCP by Sirajul
• 54,020 points
141 views
0 votes
1 answer

Change default expiration time for a dataset.

You can update a dataset's default table ...READ MORE

answered Nov 15, 2019 in GCP by Sirajul
• 54,020 points
103 views
0 votes
1 answer

Using a JSON Schema file in BigQuery for creating a Schema.

After creating your JSON schema file, you ...READ MORE

answered Nov 15, 2019 in GCP by Sirajul
• 54,020 points
1,064 views
0 votes
1 answer

How can i grant access to a GCP project for a large scale multiple users at once?

gcloud auth to service accounts is allowed. ...READ MORE

answered Oct 16, 2019 in GCP by Sirajul
• 54,020 points
195 views