Integrate with Google BigQuery via Helix iPaaS powered by Jitterbit

Connector

Updated: Mar-11-2024

The Harmony Google BigQuery Connector establishes access to Google BigQuery.

The Google BigQuery connector provides an interface for creating a Google BigQuery connection, the foundation used for generating instances of Google BigQuery activities. These activities, once configured, interact with Google BigQuery through the connection.

Key Features

  • Data Transfer: Transfers data from a data source to a dataset in Google BigQuery and is intended to be used as a target in an operation.
  • Invoke Routine: Invokes a routine (such as a stored procedure, user-defined function, or table function) for a dataset in Google BigQuery and is intended to be used as a target in an operation.
  • Query: Queries a table in a dataset in Google BigQuery and is intended to be used as a source in an operation.
  • Insert Record: Inserts records into a table in Google BigQuery and is intended to be used as a target in an operation.
  • Create Structure: Creates datasets or tables in Google BigQuery and is intended to be used as a target in an operation.
  • Update Structure: Updates structures in Google BigQuery and is intended to be used as a target in an operation.
  • Update Record: Updates records in a dataset in Google BigQuery and is intended to be used as a target in an operation.
  • Delete Structure: Deletes structures from Google BigQuery and is intended to be used as a target in an operation.
  • Execute Custom Query: Executes custom queries against tables in datasets in Google BigQuery and is intended to be used as a source in an operation.

Licensing Information

Please contact your BMC representative for licensing Helix iPaaS.

Supporting Documentation

Jitterbit Documentation