Google BigQuery is a data warehouse service.
Changelog
13 versions
v4.2.0
Latest
- Added MakeApiCall component for performing arbitrary authorized API calls to the Google BigQuery API.
v4.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.
v4.0.2
- UpdatedRow: declare detectOnStop in properties.schema.properties so the inspector input reaches the trigger.
v4.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.
v3.0.1
- Add quotas for all components.
v3.0.0
- (breaking) ListProjects: updated endpoint to retrieve project properties. The object returned is not backward compatible.
v2.1.6
- Fix occasionally using wrong project ID.
v2.1.5
- Fix output type file on ListTables.
v2.1.4
- Fix UpdatedRow.
v2.1.0
- Add Google branded sign-in button.
v2.0.1
- Fix DeleteRow table input.
- Fix storage cleanup.
v2.0.0
- Fix ListTables.
- Change ListTables parameters from properties to inputs.
v1.0.0
- Initial version.
Authentication
| Type | Details |
|---|---|
| OAuth 2 |
Scopes:
profile
email
|
Triggers
3
Deleted Row
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
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
Watch for row updates in your BigQuery dataset.
Additional Scopes:
https://www.googleapis.com/auth/bigquery
Actions
4
Add Row
Add a new row inside a BigQuery table.
Additional Scopes:
https://www.googleapis.com/auth/bigquery
Delete Row
Removes a row inside a BigQuery table.
Additional Scopes:
https://www.googleapis.com/auth/bigquery
List Tables
List BigQuery tables in the given dataset.
Additional Scopes:
...ww.googleapis.com/auth/bigquery.readonly
Make Api Call
Generic method for making API calls to a 3rd party service.
Additional Scopes:
https://www.googleapis.com/auth/bigquery