Set Up a Google BigQuery Data Federation Connection

Set up a connection between Google BigQuery and Data Cloud to access data.

Before you begin:

• If you use VPC Service Controls in Google Cloud, ask your GCP org admin to review Data Cloud IP Allowlist and Allow access to protected resources from outside a perimeter, and update your allowlists.
• Create a Google Cloud service account with these permissions. For more information, see Create service accounts.
  • BigQuery Metadata Viewer
  • BigQuery Job User
  • BigQuery Data Viewer
  • BigQuery Read Session User

1. In Data Cloud, go to Data Cloud Setup.

2. Under Configuration, select More Connectors.

3. Click New.

4. Under Source, select Google BigQuery and click Next.

5. Enter a connection name, connection API name.

6. Enter the authentication details.

   Upload the credentials JSON file or paste its contents.

7. Enter the Project ID.

8. To review your configuration, click Test Connection.

9. Click Save.

   To support large data sizes:

   • Enable bigquery.tables.create and bigquery.dataset.create permissions in Google BigQuery. You can either attach a predefined role that has these permissions or if there is a custom role attach these permissions to that role. For more information see, BigQuery predefined IAM roles.
   • In your Google BigQuery project, create a dataset with the name of sf_temp_dataset with an expiration time of six hours.
   • Select the Enable large-resultset flow checkbox on the create or edit connection page to support querying large result sets and to allowlist your org.