Googleapis Bigquery

Google BigQuery is a serverless cloud data warehouse used to store, query, and analyze large datasets.

• Base URL: https://bigquery.googleapis.com/bigquery/v2
• Auth: OAuth 2.0 (user-delegated) — attach an InTouch oauth credential. Mint one with itcli.py /oauth <provider> (device-code) or /google-auth (Google); the server auto-refreshes the access token before each run, so the connector never handles or stores tokens.

Operations

• bigquery_projects_list — GET /projects — Lists all projects to which you have been granted any project role.
• bigquery_datasets_list — GET /projects/{projectId}/datasets — Lists all datasets in the specified project to which you have been granted the R
• bigquery_datasets_get — GET /projects/{projectId}/datasets/{datasetId} — Returns the dataset specified by datasetID.
• bigquery_models_list — GET /projects/{projectId}/datasets/{datasetId}/models — Lists all models in the specified dataset. Requires the READER dataset role. Aft
• bigquery_models_get — GET /projects/{projectId}/datasets/{datasetId}/models/{modelId} — Gets the specified model resource by model ID.
• bigquery_routines_list — GET /projects/{projectId}/datasets/{datasetId}/routines — Lists all routines in the specified dataset. Requires the READER dataset role.

Inputs

• a linked oauth credential (no key inputs) — the server injects a fresh Authorization: Bearer from it
• operation — one of the operations above
• path parameters when an operation's path contains {...}
• query — optional JSON object of query params
• body — JSON object for create/update ops

Example

operation: bigquery_projects_list
# (attach an 'oauth' credential to the task — no inline secrets)

Publishes

The keys a later task may reference as {{taskName.key}}. Referencing anything not listed here resolves to nothing at run time.

• error
• operation
• result
• status

Input Properties

Every property this tool accepts, from its own tool.iml.