OneHazel Docs

Appearance

Google BigQuery ​

Run SQL queries and manage datasets and tables in Google BigQuery.

DetailValue
CategoryDatabase
Base URLhttps://bigquery.googleapis.com/bigquery/v2
AuthenticationSee connector docs
Endpoints8
Connector keygcp-bigquery

Using Google BigQuery in a workflow ​

  1. Go to Connections and click New Connection.
  2. Pick Google BigQuery from the marketplace.
  3. Enter your credentials (see Authentication above for what's expected).
  4. In a workflow, drop an API Call node and select this connection.
  5. Pick the operation you need from the Operation dropdown — see the table below.

Available Endpoints ​

EndpointSummary
GET /projects/{projectId}/datasetsList datasets
POST /projects/{projectId}/datasetsCreate a dataset
GET /projects/{projectId}/datasets/{datasetId}/tablesList tables
POST /projects/{projectId}/queriesRun a SQL query
GET /projects/{projectId}/jobsList jobs
GET /projects/{projectId}/jobs/{jobId}Get job details
POST /projects/{projectId}/jobs/{jobId}/cancelCancel a job
GET /projects/{projectId}/datasets/{datasetId}/tables/{tableId}/dataList table data

Each endpoint has its own page with parameter details, an example API Call node configuration, and the response shape.