# Connect Google BigQuery with Open Flow

Source: https://openflow.run/en/integrations/google_bigquery/

[All integrations](https://openflow.run/en/integrations/)

Get a scoped answer from your warehouse without manually assembling every query.

*   [32 actions](https://openflow.run/en/integrations/google_bigquery/#integration-actions)
*   OAuth 2.0
*   Data & analytics
*   Developer tools

[Connect Google BigQuery](https://console.openflow.run/connections/google_bigquery)

20,000 free app calls per month (paid services billed separately)

## What you can do

Inspect tables and rows, run analytical queries, and manage supported data-transfer or table operations with your Google Cloud permissions.

### Schemas and Table Data

Browse projects, datasets, tables, and rows for analysis.

### SQL and Data Transfer Jobs

Run SQL, check jobs, and start Cloud Storage load or export jobs.

### Dataset and Table Management

Create, revise, or delete datasets and tables, and insert rows with per-row error reporting.

## Templates using Google BigQuery

![Log ISS Position to BigQuery workflow in Open Flow](https://openflow.run/template-previews/log-iss-position-to-bigquery/light-cover.webp)

Data

### [Log ISS Position to BigQuery](https://openflow.run/en/templates/log-iss-position-to-bigquery/)

Record the current International Space Station position in a BigQuery table each minute.

## All actions

32 actions

### List Projects

List Google Cloud projects accessible to BigQuery.

`google_bigquery.list_projects`

### List Datasets

List BigQuery datasets in a Google Cloud project.

`google_bigquery.list_datasets`

### Get Dataset

Retrieve BigQuery dataset metadata.

`google_bigquery.get_dataset`

### List Tables

List BigQuery tables in a dataset.

`google_bigquery.list_tables`

### Get Table

Retrieve BigQuery table metadata, including schema when available.

`google_bigquery.get_table`

### List Table Data

List rows from a BigQuery table.

`google_bigquery.list_table_data`

### Query

Run a BigQuery SQL query and return the first page of results.

`google_bigquery.query`

### Get Query Results

Poll a BigQuery query job and return a page of results.

`google_bigquery.get_query_results`

### Get Job

Retrieve BigQuery job metadata.

`google_bigquery.get_job`

### List Jobs

List BigQuery jobs in a Google Cloud project.

`google_bigquery.list_jobs`

### Cancel Job

Cancel a BigQuery job.

`google_bigquery.cancel_job`

### Start Query Job

Start an asynchronous BigQuery query job.

`google_bigquery.start_query_job`

### Start Load Job From Gcs

Start an asynchronous BigQuery load job from Cloud Storage objects.

`google_bigquery.start_load_job_from_gcs`

### Start Extract Job To Gcs

Start an asynchronous BigQuery extract job to Cloud Storage objects.

`google_bigquery.start_extract_job_to_gcs`

### Create Dataset

Create a BigQuery dataset.

`google_bigquery.create_dataset`

### Patch Dataset

Patch BigQuery dataset metadata.

`google_bigquery.patch_dataset`

### Update Dataset

Replace BigQuery dataset metadata with the supplied dataset resource fields.

`google_bigquery.update_dataset`

### Delete Dataset

Delete a BigQuery dataset, optionally deleting contained tables when explicitly requested.

`google_bigquery.delete_dataset`

### Create Table

Create a BigQuery table.

`google_bigquery.create_table`

### Patch Table

Patch BigQuery table metadata.

`google_bigquery.patch_table`

### Update Table

Replace BigQuery table metadata with the supplied table resource fields.

`google_bigquery.update_table`

### Delete Table

Delete a BigQuery table from a dataset.

`google_bigquery.delete_table`

### Insert All

Insert a small batch of rows into a BigQuery table.

`google_bigquery.insert_all`

### List Routines

List BigQuery routines in a dataset.

`google_bigquery.list_routines`

### Get Routine

Retrieve BigQuery routine metadata.

`google_bigquery.get_routine`

### Create Routine

Create a BigQuery routine such as a user-defined function or stored procedure.

`google_bigquery.create_routine`

### Update Routine

Replace BigQuery routine metadata and definition fields.

`google_bigquery.update_routine`

### Delete Routine

Delete a BigQuery routine from a dataset.

`google_bigquery.delete_routine`

### List Models

List BigQuery ML models in a dataset.

`google_bigquery.list_models`

### Get Model

Retrieve BigQuery ML model metadata.

`google_bigquery.get_model`

### Patch Model

Patch BigQuery ML model metadata such as friendly name, description, or labels.

`google_bigquery.patch_model`

### Delete Model

Delete a BigQuery ML model from a dataset.

`google_bigquery.delete_model`

No actions match your search.

## Connect Google BigQuery with Open Flow

[Connect Google BigQuery](https://console.openflow.run/connections/google_bigquery)

20,000 free app calls per month (paid services billed separately)
