Skip to main content

BigQuery

Setup Guide​

Step 1 - Find Your Project ID​

Locate your Google Cloud Project ID, as you'll need it to configure the destination.

Step 2 - Grant Service Account Permissions​

  1. Open the IAM settings of the Google Cloud Project that contains your BigQuery database: https://console.cloud.google.com/iam-admin/iam

  2. Click on "Grant Access" and provide access to our service account

  3. Principal: singular-etl@singular-etl.iam.gserviceaccount.com

  4. Assigned Roles:

    1. "BigQuery Data Editor" (bigquery.dataEditor) role, which includes:

      • Creating and managing datasets
      • Creating, updating, and deleting tables
      • Reading and writing data to tables
      • Running queries

    2. "BigQuery Job User" (bigquery.jobUser) role, which includes:

      • Creating and managing BigQuery jobs
      • Running load operations
      • Creating and managing query jobs

    3. Alternatively, you can assign these specific permissions:

      • bigquery.datasets.get
      • bigquery.datasets.create
      • bigquery.tables.get
      • bigquery.tables.create
      • bigquery.tables.update
      • bigquery.tables.delete
      • bigquery.tables.getData
      • bigquery.jobs.create
      • bigquery.jobs.get

BigQuery IAM Permissions

Step 3 (Optional) - Use Your Own Service Account​

If you prefer to use your own service account instead of the Extract service account, follow Google's documentation on creating a service account key to set up service account key authentication.

info

After creating your own service account, make sure you grant it all the permissions from Step 2 in the project that contains your BigQuery database.

Step 4 - Complete the Setup​

Enter your Project ID and, if using your own service account, provide the Service Account Key to finalize the setup.