BigQuery Adapter Capabilities

The BigQuery Adapter enables you to integrate Google BigQuery with Oracle Integration. BigQuery is a cloud-based analytics database service that allows you to load, insert, query, and extract large volumes of data efficiently.

You can configure the BigQuery Adapter as an invoke connection in an integration.

The BigQuery Adapter provides the following capabilities:

General Capabilities

• Supports integration with Google BigQuery projects, datasets, and tables.
• Supports Authorization Code Credentials authentication, including Proof Key for Code Exchange (PKCE) support for enhanced OAuth security.
• Supports execution of operations in synchronous and asynchronous modes.
• Supports validating SQL queries during design time.

Supported Modules

The BigQuery Adapter currently supports the following three modules:

• Bulk Load/Extract:
  • Bulk load: Loads data from Google Storage into a BigQuery table.
  • Extract: Extracts data from a BigQuery table to Google Storage.
  • Job-related operations:
    • Check job status
    • List jobs
    • Cancel a job
    • Delete a job
• Query:
  • Executes SQL queries against BigQuery tables.
  • Supports the following queries:
    • Synchronous queries
    • Asynchronous queries
  • Retrieves query execution status and query results.
• Operation on Table:
  • Lists data present in a BigQuery table.
  • Inserts data into tables:
    • Inserts a single row
    • Inserts multiple rows

The BigQuery Adapter is one of many predefined adapters included with Oracle Integration. See the Adapters page in the Oracle Help Center.