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

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

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

Here's how you can get these details:

First Option:

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. Typically, the roles you might need include "BigQuery Data Viewer" and "BigQuery Job User."

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. Extract Required Fields:

   • 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

5. Fill in the Integration Form:

Copy each corresponding value from the JSON file and paste it into the integration form fields in Churned.

Second Option

Grant IAM Service Account Access For the full Google documentation on creating IAM service accounts, see: Google IAM Service Accounts Documentation.

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: [e-mail]

   • Assign the right roles:

     • BigQuery User

     • BigQuery Job User

5. Hit SAVE.

Grant Access to View BigQuery Tables Repeat steps for granting IAM service account access with these modifications:

Steps:

1. Repeat steps 1-3 from above.

2. In step 4, enter the following details:

   • New principals: [e-mail]

   • Assign the right roles:

     • BigQuery User

     • BigQuery Job User

3. Hit SAVE.