rocketkind
Analytics

Google BigQuery

Google BigQuery is Google Cloud's serverless data warehouse: datasets hold tables and views, and every query, load, export or copy runs as a job.

Authentication

  • Service account (JWT bearer)

Actions

Generic API request. Call any Google BigQuery API endpoint on this connection, for the case where no shipped action covers it yet. The connection supplies the base URL, the authentication and the egress route, so only the path, query and body are yours to fill.

  • Get datasetGet one BigQuery dataset's metadata by id, to confirm it exists and read where it lives before querying or writing to its tables.
  • Get query resultsRead the results of a query job that already ran or is still running - whether it has finished, and a page of its rows.
  • Get tableGet one BigQuery table's or view's metadata - its columns with their types, modes and descriptions (nested RECORD fields included), its type (TABLE, VIEW, MATERIALIZEDVIEW, EXTERNAL, SNAPSHOT), row count and size, partitioning and clustering, and when it last changed.
  • List datasetsList the datasets in a BigQuery project.
  • List jobsList the BigQuery jobs run in a project — queries, loads, exports and copies — with each job's state.
  • List projectsList the Google Cloud projects the connected service account can use BigQuery in.
  • List tablesList the tables and views in one BigQuery dataset.
  • Run a queryRun one read-only GoogleSQL query in BigQuery - SELECT, WITH ...

Triggers

  • New jobStarts when a new BigQuery job is created in the connected project.

Product names, logos and brands are the property of their respective owners and are used here for identification only. Their use does not imply endorsement by, or affiliation with, those owners.