BigQuery API

googleapis · Analytics

Analytics No Auth Free & Open analytics media

A data platform for customers to create, manage, share and query data.

Authentication

No authentication requiredFree to use with no key needed.

Sample Requests

GET bigquery.projects.list

Lists all projects to which you have been granted any project role.

https://api.apis.guru/v2/specs/googleapis.com/bigquery/v2/projects?alt=json&key=YOUR_API_KEY&fields=example&userIp=example&pageToken=example&quotaUser=example&maxResults=1&oauth_token=example&prettyPrint=true

Hover any highlighted part to learn what it does

curl -X GET "https://api.apis.guru/v2/specs/googleapis.com/bigquery/v2/projects?alt=json&key=YOUR_API_KEY&fields=example&userIp=example&pageToken=example&quotaUser=example&maxResults=1&oauth_token=example&prettyPrint=true"

import requests
params = {
    "alt": "json",
    "key": "YOUR_API_KEY",
    "fields": "example",
    "userIp": "example",
    "pageToken": "example",
    "quotaUser": "example",
    "maxResults": "1",
    "oauth_token": "example",
    "prettyPrint": "true"
}
response = requests.get(
    "https://api.apis.guru/v2/specs/googleapis.com/bigquery/v2/projects",
    params=params,
)
print(response.json())

const url = new URL('https://api.apis.guru/v2/specs/googleapis.com/bigquery/v2/projects');
url.searchParams.set('alt', 'json');
url.searchParams.set('key', 'YOUR_API_KEY');
url.searchParams.set('fields', 'example');
url.searchParams.set('userIp', 'example');
url.searchParams.set('pageToken', 'example');
url.searchParams.set('quotaUser', 'example');
url.searchParams.set('maxResults', '1');
url.searchParams.set('oauth_token', 'example');
url.searchParams.set('prettyPrint', 'true');

const response = await fetch(url); 
const data = await response.json();
console.log(data);

package main

import (
	"fmt"
	"io"
	"net/http"
	"net/url"
)

func main() {
	baseURL, _ := url.Parse("https://api.apis.guru/v2/specs/googleapis.com/bigquery/v2/projects")
	q := baseURL.Query()
	q.Set("alt", "json")
	q.Set("key", "YOUR_API_KEY")
	q.Set("fields", "example")
	q.Set("userIp", "example")
	q.Set("pageToken", "example")
	q.Set("quotaUser", "example")
	q.Set("maxResults", "1")
	q.Set("oauth_token", "example")
	q.Set("prettyPrint", "true")
	baseURL.RawQuery = q.Encode()
	targetURL := baseURL.String()
	req, _ := http.NewRequest("GET", targetURL, nil)

	client := &http.Client{}
	resp, _ := client.Do(req)
	defer resp.Body.Close()
	body, _ := io.ReadAll(resp.Body)
	fmt.Println(string(body))
}

require "net/http"
require "json"

uri = URI("https://api.apis.guru/v2/specs/googleapis.com/bigquery/v2/projects")
uri.query = URI.encode_www_form({
  "alt" => "json",
  "key" => "YOUR_API_KEY",
  "fields" => "example",
  "userIp" => "example",
  "pageToken" => "example",
  "quotaUser" => "example",
  "maxResults" => "1",
  "oauth_token" => "example",
  "prettyPrint" => "true"
})

http = Net::HTTP.new(uri.host, uri.port)
http.use_ssl = uri.scheme == "https"

req = Net::HTTP::Get.new(uri)

res = http.request(req)
puts JSON.parse(res.body)

<?php
$url = "https://api.apis.guru/v2/specs/googleapis.com/bigquery/v2/projects?" . http_build_query([
    "alt" => "json",
    "key" => "YOUR_API_KEY",
    "fields" => "example",
    "userIp" => "example",
    "pageToken" => "example",
    "quotaUser" => "example",
    "maxResults" => "1",
    "oauth_token" => "example",
    "prettyPrint" => "true"
]);
$opts = ["http" => [
    "method" => "GET",
]];
$ctx = stream_context_create($opts);
$res = file_get_contents($url, false, $ctx);
print_r(json_decode($res, true));

GET bigquery.datasets.list

Lists all datasets in the specified project to which you have been granted the READER dataset role.

https://api.apis.guru/v2/specs/googleapis.com/bigquery/v2/projects/{projectId}/datasets?all=true&alt=json&key=YOUR_API_KEY&fields=example&filter=example&userIp=example&pageToken=example&quotaUser=example&maxResults=1&oauth_token=example&prettyPrint=true

Hover any highlighted part to learn what it does

curl -X GET "https://api.apis.guru/v2/specs/googleapis.com/bigquery/v2/projects/{projectId}/datasets?all=true&alt=json&key=YOUR_API_KEY&fields=example&filter=example&userIp=example&pageToken=example&quotaUser=example&maxResults=1&oauth_token=example&prettyPrint=true"

import requests
params = {
    "all": "true",
    "alt": "json",
    "key": "YOUR_API_KEY",
    "fields": "example",
    "filter": "example",
    "userIp": "example",
    "pageToken": "example",
    "quotaUser": "example",
    "maxResults": "1",
    "oauth_token": "example",
    "prettyPrint": "true"
}
response = requests.get(
    "https://api.apis.guru/v2/specs/googleapis.com/bigquery/v2/projects/{projectId}/datasets",
    params=params,
)
print(response.json())

const url = new URL('https://api.apis.guru/v2/specs/googleapis.com/bigquery/v2/projects/{projectId}/datasets');
url.searchParams.set('all', 'true');
url.searchParams.set('alt', 'json');
url.searchParams.set('key', 'YOUR_API_KEY');
url.searchParams.set('fields', 'example');
url.searchParams.set('filter', 'example');
url.searchParams.set('userIp', 'example');
url.searchParams.set('pageToken', 'example');
url.searchParams.set('quotaUser', 'example');
url.searchParams.set('maxResults', '1');
url.searchParams.set('oauth_token', 'example');
url.searchParams.set('prettyPrint', 'true');

const response = await fetch(url); 
const data = await response.json();
console.log(data);

package main

import (
	"fmt"
	"io"
	"net/http"
	"net/url"
)

func main() {
	baseURL, _ := url.Parse("https://api.apis.guru/v2/specs/googleapis.com/bigquery/v2/projects/{projectId}/datasets")
	q := baseURL.Query()
	q.Set("all", "true")
	q.Set("alt", "json")
	q.Set("key", "YOUR_API_KEY")
	q.Set("fields", "example")
	q.Set("filter", "example")
	q.Set("userIp", "example")
	q.Set("pageToken", "example")
	q.Set("quotaUser", "example")
	q.Set("maxResults", "1")
	q.Set("oauth_token", "example")
	q.Set("prettyPrint", "true")
	baseURL.RawQuery = q.Encode()
	targetURL := baseURL.String()
	req, _ := http.NewRequest("GET", targetURL, nil)

	client := &http.Client{}
	resp, _ := client.Do(req)
	defer resp.Body.Close()
	body, _ := io.ReadAll(resp.Body)
	fmt.Println(string(body))
}

require "net/http"
require "json"

uri = URI("https://api.apis.guru/v2/specs/googleapis.com/bigquery/v2/projects/{projectId}/datasets")
uri.query = URI.encode_www_form({
  "all" => "true",
  "alt" => "json",
  "key" => "YOUR_API_KEY",
  "fields" => "example",
  "filter" => "example",
  "userIp" => "example",
  "pageToken" => "example",
  "quotaUser" => "example",
  "maxResults" => "1",
  "oauth_token" => "example",
  "prettyPrint" => "true"
})

http = Net::HTTP.new(uri.host, uri.port)
http.use_ssl = uri.scheme == "https"

req = Net::HTTP::Get.new(uri)

res = http.request(req)
puts JSON.parse(res.body)

<?php
$url = "https://api.apis.guru/v2/specs/googleapis.com/bigquery/v2/projects/{projectId}/datasets?" . http_build_query([
    "all" => "true",
    "alt" => "json",
    "key" => "YOUR_API_KEY",
    "fields" => "example",
    "filter" => "example",
    "userIp" => "example",
    "pageToken" => "example",
    "quotaUser" => "example",
    "maxResults" => "1",
    "oauth_token" => "example",
    "prettyPrint" => "true"
]);
$opts = ["http" => [
    "method" => "GET",
]];
$ctx = stream_context_create($opts);
$res = file_get_contents($url, false, $ctx);
print_r(json_decode($res, true));

GET bigquery.jobs.list

Lists all jobs that you started in the specified project. Job information is available for a six month period after creation. The job list is sorted in reverse chronological order, by job creation time. Requires the Can View project role, or the Is Owner project role if you set the allUsers property

https://api.apis.guru/v2/specs/googleapis.com/bigquery/v2/projects/{projectId}/jobs?alt=json&key=YOUR_API_KEY&fields=example&userIp=example&allUsers=true&pageToken=example&quotaUser=example&maxResults=1&projection=full&oauth_token=example&parentJobId=example&prettyPrint=true&stateFilter=example&maxCreationTime=example&minCreationTime=example

Hover any highlighted part to learn what it does

curl -X GET "https://api.apis.guru/v2/specs/googleapis.com/bigquery/v2/projects/{projectId}/jobs?alt=json&key=YOUR_API_KEY&fields=example&userIp=example&allUsers=true&pageToken=example&quotaUser=example&maxResults=1&projection=full&oauth_token=example&parentJobId=example&prettyPrint=true&stateFilter=example&maxCreationTime=example&minCreationTime=example"

import requests
params = {
    "alt": "json",
    "key": "YOUR_API_KEY",
    "fields": "example",
    "userIp": "example",
    "allUsers": "true",
    "pageToken": "example",
    "quotaUser": "example",
    "maxResults": "1",
    "projection": "full",
    "oauth_token": "example",
    "parentJobId": "example",
    "prettyPrint": "true",
    "stateFilter": "example",
    "maxCreationTime": "example",
    "minCreationTime": "example"
}
response = requests.get(
    "https://api.apis.guru/v2/specs/googleapis.com/bigquery/v2/projects/{projectId}/jobs",
    params=params,
)
print(response.json())

const url = new URL('https://api.apis.guru/v2/specs/googleapis.com/bigquery/v2/projects/{projectId}/jobs');
url.searchParams.set('alt', 'json');
url.searchParams.set('key', 'YOUR_API_KEY');
url.searchParams.set('fields', 'example');
url.searchParams.set('userIp', 'example');
url.searchParams.set('allUsers', 'true');
url.searchParams.set('pageToken', 'example');
url.searchParams.set('quotaUser', 'example');
url.searchParams.set('maxResults', '1');
url.searchParams.set('projection', 'full');
url.searchParams.set('oauth_token', 'example');
url.searchParams.set('parentJobId', 'example');
url.searchParams.set('prettyPrint', 'true');
url.searchParams.set('stateFilter', 'example');
url.searchParams.set('maxCreationTime', 'example');
url.searchParams.set('minCreationTime', 'example');

const response = await fetch(url); 
const data = await response.json();
console.log(data);

package main

import (
	"fmt"
	"io"
	"net/http"
	"net/url"
)

func main() {
	baseURL, _ := url.Parse("https://api.apis.guru/v2/specs/googleapis.com/bigquery/v2/projects/{projectId}/jobs")
	q := baseURL.Query()
	q.Set("alt", "json")
	q.Set("key", "YOUR_API_KEY")
	q.Set("fields", "example")
	q.Set("userIp", "example")
	q.Set("allUsers", "true")
	q.Set("pageToken", "example")
	q.Set("quotaUser", "example")
	q.Set("maxResults", "1")
	q.Set("projection", "full")
	q.Set("oauth_token", "example")
	q.Set("parentJobId", "example")
	q.Set("prettyPrint", "true")
	q.Set("stateFilter", "example")
	q.Set("maxCreationTime", "example")
	q.Set("minCreationTime", "example")
	baseURL.RawQuery = q.Encode()
	targetURL := baseURL.String()
	req, _ := http.NewRequest("GET", targetURL, nil)

	client := &http.Client{}
	resp, _ := client.Do(req)
	defer resp.Body.Close()
	body, _ := io.ReadAll(resp.Body)
	fmt.Println(string(body))
}

require "net/http"
require "json"

uri = URI("https://api.apis.guru/v2/specs/googleapis.com/bigquery/v2/projects/{projectId}/jobs")
uri.query = URI.encode_www_form({
  "alt" => "json",
  "key" => "YOUR_API_KEY",
  "fields" => "example",
  "userIp" => "example",
  "allUsers" => "true",
  "pageToken" => "example",
  "quotaUser" => "example",
  "maxResults" => "1",
  "projection" => "full",
  "oauth_token" => "example",
  "parentJobId" => "example",
  "prettyPrint" => "true",
  "stateFilter" => "example",
  "maxCreationTime" => "example",
  "minCreationTime" => "example"
})

http = Net::HTTP.new(uri.host, uri.port)
http.use_ssl = uri.scheme == "https"

req = Net::HTTP::Get.new(uri)

res = http.request(req)
puts JSON.parse(res.body)

<?php
$url = "https://api.apis.guru/v2/specs/googleapis.com/bigquery/v2/projects/{projectId}/jobs?" . http_build_query([
    "alt" => "json",
    "key" => "YOUR_API_KEY",
    "fields" => "example",
    "userIp" => "example",
    "allUsers" => "true",
    "pageToken" => "example",
    "quotaUser" => "example",
    "maxResults" => "1",
    "projection" => "full",
    "oauth_token" => "example",
    "parentJobId" => "example",
    "prettyPrint" => "true",
    "stateFilter" => "example",
    "maxCreationTime" => "example",
    "minCreationTime" => "example"
]);
$opts = ["http" => [
    "method" => "GET",
]];
$ctx = stream_context_create($opts);
$res = file_get_contents($url, false, $ctx);
print_r(json_decode($res, true));

Postman Setup Guide

Get Postman ↗

See official documentation for authentication and setup.

What can you build with BigQuery API?

BigQuery API is a Analytics API. Developers commonly use analytics APIs for:

tracking product usage and user behaviour
building custom reporting and BI dashboards
measuring marketing and campaign performance
running funnel, retention, and cohort analysis
aggregating metrics from multiple data sources

No authentication required. This API is open — no signup or key needed. Ideal for quick prototypes and public-facing features. BigQuery API is free to use, making it a low-risk choice to experiment with.

New to APIs? Read our beginner's guide

Open documentation ↗