BigQuery Get Job
Get the status and metadata of a BigQuery job. Use this to check if a long-running query has completed before fetching results.
BigQuery Get Query Results
Retrieve results from a previously executed BigQuery job. Use this to fetch paginated results from a long-running query using the jobId and pageToken.
BigQuery Get Table Schema
Get the schema and metadata of a BigQuery table. Returns column definitions (names, types, modes, descriptions), row count, size, and partitioning info.
BigQuery Insert Rows
Stream-insert rows into a BigQuery table using the tabledata.insertAll API. Ideal for real-time inserts. Each row is a JSON object matching the table schema.
BigQuery List Datasets
List all datasets in a BigQuery project. Returns dataset IDs, names, locations, and creation times.
BigQuery List Projects
List all GCP projects accessible to the service account that have BigQuery enabled.
BigQuery List Table Data
Read rows directly from a BigQuery table without running a query. Useful for sampling data or reading small tables. For filtering or transformations, use bigquery:query instead.
BigQuery List Tables
List all tables in a BigQuery dataset. Returns table IDs, types, row counts, and sizes.
BigQuery Query
Run a GoogleSQL query against BigQuery and return results. Supports standard SQL syntax including JOINs, aggregations, window functions, and DDL/DML. For large result sets, results are paginated — use the pageToken to fetch subsequent pages.