> ## Documentation Index
> Fetch the complete documentation index at: https://dev.writer.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Google BigQuery connector

> Connect WRITER Agent to Google BigQuery to securely query and analyze data in your BigQuery data warehouse

This guide shows you how to configure the [Google BigQuery](https://cloud.google.com/bigquery) connector for WRITER Agent. After setting up this connector, WRITER Agent can execute SQL queries, list datasets and tables, and retrieve metadata to surface data insights, answer analytical questions, and generate reports based on your BigQuery data warehouse.

## Set up the Google BigQuery connector

Configure the Google BigQuery connector in [AI Studio](https://app.writer.com/aistudio) under **Connectors & Tools**. The Google BigQuery connector requires organization-managed OAuth authentication.

<Note>
  The Google BigQuery connector only supports organization-managed OAuth. You
  must create your own Google Cloud OAuth application. Writer-managed OAuth is
  not available for Google BigQuery.
</Note>

<Note>
  Google OAuth credentials expire after 6 months of inactivity. If the Google
  BigQuery connector is not used for 6 months, users will need to
  re-authenticate.
</Note>

### Enable the BigQuery MCP server

Before configuring the connector, enable the BigQuery API and MCP server in your Google Cloud project:

1. Navigate to the [Google Cloud Console](https://console.cloud.google.com/)
2. Select your project or [create a new one](https://console.cloud.google.com/projectselector2)
3. [Enable the BigQuery API](https://console.cloud.google.com/apis/library/bigquery.googleapis.com) for your project (enabled by default for new projects)
4. Enable the BigQuery MCP server by running the following command in the [Google Cloud Shell](https://console.cloud.google.com/cloudshell) or your local terminal with the [Google Cloud CLI](https://cloud.google.com/sdk/docs/install) installed:
   ```bash theme={null}
   gcloud beta services mcp enable bigquery.googleapis.com \
       --project=PROJECT_ID
   ```
   Replace `PROJECT_ID` with your Google Cloud project ID.

<Note>
  After March 17, 2026, the BigQuery remote MCP server is automatically enabled
  when you enable BigQuery.
</Note>

For detailed instructions, see [Google's BigQuery MCP server documentation](https://docs.cloud.google.com/bigquery/docs/use-bigquery-mcp).

### Create a Google OAuth application

Create a new Google OAuth application in the Google Cloud Console:

1. Navigate to the [Google Cloud Console](https://console.cloud.google.com/)
2. Select the same project where you enabled the BigQuery MCP server
3. Navigate to **APIs & Services** → **Credentials**
4. Configure the OAuth consent screen with your application details
5. Create OAuth 2.0 credentials (Web application type)
6. Add the Writer redirect URI to authorized redirect URIs:
   ```
   https://app.writer.com/mcp/oauth/callback
   ```
7. Configure the [required OAuth scopes](#required-oauth-scopes) for your application
8. Copy the client ID and client secret for use in [AI Studio](#configure-the-connector-in-ai-studio)

For detailed instructions, see [Google's OAuth 2.0 documentation](https://support.google.com/cloud/answer/15549257).

#### Required OAuth scopes

* `https://www.googleapis.com/auth/bigquery` - View and manage your data in BigQuery

### Configure the connector in AI Studio

1. Navigate to **Connectors & Tools** in [AI Studio](https://app.writer.com/aistudio)
2. Select the Google BigQuery connector
3. Select who has access by default (all users or specific teams)
4. Select the connection type:
   * **Level**: User level (each user authenticates their own account) or org level (shared connection to a single account)
5. Select which tools to enable for your agents
6. Enter your OAuth client ID and client secret
7. Complete the OAuth authorization flow

## Next steps

* [Set up connectors](https://support.writer.com/article/299-setting-up-connectors): Learn how to configure and enable connectors in AI Studio
* [MCP gateway overview](/home/mcp-gateway): Learn about Writer's MCP gateway architecture
* [WRITER Agent guide](https://support.writer.com/article/293-how-to-use-action-agent): Learn how to use WRITER Agent with connected tools