Google BigQuery API

API

Run SQL queries against a managed data warehouse

Price: Free query tier, then usage pricing
Access: Google Cloud credentials and IAM

About

BigQuery is Google's managed analytics warehouse. Its REST API can submit GoogleSQL queries, return result rows and follow up on longer-running jobs. Queries require Google Cloud credentials and suitable IAM permissions on the project and data.

What you can do with it

Query warehouse tables from an application or backend service
Analyze large datasets with SQL without managing a database server
Submit a query job and page through results in an integration

Get started

Create a Google Cloud project and enable BigQuery
Grant query and data access with IAM
Obtain an OAuth access token and submit GoogleSQL

Example

curl -X POST "https://bigquery.googleapis.com/bigquery/v2/projects/$PROJECT_ID/queries" \
  -H "Authorization: Bearer $ACCESS_TOKEN" \
  -H "Content-Type: application/json" \
  -d '{"query":"SELECT 1 AS value","useLegacySql":false}'

Details

Hosting: Hosted service
Available in: Worldwide
Official SDKs: C#, Go, Java, JavaScript/TypeScript, PHP, Python, Ruby
MCP server: Remote
Works with: Google Cloud