BYOV: Google BigQuery

To set up your Google BigQuery BYOV account on your 5X workspace, navigate to the Data Warehouse category in Integrations. Click Bring my own account from Add vendor on the Google BigQuery tile to configure the setup.

Prerequisites

  • The user must have a service account key with a Service Account Key Admin IAM role enabled on the project.

Setup BigQuery Service Account and Key

Users must create a BigQuery Service Account to import their BYOV BigQuery account into the 5X platform.

To create a service account on your BigQuery account, refer to the steps below:

  1. Select the BigQuery project where you want to create your service account and navigate to Service Accounts from the IAM & Admin section on the left navigation bar.

  2. Click on + CREATE SERVICE ACCOUNT to configure the account details.

  3. Enter the required service account details and click CREATE AND CONTINUE.

We recommend you name the service account with a 5X indication for easy access and management, like fivex_master_account. To ensure the service account is not deleted when multiple stakeholders are managing a project, you can put DO_NOT_DELETE as an indicator under the service account description. Deleting a BigQuery service account used by 5X may have implications for your 5X workspace and BigQuery projects.

  1. Enable role access permissions for the service account. 5X requires users to grant minimum role privileges for 5X to set up the BYOV integration. Select roles for:

  • Project IAM Admin,

  • BigQuery Admin, using which 5X can access and manage operations from the workspace directly.

  • Service Account Admin, using which 5X can create additional service account admins based on ad-hoc requirements such as when connecting your BigQuery project with a data ingestion vendor, and

  • Service Account Key Admin.

You have successfully created your service account on the required BigQuery project. The next step is configuring the service account key, which 5X can access the account credentials.

  1. To set up your service account key, navigate to KEYS from the account. Click Create new key from the ADD KEY dropdown. Select the JSON key type and CREATE.

Once the key is created, you can use and check its values on your editor.

  1. API and services access requirements: To enable the required access, navigate to Enabled APIs & services from API & Services on the navigation tab. Enable the BigQuery API, Cloud Resource Manager API, Identity and Access Management (IAM) API, and IAM Service Account Credentials API.

Configure BigQuery BYOV

Users must configure and test source details to complete the BYOV vendor setup. The setup guide mentions the prerequisites, account roles, and required actions needed for the configuration.

  1. Configure your BigQuery source details and Continue. Upload your Service Account Key and select the project ID for 5X to access the BigQuery project.

  2. 5X tests and validates the Service Account key to connect to the BigQuery account. Once the connection testing is successful, Continue.

Click Done once 5X finishes setting up your Snowflake integration. For the next steps, enable vendor permission and activate Snowflake on 5X.

Last updated