BigQuery REST API

API Endpoints

Code Examples

curl -X POST "https://bigquery.googleapis.com/bigquery/v2/projects/my-project/queries" \
  -H "Authorization: Bearer ya29.a0AfH6SMBx..." \
  -H "Content-Type: application/json" \
  -d '{
    "query": "SELECT name, COUNT(*) as count FROM `my-project.my_dataset.my_table` GROUP BY name ORDER BY count DESC LIMIT 10",
    "useLegacySql": false,
    "timeoutMs": 10000
  }'

const { BigQuery } = require('@google-cloud/bigquery');

const bigquery = new BigQuery({
  projectId: 'my-project',
  keyFilename: './service-account-key.json'
});

async function runQuery() {
  const query = `
    SELECT name, COUNT(*) as count 
    FROM \`my-project.my_dataset.my_table\` 
    GROUP BY name 
    ORDER BY count DESC 
    LIMIT 10
  `;

  const options = {
    query: query,
    location: 'US'
  };

  const [rows] = await bigquery.query(options);
  console.log('Query results:');
  rows.forEach(row => console.log(row));
}

runQuery();

from google.cloud import bigquery
from google.oauth2 import service_account

credentials = service_account.Credentials.from_service_account_file(
    'service-account-key.json'
)

client = bigquery.Client(
    credentials=credentials,
    project='my-project'
)

query = """
    SELECT name, COUNT(*) as count
    FROM `my-project.my_dataset.my_table`
    GROUP BY name
    ORDER BY count DESC
    LIMIT 10
"""

query_job = client.query(query)
results = query_job.result()

for row in results:
    print(f"{row.name}: {row.count}")

Related APIs