The BigQuery component is a data component that allows users to insert data to BigQuery tables. It can carry out the following tasks:
#Release Stage
Alpha
#Configuration
The component configuration is defined and maintained here.
#Setup
| Field | Field ID | Type | Note |
|---|---|---|---|
| JSON Key File contents (required) | json-key | string | Contents of the JSON key file with access to the bucket. |
| BigQuery Project ID (required) | project-id | string | Fill in your BigQuery Project ID. |
| BigQuery Dataset ID (required) | dataset-id | string | Fill in your BigQuery Dataset ID. |
| BigQuery Table Name (required) | table-name | string | Fill in your BigQuery Table Name. |
#Supported Tasks
#Insert
Insert data to BigQuery.
| Input | ID | Type | Description |
|---|---|---|---|
| Task ID (required) | task | string | TASK_INSERT |
| Data | data | object | The data to be inserted to BigQuery |
| Output | ID | Type | Description |
|---|---|---|---|
| Status | status | string | Status of the upload operation |
#Read
Read data from BigQuery.
| Input | ID | Type | Description |
|---|---|---|---|
| Task ID (required) | task | string | TASK_READ |
| Filtering | filtering | string | The filter to be applied to the data with SQL syntax, which starts with WHERE clause |
| Output | ID | Type | Description |
|---|---|---|---|
| Data | data | array[object] | The data to be read from BigQuery |