Google BigQuery Connector 1.2

Anypoint Connector for Google BigQuery (Google BigQuery Connector) syncs data and automates business processes between Google BigQuery and third-party applications, either on-premises or in the cloud.

For information about compatibility and fixed issues, refer to the Google BigQuery Connector Release Notes.

Before You Begin

To use this connector, you must be familiar with:

The Google BigQuery API
Anypoint Connectors
Mule runtime engine (Mule)
Elements and global elements in a Mule flow
How to create a Mule app using Anypoint Studio

Before creating an app, you must have:

Credentials to access the Google BigQuery target resource
Anypoint Platform
Anypoint Studio or Anypoint Code Builder

Common Use Cases For the Connector

These are some common use cases for Google BigQuery Connector:

Use log and event data collection to analyze problems
Insert, update, and delete data in Google BigQuery

You can insert multiple rows by using multi-row INSERT statements in your query or job (for example, INSERT INTO table VALUES (1, 'val1'), (2, 'val2')). The connector passes the SQL to BigQuery. There’s no dedicated bulk insert operation, batching, or optimization for large datasets.

MERGE isn’t supported. For merge-like behavior, use a SELECT followed by conditional INSERT or UPDATE operations in your flow, which is less efficient and not atomic.
Execute a query in Google BigQuery