Connect your own Google BigQuery project to manage datasets, tables, queries/jobs, and scheduled queries, and audit warehouse cost and health -- from Imperal. Uses your own GCP Service Account -- n...
What this app can do
19 tools registered
Connect BigqueryFree
Connect your own Google Cloud project by pasting a Service Account JSON key, after checking it actually works against BigQuery.
List ConnectionsFree
List the connected Google Cloud projects (BigQuery).
Disconnect BigqueryFree
Disconnect a Google Cloud project: deletes the saved Service Account key. Nothing in BigQuery itself is changed.
List Datasets8 tok
List BigQuery datasets in the connected project, with location and default table expiration.
Get Dataset8 tok
Read one BigQuery dataset in full by its id.
Create Dataset16 tok
Create a new BigQuery dataset in the connected project.
Delete Dataset16 tok
Permanently delete a BigQuery dataset. Cannot be undone.
List Tables8 tok
List tables inside one BigQuery dataset.
Get Table8 tok
Read one BigQuery table in full -- schema, row count, size, and partitioning.
Delete Table16 tok
Permanently delete a BigQuery table. Cannot be undone.
Execute Sql20 tok
Run a SQL query against BigQuery. Always dry-runs first to estimate bytes billed, then executes and returns result rows.
Get Job8 tok
Read one BigQuery job in full by its id -- status, timing, and any error info.
List Jobs8 tok
List recent BigQuery jobs (query runs) in the connected project, most recent first.
Cancel Job16 tok
Cancel a running BigQuery job.
List Scheduled Queries8 tok
List scheduled queries (recurring BigQuery jobs via Data Transfer Service) configured for a location in the connected project.
Create Scheduled Query16 tok
Create a new scheduled query (recurring BigQuery job) via Data Transfer Service.
Delete Scheduled Query16 tok
Permanently delete a scheduled query. Cannot be undone.
Run Scheduled Query20 tok
Manually trigger a scheduled query to run right now, regardless of its schedule.
Audit Project40 tok
Build one aggregated health report across the connected BigQuery project: datasets with no default table expiration, non-partitioned large tables, and recent failed jobs.