> Markdown versions of all pages of this connector library are available by appending `.md` to the page URL. For the full index of connectors, see [llms.txt](https://connectors.appmixer.com/llms.txt).

# Google BigQuery connector

- Connector: `appmixer.google.bigquery`
- Version: 4.2.6
- Components: 7 (3 triggers, 4 actions)

Google BigQuery is a data warehouse service.

- Connector page: <https://connectors.appmixer.com/connector/appmixer.google.bigquery/4.2.6>
- Source code: <https://github.com/clientIO/appmixer-connectors/tree/dev/src/appmixer/google/bigquery>
- Download package: <https://connectors.appmixer.com/connector/appmixer.google.bigquery/4.2.6/download>

## Authentication

**Type:** OAuth 2

**Scopes:**

- `profile`
- `email`

## Triggers (3)

- [Deleted Row](https://connectors.appmixer.com/connector/appmixer.google.bigquery/4.2.6/component/appmixer.google.bigquery.DeletedRow.md) (`appmixer.google.bigquery.DeletedRow`): Monitors your BigQuery dataset for deleted rows. While the flow is active, a temporary storage is created specifically for this trigger. This storage will automatically be removed when the flow stops. To ensure smooth operation, please avoid modifying or deleting the storage during the flow's execution. Additional scopes: `https://www.googleapis.com/auth/bigquery`.
- [New Row](https://connectors.appmixer.com/connector/appmixer.google.bigquery/4.2.6/component/appmixer.google.bigquery.NewRow.md) (`appmixer.google.bigquery.NewRow`): Tracks new rows added to your BigQuery dataset. A temporary storage will be created while the flow is running for this trigger, and it will be automatically removed when the flow stops. To ensure continuous operation, kindly refrain from altering or deleting the storage during the flow's execution. Additional scopes: `https://www.googleapis.com/auth/bigquery`.
- [Updated Row](https://connectors.appmixer.com/connector/appmixer.google.bigquery/4.2.6/component/appmixer.google.bigquery.UpdatedRow.md) (`appmixer.google.bigquery.UpdatedRow`): Watch for row updates in your BigQuery dataset. Additional scopes: `https://www.googleapis.com/auth/bigquery`.

## Actions (4)

- [Delete Row](https://connectors.appmixer.com/connector/appmixer.google.bigquery/4.2.6/component/appmixer.google.bigquery.DeleteRow.md) (`appmixer.google.bigquery.DeleteRow`): Removes a row inside a BigQuery table. Additional scopes: `https://www.googleapis.com/auth/bigquery`.
- [Add Row](https://connectors.appmixer.com/connector/appmixer.google.bigquery/4.2.6/component/appmixer.google.bigquery.AddRow.md) (`appmixer.google.bigquery.AddRow`): Add a new row inside a BigQuery table. Additional scopes: `https://www.googleapis.com/auth/bigquery`.
- [List Tables](https://connectors.appmixer.com/connector/appmixer.google.bigquery/4.2.6/component/appmixer.google.bigquery.ListTables.md) (`appmixer.google.bigquery.ListTables`): List BigQuery tables in the given dataset. Additional scopes: `https://www.googleapis.com/auth/bigquery.readonly`.
- [Make Api Call](https://connectors.appmixer.com/connector/appmixer.google.bigquery/4.2.6/component/appmixer.google.bigquery.MakeApiCall.md) (`appmixer.google.bigquery.MakeApiCall`): Generic method for making API calls to a 3rd party service. Additional scopes: `https://www.googleapis.com/auth/bigquery`.

## Changelog

### 4.2.6

- Quote CSV cells that hold a comma, a double quote or a line break and map cells by header column when exporting results to a file.

### 4.2.5

- Security: the shared Google auth (auth.js) moved from googleapis 10 to @googleapis/oauth2 6 and uses a separate OAuth2 client per token operation.

### 4.2.4

- MakeApiCall: Request Headers and Query Parameters set in the Designer are now sent. They were silently dropped: the key-value field stores its rows as a JSON object string, which the component did not parse.

### 4.2.3

- NewRow and DeletedRow: the project picker is now a typeahead text field, so a value can still be entered when the list fails to load; added output schemas with examples.

### 4.2.2

- Added an output schema with an example to AddRow.

### 4.2.1

- Fixed a crash when a Find/List component saved an EMPTY result set to a CSV file — the header row was built from the first record without checking there was one, so a search that legitimately matched nothing failed the flow instead of writing an empty file.

### 4.2.0

- Added MakeApiCall component for performing arbitrary authorized API calls to the Google BigQuery API.

### 4.1.0

- NewRow, UpdatedRow: added test() method for Flow Test Mode (read-only fetch of the newest matching row). DeletedRow has no read-only example source and is intentionally not testable this way.

### 4.0.2

- UpdatedRow: declare detectOnStop in properties.schema.properties so the inspector input reaches the trigger.

### 4.0.1

- (breaking) Added Projects list in the input properties of NewRow, UpdatedRow, DeletedRow to fix error of projectId not found.
- Removed the need to select Storage in NewRow, UpdatedRow and DeletedRow Triggers. Removed the toggle for recordOldValues in UpdatedRow Trigger.

### 3.0.1

- Add quotas for all components.

### 3.0.0

- (breaking) ListProjects: updated endpoint to retrieve project properties. The object returned is not backward compatible.

### 2.1.6

- Fix occasionally using wrong project ID.

### 2.1.5

- Fix output type file on ListTables.

### 2.1.4

- Fix UpdatedRow.

### 2.1.0

- Add Google branded sign-in button.

### 2.0.1

- Fix DeleteRow table input.
- Fix storage cleanup.

### 2.0.0

- Fix ListTables.
- Change ListTables parameters from properties to inputs.

### 1.0.0

- Initial version.
