Home
...
Data Analysis and Query
c Google BigQuery SQL Standard

c Google BigQuery SQL Standard

Available connectors

The Google BigQuery SQL Standard component allows you to connect systems to BigQuery, enabling data ingestion.

IMPORTANT
The current implementation only supports standard SQL DML statements. BigQuery Data Manipulation Language (DML) allows you to update, insert, and delete data from tables in BigQuery. The component does not allow the use of SELECT.

URI Syntax: google-bigquery-sql:projectId:queryString

Main fields

Path parameters

Name	Description	Default	Type
`projectId` (common)	(required) Project ID in Google Cloud.	—	String
`queryString` (common)	(required) BigQuery standard SQL query.	—	String

Query parameters

Name	Description	Default	Type
`serviceAccountKey` (security)	Service account key in JSON format to authenticate an application as a service account on Google Cloud Platform.	—	String

Example

In the example below, the flow deletes data from a table in Google BigQuery when a GET request is received:

The flow starts with a GET request in the /demo endpoint.

A SQL DELETE query is executed on Google BigQuery to delete all records from the employees table.

The service account key key.json is used to authenticate the operation on Google BigQuery.

The data is converted to JSON format using the Jackson library, after the SQL query is executed.

IMPORTANT

SELECT query limitation: The component executes SELECT queries, but only returns the number of records found, not the actual data.

Error in official documentation: The Apache Camel documentation contains examples with incorrect syntax, such as delete * from test.table where id=@myId. The correct syntax does not include the asterisk: delete from test.table where id=@myId.

How happy are you with this page?

c Google BigQuery

Data Analysis and Query