---
title: c Google BigQuery SQL Standard
description: Available connectors
documentId: ipaas-google-bigquery-sql
locale: en-US
---

The [**Google BigQuery SQL Standard**](https://camel.apache.org/components/4.10.x/google-bigquery-sql-component.html) component allows you to connect systems to BigQuery, enabling data ingestion.

<Callout type="important" title="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**.
</Callout>

**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:

<Steps>
  <Step>
  The flow starts with a GET request in the `/demo` endpoint.
  </Step>
  <Step>
    A SQL DELETE query is executed on Google BigQuery to delete all records from the `employees` table.
  </Step>
  <Step>
   The service account key `key.json` is used to authenticate the operation on Google BigQuery.
  </Step>
  <Step>
   The data is converted to JSON format using the Jackson library, after the SQL query is executed.
  </Step>
</Steps>

```yaml
- from:
    uri: rest:get:/demo
    steps:
      - to:
          uri: google-bigquery-sql://registry-ipaas-testing:delete from poc_bigquery.employees where true
          parameters:
            serviceAccountKey: key.json
      - marshal:
          json:
            library: Jackson
```

![](https://creative-ball-51b3fc85c0.media.strapiapp.com/google_bigquery_sql_connector_0eca40968e.png)


<Callout type="important" title="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`.
</Callout>