Integrate Google BigQuery with LeadsBridge
In this article, you'll learn how to connect your LeadsBridge account with Google BigQuery.
Connect Google BigQuery integration
- Head over to the left sidebar and click on Integrations
- Click on the Add New button
- Enter a recognizable name for your integration
- Click on the Browse button
- Select "Google BigQuery" from the providers list
- Click on the Next button
- Enter GCP Authentication JSON and Dataset name to connect Google BigQuery with LeadsBridge
- Click on the Finish button
How to get the GCP Authentication JSON and Dataset name
Once downloaded, open the file, select the whole content and paste it into the "GCP Authentication JSON" field. Visit the Google BigQuery documentation
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
Which segmentation concepts we support for Google BigQuery
With LeadsBridge you may use these segmentation concept for Google BigQuery.
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."?
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?
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
- How to create a bridge
- How to connect Facebook Leads Ads to Google BigQuery
- How to connect any CRM/Platform
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!