Unify and manage your data

Configure your GCP service account for BigQuery access

Learn how to create a GCP service account, assign the required permissions, and generate a service account key so that Reltio can write data to your BigQuery dataset.

Before you begin, confirm that the following requirements are met.

  • Your GCP project has BigQuery enabled.
  • Your Google account has the Owner or IAM Admin role on the GCP project, which is required to create service accounts, create custom IAM roles, and modify dataset permissions.
  • You have already created the Reltio GBQ connector Project Level custom IAM role with the required project-level permissions.
  • You have already created a BigQuery dataset in your GCP project.

Setting up your service account involves four steps:

  1. Create a GCP service account
  2. Assign project-level permissions to your service account
  3. Assign dataset-level permissions to your service account
  4. Generate a service account key
Create a GCP service account
  1. In the Google Cloud console, open the navigation menu.
  2. Select IAM & Admin, and then select Service Accounts.
  3. Select + CREATE SERVICE ACCOUNT.
  4. In the Service account name field, enter a name that identifies the account's purpose, for example, reltio-gbq-connector.

    The Service account ID field auto-generates from the name, edit the ID if needed.

  5. In the Service account description field, enter a brief description, for example, Service account for Reltio GBQ data pipeline.
  6. Select CREATE AND CONTINUE.
  7. Skip the optional role and user access sections for now.

    In Assign project-level permissions to your service account, you assign the Reltio GBQ connector Project Level role and the BigQuery Data Owner role to the service account.

  8. Select DONE.

    The service account appears in the Service Accounts list.

Assign project-level permissions to your service account
  1. In the Google Cloud console, open the navigation menu.
  2. Select IAM & Admin, and then select IAM.
  3. In the PERMISSIONS tab, select GRANT ACCESS.
  4. In the Grant access panel, provide the following details.
    1. In the New principals field, enter the email address of your service account.
    2. In the Select a role drop-down list, select the Reltio GBQ connector Project Level custom role. This role includes the following permissions that allow Reltio to write data to your GCP project.
      PermissionPurpose
      serviceusage.services.useAllows Reltio to use enabled GCP services in the project
      bigquery.jobs.createAllows Reltio to create BigQuery jobs to process and stream data
      bigquery.jobs.getAllows Reltio to retrieve the status of BigQuery jobs
  5. Select Save.
Assign dataset-level permissions to your service account
  1. In the Google Cloud console, open BigQuery.
  2. In the Explorer panel, expand your project and select the dataset you created.
  3. Select SHARING, and then select Permissions from the drop-down list.
  4. In the Dataset Permissions panel, select ADD PRINCIPAL.
  5. In the Grant access panel, provide the following details.
    1. In the New principals field, enter the email address of your service account.
    2. In the Select a role drop-down list, select BigQuery Data Owner.
  6. Select Save.
Generate a service account key

You generate a JSON key file in this procedure. Upload it when configuring the GBQ pipeline in the Reltio Console.

  1. In the Google Cloud console, open the navigation menu.
  2. Select IAM & Admin, and then select Service Accounts.
  3. In the Service Accounts list, select the service account you created.
  4. Select the KEYS tab.
  5. Select ADD KEY.
    The JSON key file downloads to your computer automatically.
    Important: Store the JSON key file securely as the Google Cloud console does not allow you to download it again. Upload it while configuring the GBQ pipeline in the Reltio Console. Do not share it in or commit it to version control. If the key is compromised, delete it immediately from the KEYS tab and generate a replacement.

Your GCP service account is now ready for Reltio to use. It has the project-level and dataset-level permissions needed to stream data into your BigQuery dataset. Use the downloaded key file to configure a new GBQ pipeline in the Reltio Console.