...
This task uses Python modules google-cloud-bigquery and google-auth to make REST-API calls to Google BigQuery
This task will use the GCP Project ID, BigQuery SQL or Schema, Dataset ID, Job ID, Location, Table ID, Cloud Storage URI, and Source File Format as parameters of BigQuery function, and GCP KeyFile (API KEY) of Service account for authenticating the REST-API calls to Google BigQuery.
User can perform the following Google BigQuery operations:
BigQuery SQL
List dataset
List tables in dataset
View job information
Create a dataset
Load local file to a table
Load cloud storage data to a table
Export table data
Version Information
| Template Name | Version |
|---|---|
| CS Google BigQuery | 1.1.4 |
Refer to changelog for version history information.
Software Requirements
This Universal Task requires a Universal Agent and a Python runtime to execute the Universal Task against a Google BigQuery data warehouse.
...
Requires Python 3.4 or higher. Tested with the Universal Agent bundled Python distribution.
Python modules required:
- google-cloud-bigquerygoogle-auth
Software Requirements for Universal Agent
...
Name | Description |
|---|---|
User documentation for creating Universal Templates in the Universal Controller user interface. | |
User documentation for creating Universal Tasks in the Universal Controller user interface. |
| Anchor | ||||
|---|---|---|---|---|
|
Changelog
ut-cs-google-bigquery 1.1.4 (2024-08-08)
- Fix: Usage for the Double quotes for the _scriptPath
ut-cs-google-bigquery 1.1.3 (2022-03-25)
- Fix: Icon change
ut-cs-google-bigquery 1.0.0 (2020-11-17)
- Initial Version