https://leadsbridge.com/wp-content/themes/leadsbridge/img/integration-lg-logos/logo970.png
How to connect Google BigQuery with LeadsBridge
Google BigQuery
Documentation

Integrate Google BigQuery with LeadsBridge

logo970

In this article, you'll learn how to connect your LeadsBridge account with Google BigQuery.

Connect Google BigQuery integration

  1. Head over to the left sidebar and click on Integrations
  2. Click on the Add New button
  3. Enter a recognizable name for your integration
  4. Click on the Browse button
  5. Select "Google BigQuery" from the providers list
  6. Click on the Next button
  7. Enter GCP Authentication JSON and Dataset name to connect Google BigQuery with LeadsBridge
  8. Click on the Finish button

How to get the GCP Authentication JSON and Dataset name

To authenticate in Google BigQuery you need to have the OAuth JSON file for your project with the right roles set. If you don't have this file yet, please follow the official guide below to generate it.
Once downloaded, open the file, select the whole content and paste it into the "GCP Authentication JSON" field. Visit the Google BigQuery documentation
All the needed data can be found on your Google BigQuery dashboard on the left as shown in the picture below.
In the "Dataset name" field you have to specify the name of the database you want to use in Google BigQuery.
In the "Project ID" field you have to specify your Google Cloud Platform project id.

As entity Google BigQuery uses the single record of your database, so select "Record" from the "Manage "Entities as" dropdown.

As segmentation, you will have to select the database table to use, so select "Table" from the "Use Segment as" dropdown.

Which entity concepts we support for Google BigQuery

  1. Record

Which segmentation concepts we support for Google BigQuery

With LeadsBridge you may use these segmentation concept for Google BigQuery.

  1. Table

Common questions for Google BigQuery

Why I see the error "GoogleBigQuery error code 400: You can update or delete a record older than 30 minutes."?

You need to know that Google BigQuery is not a "standard database". It mainly used to analyze huge amounts of data.
For this reason, the best use should be to only insert your data. However, you can update all the records older than 30 minutes.
If you give this error, probably some existing record is trying to be resynced before 30 minutes have passed.

Why I can't see my field in the Fields Mapping editor?

The integration Google Big Query allows managing derived tables too. If there is a derived column in the derived table without an ALIAS it will not be visible.

What are the derived tables? Derived tables are tables derived from an inner SELECT like a view.
For example, a derived table is

SELECT * FROM (SELECT fiedl1,field2 FROM myTable) AS myView

Sometimes in the derived table, you could include a function which is a derived column without an alias like

SELECT * FROM (SELECT fiedl1,field2, SUM(field1,field2) FROM myTable) AS myView

In this case, the column of the SUM function will not be visible in the Fields Mapping. To see the function column you must derive it with an alias like

SELECT * FROM (SELECT fiedl1,field2, SUM(field1,field2) as mySum FROM myTable) AS myView

Related Articles

If you have any further questions regarding this matter, or if you need help to set up the connection between Google BigQuery with LeadsBridge, do not hesitate to get in touch!