# 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 u`pdated_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

<figure><img src="https://lh7-rt.googleusercontent.com/docsz/AD_4nXeDUrEH_u0WiEo_fZ6DcCzoYiXZlEZj4k9QOfrCtPQqT5UB62-0RJYAefspjwH4WahxLvSghRPfkLJYrb9HKfuAw-bzF8JHnWUbNdkttS8-gT0hcbF2Hm_CAtca6chdWLFChg0DFCx2FA7RkctPkHN9Kb8g?key=r4-SP2UwrmDnDPr8j8UBiA" alt="" width="375"><figcaption></figcaption></figure>

<figure><img src="https://lh7-rt.googleusercontent.com/docsz/AD_4nXdXqz1QWFwmaE8yd192QSB-vUxJJ5re1P1vYI8jwgMyf4Z9YB6JViwI3hMaEJPoHSg7KON2ZVdjPT4ICJCw9J40cOT-fJR-40HQearMQbZutWeAsZbLGddIkoj-xWEja3AfISk7EGnoT3ZBPF9nG4VNFCg?key=r4-SP2UwrmDnDPr8j8UBiA" alt="" width="375"><figcaption></figcaption></figure>

3. Click **Create and continue**.
4. In the **Grant this service account access to the project** section, add the following roles:

   a. BigQuery User

   b. BigQuery Data Editor<br>

   <figure><img src="https://lh7-rt.googleusercontent.com/docsz/AD_4nXdOi51QFOAMh3YNe45nucWTYhorz7eJo9toA0AEZLoTnuUpBXSp8m-6TJ-1GBarEh9mZAQehcLuEjHyUS20zGDKH5phB-gS1ioh_lfDgVsPSG0IrIM9g1mNAEiHITuWihI2Wu5KSl18XoBrxnZX3TldwNI?key=r4-SP2UwrmDnDPr8j8UBiA" alt="" width="375"><figcaption></figcaption></figure>
5. Click the **Continue** button.
6. Click the **Done** button.
7. Click on the **Actions** button next to your new service account and select **Manage Keys**.<br>

   <figure><img src="https://lh7-rt.googleusercontent.com/docsz/AD_4nXcgl9zttmhxuTo4g1U58LhUxigWdbLT4fWcuhXOI-dJce44q2MAS-XFPrBYzDu5KI3Yd337vbkCFaU-q-0MCXhsgZvPZuNjVxgKeMuy52Nyvb6dVsXxgJq0iaJJznapQEG51fm0nj_Kjh4RExWJi9UK54tx?key=r4-SP2UwrmDnDPr8j8UBiA" alt="" width="188"><figcaption></figcaption></figure>
8. Click on the **Add Key** button and select **Create new key**.

   <figure><img src="https://lh7-rt.googleusercontent.com/docsz/AD_4nXcl-_EKbUFAwaKxz28_DQyEaphusHBO2C1nP8EUlVnEHofoWKpwRrlRC-1lIc3SiBH2iWoc3B0hrCJ36sx62Jp3-olXKDahCHQoRuJooFdy52sl2Fg9Px-9aWErVJYSIm2qHdukMccRrIQOVfpnvyJr50cn?key=r4-SP2UwrmDnDPr8j8UBiA" alt="" width="375"><figcaption></figcaption></figure>
9. Choose the **JSON** type.

   <figure><img src="https://lh7-rt.googleusercontent.com/docsz/AD_4nXfb6CEC2-s6lbUV5MCAzIDbXR9qXN49g3xZup9xlu-WPRp_Pa0VYDgwdkHUMGKY4sC3lIX6AuJ4kO0i7B6fWaNmwZEhPX-uv-6LBLbo7Ws03NQHgQkEBmEu2LQorgWOb6iG52M0wm46zQaYbcBDnb0r5vZA?key=r4-SP2UwrmDnDPr8j8UBiA" alt="" width="375"><figcaption></figcaption></figure>
10. 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.

<figure><img src="/files/b3Jhj3oCyV49chCkdT7D" alt="" width="375"><figcaption></figcaption></figure>

<br>

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

<figure><img src="https://lh7-rt.googleusercontent.com/docsz/AD_4nXfj_pPw0x2vHaW4sxuvCuQS9wAkv3V_u7O_REkelIO4KqhzvslbC1hhjRpphy9zvCHzvzuRCshp9s1kItfBmLxcoQ5fSl31TBSoZVv61E5yjBYSchikN7ghApDW2ajEmHQuCjWiJKTrs12fgw_gpjBesFc?key=r4-SP2UwrmDnDPr8j8UBiA" alt="" width="375"><figcaption></figcaption></figure>

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

<figure><img src="https://lh7-rt.googleusercontent.com/docsz/AD_4nXclBIBxJdT9GPFoRoJY_TsYpAO6GAGxIIAU2cG9W71gLFMjYAMki8ouhesWcV4V0_Al6XdmSBDNk0uTj3PQrbK72-dvvO5Ld_DXKo53MLHORADXAAtf2ZExdSqK9-wR-IpGRCyVwI3M85aMxB8RTy7XB5go?key=r4-SP2UwrmDnDPr8j8UBiA" alt="" width="375"><figcaption></figcaption></figure>

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

<figure><img src="https://lh7-rt.googleusercontent.com/docsz/AD_4nXdTk6PqJbST_7ihQsbEx1jN2wyLTPjfc1Jurpmwf1vqqjoNzIEB_Npu80cK2mYRKcEELFWpD4PIVXGAsGZSdYvyjOidf01pxGRzzgqR5BIjYTN3BNFZNu_0mNcD2aP-dT7-p9-1q1Ed65uUkG1IFJ-povlz?key=r4-SP2UwrmDnDPr8j8UBiA" alt="" width="375"><figcaption></figcaption></figure>

5. 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.

<figure><img src="https://lh7-rt.googleusercontent.com/docsz/AD_4nXefsh-8aMObfgdaAW6zsnRApAWfywNTWISHhcYI-q6msaxGQoSR6TKgvCH7ZgwA36Ki-C9oPeGLyK1EEVYzPYfFKCPRK2ZvkdyFb7VQVOaR-VOielrqDrRF_EJFtJ1_OuRyZrkjqeISVefISaPX1RkW-MLM?key=r4-SP2UwrmDnDPr8j8UBiA" alt="" width="375"><figcaption></figcaption></figure>

6. 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.

<figure><img src="/files/yiJ0k9x9Bie20lxagjR4" alt="" width="375"><figcaption></figcaption></figure>

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

<figure><img src="https://lh7-rt.googleusercontent.com/docsz/AD_4nXf89oIfz73qdu9bIOKrC8mYJ3w6o7M2g5UjEwuA7vexKjW1k_3sdXw9i3oOmeOxvr44YTf5wSMcRyk01oocx-cRE2sbFhqzXRFvmNHBOIV4hJ_BEHju5TKXy80MHTEcEz3q50HVII8iOXu88VwkHdc0i9k?key=r4-SP2UwrmDnDPr8j8UBiA" alt="" width="375"><figcaption></figcaption></figure>

8. 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
9. 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.


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.bird.com/applications/integrations/integrations/supported-integrations/google-bigquery.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.