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 -- nothing is hosted or proxied by Imperal beyond the request itself.
Every capability exposed by Google BigQuery, metered per action and guarded by the two-step safety protocol.
connect_bigquerywriteConnect your own Google Cloud project by pasting a Service Account JSON key, after checking it actually works against BigQuery.
list_connectionsreadList the connected Google Cloud projects (BigQuery).
disconnect_bigquerywriteDisconnect a Google Cloud project: deletes the saved Service Account key. Nothing in BigQuery itself is changed.
list_datasetsreadList BigQuery datasets in the connected project, with location and default table expiration.
get_datasetreadRead one BigQuery dataset in full by its id.
create_datasetwriteCreate a new BigQuery dataset in the connected project.
delete_datasetwritePermanently delete a BigQuery dataset. Cannot be undone.
list_tablesreadList tables inside one BigQuery dataset.
get_tablereadRead one BigQuery table in full -- schema, row count, size, and partitioning.
delete_tablewritePermanently delete a BigQuery table. Cannot be undone.
execute_sqlwriteRun a SQL query against BigQuery. Always dry-runs first to estimate bytes billed, then executes and returns result rows.
get_jobreadRead one BigQuery job in full by its id -- status, timing, and any error info.
list_jobsreadList recent BigQuery jobs (query runs) in the connected project, most recent first.
cancel_jobwriteCancel a running BigQuery job.
list_scheduled_queriesreadList scheduled queries (recurring BigQuery jobs via Data Transfer Service) configured for a location in the connected project.
create_scheduled_querywriteCreate a new scheduled query (recurring BigQuery job) via Data Transfer Service.
delete_scheduled_querywritePermanently delete a scheduled query. Cannot be undone.
run_scheduled_querywriteManually trigger a scheduled query to run right now, regardless of its schedule.
audit_projectreadBuild one aggregated health report across the connected BigQuery project: datasets with no default table expiration, non-partitioned large tables, and recent failed jobs.
More extensions in Data Warehouse ready to enable in one click.
Enable Google BigQuery in your Imperal workspace in one click - 10,000 free starter credits included.