BigQuery

Query Google BigQuery with a service account. Read-only queries are dry-run first and only run if BigQuery says they are SELECTs.

4 tools

Tools

bigquery.query

Run a read-only SQL query. Returns at most 1000 rows.

sql*params

bigquery.list_tables

List tables and views.

dataset

bigquery.describe_table

List a table's columns and types.

table*dataset

bigquery.execute writes

Run a data-modifying SQL statement (INSERT, UPDATE, DELETE).

sql*params

Connect

Credentials

Service account key

Your next automation is one sentence away.

14-day free trial with $5 of built-in AI included. Cancel anytime.