BigQuery

BigQuery is a serverless data warehouse from Google Cloud that allows fast, SQL-based analysis across large datasets, supporting real-time insights and integration with Google services.

Churned seamlessly integrates with BigQuery as a destination connection. If you already use BigQuery, we highly recommend connecting to it, as it is the fastest way to experience the full value Churned has to offer. This integration ensures real-time data synchronization and enhances your ability to engage with customers effectively.

How to connect BigQuery to Churned.io

1. Login to Churned platform and go to integration part. Click on "New Integration" and add BigQuery:

1. After adding BigQuery, you will need many information as you can see in this image:

Here's how you can get these details:

1. Create a Service Account:

   • Go to the Google Cloud Console.

   • Navigate to the IAM & Admin section, then select Service Accounts.

   • Click on "Create Service Account."

   • Fill in the necessary details, and then proceed.

2. Assign Roles:

   • Assign roles to your service account that grant it the necessary permissions to access BigQuery. Include "BigQuery Data Viewer", "BigQuery Job User" and "BigQuery Read Session User". All are required and will allow us to synchronize data.

3. Create and Download a Key:

   • After creating the service account, click on it, and go to the "Keys" section.

   • Click on "Add Key" and select "Create New Key."

   • Choose JSON format and click "Create." This will download a JSON file containing the credentials.

4. Share credentials

Option A: Upload JSON file directly in the integration form:

Option B: Extract Required Fields and fill in the integration form:

• Open the downloaded JSON file in a text editor.

• The JSON file contains all the required fields for the integration form:

- auth_provider_x509_cert_url

- auth_uri

- client_email

- client_id

- client_x509_cert_url

- private_key

- private_key_id

- project_id

- token_uri

1. Lastly, grant access for [email protected] to View BigQuery Tables

Steps:

1. In the Google Cloud Console, navigate to the correct project.

2. Click on the hamburger menu and select IAM & Admin → IAM.

3. Click on + GRANT ACCESS.

4. Enter the following details:

   • New principals: [email protected]

   • Assign the right roles:

     • BigQuery User

     • BigQuery Job User

5. Hit SAVE.