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
• 4,880 points
44 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
• 44,350 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
• 44,350 points
47 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
• 44,350 points
34 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
• 44,350 points
51 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
• 44,350 points
42 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
• 44,350 points
133 views
0 votes
1 answer