Churned
  • 👋Welcome to Churned!
    • Onboarding
  • ℹ️Metrics & definitions
    • Metrics
      • Customer Succes for SaaS
      • Customer Success for non-subscription
      • Customer Success for NGOs
        • NGO Resources
      • Customer Success for B2C
      • FAQ
    • Definitions
  • ☎️Churned Dashboard Help
    • Dashboards
      • Home Dashboard
        • Subscriptions
        • NGO's
      • Segments Page
        • Users Page
      • CSM Page
      • Customer Page
        • Donors page
        • Customer Subscription
      • Technical Dashboard
      • Impact Dashboard
      • A/B Testing
      • Task
        • Open Task
        • Task Rules
    • FAQ
  • 📃RFV/RFM - Model
    • RFV-Model Segment - Best Practices
      • RFM-Model
      • B2B SaaS
      • B2C Digital Subscription
      • NGO's
  • 🔌Integrations
    • ⚡Marketplaces
      • HubSpot
      • Segment
      • Mailchimp
      • Databricks
      • BigQuery
      • Google Analytics
      • Salesforce
      • Zendesk
      • ActiveCampaign
      • Klaviyo
      • Zoho
      • Mixpanel
      • Stripe
    • FAQ
  • 📈Product Updates
    • 🗒️Release Notes
    • Product Roadmap
  • 📍Extra
    • Webinars & Events
    • User Roles & Permissions
    • Add-ons
  • 🔐Security
    • GDPR compliance
    • Two-Factor Authentication (2FA)
Powered by GitBook
On this page
  • How to connect BigQuery to Churned.io
  • First Option:
  • Second Option

Was this helpful?

  1. Integrations
  2. Marketplaces

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.

PreviousDatabricksNextGoogle Analytics

Last updated 9 months ago

Was this helpful?

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

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: applications-churned-io@qntq-admin.iam.gserviceaccount.com

    • 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: applications@churned.io

    • Assign the right roles:

      • BigQuery User

      • BigQuery Job User

  3. Hit SAVE.

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

Google IAM Service Accounts Documentation
🔌
⚡
Page cover image