Google BigQuery

Connect your own Google Cloud project by pasting a Service Account JSON key, after checking it actually works against BigQuery.

List the connected Google Cloud projects (BigQuery).

Disconnect a Google Cloud project: deletes the saved Service Account key. Nothing in BigQuery itself is changed.

List BigQuery datasets in the connected project, with location and default table expiration.

Read one BigQuery dataset in full by its id.

Create a new BigQuery dataset in the connected project.

Permanently delete a BigQuery dataset. Cannot be undone.

List tables inside one BigQuery dataset.

Read one BigQuery table in full -- schema, row count, size, and partitioning.

Permanently delete a BigQuery table. Cannot be undone.

Run a SQL query against BigQuery. Always dry-runs first to estimate bytes billed, then executes and returns result rows.

Read one BigQuery job in full by its id -- status, timing, and any error info.

List recent BigQuery jobs (query runs) in the connected project, most recent first.

Cancel a running BigQuery job.

List scheduled queries (recurring BigQuery jobs via Data Transfer Service) configured for a location in the connected project.

Create a new scheduled query (recurring BigQuery job) via Data Transfer Service.

Permanently delete a scheduled query. Cannot be undone.

Manually trigger a scheduled query to run right now, regardless of its schedule.

Build one aggregated health report across the connected BigQuery project: datasets with no default table expiration, non-partitioned large tables, and recent failed jobs.