Google BigQuery

List datasets in a BigQuery project. Returns dataset IDs, descriptions, and locations. Use list_projects first to get available project IDs.

Get detailed information about a specific BigQuery dataset including description, location, labels, and access controls. Use list_datasets to find available dataset IDs.

Create a new dataset in a BigQuery project. Specify location (US, EU, etc.) at creation time — it cannot be changed later. Use list_projects to find available project IDs.

Update a BigQuery dataset’s description, friendly name, labels, or default table expiration. Location cannot be changed. Use list_datasets to find available dataset IDs.

Delete a BigQuery dataset. Set delete_contents=true to delete all tables in the dataset. Without it, the dataset must be empty. Use list_datasets to find available dataset IDs.

List BigQuery jobs in a project. Filter by state (done, pending, running) and projection level. Returns job IDs, types, status, and statistics.

Get detailed information about a specific BigQuery job including status, configuration, and statistics. Use list_jobs to find job IDs, or use the job_id from a run_query response.

Cancel a running BigQuery job. The job may still complete if it finishes before the cancellation takes effect. Use list_jobs with state_filter=‘running’ to find cancellable jobs.

List all BigQuery projects accessible to the authenticated user. Returns project IDs, names, and numeric IDs. Use this to discover available projects before querying datasets or tables.

Execute a SQL query in BigQuery and return results.

Get results from a previously executed query using its job ID.

List tables in a BigQuery dataset. Returns table IDs, types, and creation times. Use list_datasets first to get available dataset IDs.

Get detailed information about a BigQuery table including schema, row count, size, and partitioning config. Use list_tables to find available table IDs.

Create a new table in a BigQuery dataset with a typed schema. Supports STRING, INTEGER, FLOAT, BOOLEAN, TIMESTAMP, RECORD, and more. Use list_datasets to find available dataset IDs.

Update a BigQuery table’s description, friendly name, labels, or schema (add new columns only — cannot remove/rename). Use list_tables to find available table IDs.

Delete a BigQuery table permanently. This cannot be undone. Use list_tables to find available table IDs.

Read rows from a BigQuery table. Returns data as column:value dicts with pagination support. For filtered/aggregated data, use run_query instead. Use list_tables to find table IDs.

Stream-insert rows into a BigQuery table. Each row is a dict of column_name:value pairs. Returns insert errors if any rows fail. Use list_tables to find table IDs.

Copy a BigQuery table to a new location (within/across datasets or projects).

Export a BigQuery table to Google Cloud Storage in CSV, JSON, Avro, or Parquet format.