Allowing Partner Company Access to BigQuery Dataset | SEO Guide

Provide Access to BigQuery Dataset

Question

You are running a data warehouse on BigQuery.

A partner company is offering a recommendation engine based on the data in your data warehouse.

The partner company is also running their application on Google Cloud.

They manage the resources in their own project, but they need access to the BigQuery dataset in your project.

You want to provide the partner company with access to the dataset.

What should you do?

Answers

Explanations

Click on the arrows to vote for the correct answer

A. B. C. D.

D.

In order to provide the partner company with access to the BigQuery dataset in your project, you should follow these steps:

  1. Create a Service Account: You need to create a Service Account in your own project, which will be used to grant access to the BigQuery dataset to the partner company. You can create a Service Account from the IAM & admin section of the Google Cloud Console.

  2. Grant BigQuery Access: Grant the Service Account access to the BigQuery dataset in your project. This can be done by adding the Service Account to the appropriate IAM roles for the dataset.

  3. Share Service Account: Share the Service Account with the partner company. You can do this by providing them with the Service Account's email address, which they will use to authenticate with the BigQuery API.

  4. Grant Access to Partner Company: The partner company should then create a Service Account in their own project and grant this Service Account access to the BigQuery dataset in your project. This can be done by adding the Service Account to the appropriate IAM roles for the dataset.

Option A, creating a Service Account in your own project and granting access to BigQuery in your project, is partially correct. However, it does not address the partner company's need for access to the dataset.

Option B, creating a Service Account in your own project and asking the partner to grant access to BigQuery in their project, is incorrect because the partner does not have access to your project.

Option C, asking the partner to create a Service Account in their project and giving it access to BigQuery in their project, is incorrect because it does not grant access to your dataset.

Option D, asking the partner to create a Service Account in their project and granting it access to the BigQuery dataset in your project, is incorrect because you should create the Service Account in your own project and grant access to the dataset yourself.