Google BigQuery

Google BigQuery is a fully managed, serverless data warehouse designed for fast SQL queries and data analysis. Its scalable and high-performance architecture allows users to process large datasets efficiently, making it ideal for data analytics and business intelligence applications.

What you can do with the Google BigQuery:

• Ingest contact data: Ingest contact data and its properties from BigQuery into Bird to segment and activate campaigns and other updates to your customers on popular channels such as Email, SMS, and WhatsApp.

To install the BigQuery integration, you'll need:

• The Project ID of a Google Cloud Project with BigQuery enabled.

• A Google Cloud Service Account Key JSON file. The Service Account must have the BigQuery User and BigQuery Data Editor roles in your GCP project.

• The BigQuery table name.

• A cursor field (the name of a field in the table that can be used to track the latest changes for incremental syncing. A common example would be updated_at).

How to create a service account

Prerequisites:

• Ensure that the `iam.disableServiceAccountKeyCreation` organization policy constraint isn't enforced for your project.

• You must be granted the `roles/iam.serviceAccountKeyAdmin` IAM role (if you don’t have this role, ask your administrator for it).

Steps:

1. In the Google Cloud Console, navigate to the IAM & Admin section. Then click on Service Accounts.

2. Click the + CREATE SERVICE ACCOUNT button at the top. Fill in the following details:

   a. Service account name

   b. Service account ID

   c. Service account description

1. Click Create and continue.

2. In the Grant this service account access to the project section, add the following roles:

   a. BigQuery User

   b. BigQuery Data Editor

   
3. Click the Continue button.

4. Click the Done button.

5. Click on the Actions button next to your new service account and select Manage Keys.

   
6. Click on the Add Key button and select Create new key.

   
7. Choose the JSON type.

   
8. Click the Create button.

Your browser will download the service account key file. Keep this file, as you will need it to install the BigQuery integration in the next step.

Install the integration in Bird

1. Navigate to Manage Integrations and search for the BigQuery.

1. Enter Name, Project ID, Dataset ID, Table name, Cursor field and Service Account key and click Install.

1. Once installed, navigate to the dataflows section under the Process Automation section of the product and create a new dataflow.

1. Give your name, select Source = BigQuery installed in #2, and Destination = Workspace contacts, click on Create, and continue.

1. Next, under transformation, go to Attribute mapping, select Add mapping, and pick and choose the source attributes from BigQuery that must be ingested along with the mapping to destination attribute in Bird.

1. After completing the attribute mapping, proceed to the next step by clicking Continue to destination and map the identifiers like email address and phone number coming from BigQuery into Bird contact identifiers.

1. Once the identifiers are mapped, click on Save data flow, and then you can change the schedule or view the configuration of the dataflow.

1. You can modify the schedule by clicking on Change schedule, and it can be configured to run every few hours or minutes by entering the value in the following format. For example, for every 12hrs, you have to input @every 12h and for every 30mins, please input @every 30m

2. Now, you can enable the dataflow to ingest the contact data from BigQuery into Bird as contacts.

FAQs

I don’t see the Manage Integrations option. What am I missing?

Please verify your Access role under 'Organization Settings'. If it's not present there, contact your admin for assistance.

As a Google BigQuery admin with multiple BigQuery Tables, can I connect each one to Bird?

Absolutely! Install the BigQuery for each table as required. After installation, view all the tables under Integrations. Remember, each installation is unique to one table, so you must install it for each table individually.

What should I do if my Data sync displays a "Failed" status?

Please contact our support team for assistance.

Is it possible to restore a deleted integration?

No, once you delete an integration, it's irreversible. However, you can always create a new integration to replace the one you deleted.

What should I do if I notice errors in the Health status of my integration?

It is crucial to address any errors promptly. If you can't resolve the integration errors, our dedicated support team is here to help.

What happens with my audiences if my integration becomes defunct or is deleted?

Your audience will still function but won't receive new updates.