---
title: 'Google BigQuery'
description: 'Run SQL queries and manage datasets and tables in Google BigQuery.'
---

# Google BigQuery

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

| Detail | Value |
|---|---|
| Category | Database |
| Base URL | `https://bigquery.googleapis.com/bigquery/v2` |
| Authentication | See connector docs |
| Endpoints | 8 |
| Connector key | `gcp-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

| Endpoint | Summary |
|---|---|
| [GET /projects/{projectId}/datasets](./get_projects_projectid_datasets_database_listdatasets) | List datasets |
| [POST /projects/{projectId}/datasets](./post_projects_projectid_datasets_database_insertdataset) | Create a dataset |
| [GET /projects/{projectId}/datasets/{datasetId}/tables](./get_projects_projectid_datasets_datasetid_tables_database_listtables) | List tables |
| [POST /projects/{projectId}/queries](./post_projects_projectid_queries_database_queryjob) | Run a SQL query |
| [GET /projects/{projectId}/jobs](./get_projects_projectid_jobs_database_listjobs) | List jobs |
| [GET /projects/{projectId}/jobs/{jobId}](./get_projects_projectid_jobs_jobid_database_getjob) | Get job details |
| [POST /projects/{projectId}/jobs/{jobId}/cancel](./post_projects_projectid_jobs_jobid_cancel_database_canceljob) | Cancel a job |
| [GET /projects/{projectId}/datasets/{datasetId}/tables/{tableId}/data](./get_projects_projectid_datasets_datasetid_tables_tableid_data_database_listtabledata) | List table data |

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