...
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
...
Universal Agent for Windows x64 Version 67.9 0 and later with Python options installed.
Universal Agent for Linux Version 67.9 0 and later with Python options installed.
...
Universal Controller Version 67.90.0.0 and later.
Software Requirements for the Application to be Scheduled
...
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