Skip to content

BigQuery Tools Documentation

This document lists all available BigQuery tools and how to connect to BigQuery.

Tools

Tool Name Description Parameters
bigquery_execute_database_query Execute SQL queries against Google Cloud BigQuery - connection_id (string): The ID of the BigQuery connection to use
- sql_query (string): The SQL query to execute
bigquery_list_database_connections List all available BigQuery connections None

Configuration

Required Configuration Parameters

Before connecting to BigQuery, you'll need to gather the following information:

  1. BigQuery Project ID - Your Google Cloud project ID (e.g., my-project-123)
  2. BigQuery Credentials - A JSON service account key file with appropriate BigQuery permissions
  3. BigQuery Location - The geographic location of your BigQuery datasets (e.g., US, EU, asia-northeast1)

Setting Up Service Account Credentials

  1. Create a Service Account:
  2. Go to the Google Cloud Console
  3. Navigate to "IAM & Admin" > "Service Accounts"
  4. Click "Create Service Account"

  5. Give it a name and description

  6. Assign BigQuery Permissions:

  7. Add the following roles to your service account:

    • BigQuery Data Viewer (for read-only access)
    • BigQuery Job User (for running queries)
    • BigQuery Data Editor (for write access, if needed)

  8. Generate JSON Key:

  9. Click on your service account
  10. Go to the "Keys" tab
  11. Click "Add Key" > "Create new key"
  12. Choose "JSON" format

  13. Download the JSON file

  14. Configure in DataMates:

  15. Copy the contents of the downloaded JSON file
  16. Paste it into the "BigQuery Credentials" field in your DataMates configuration