How to connect multiple Google BigQuery accounts to Claude

Claude's built-in Google BigQuery connector works well if you use one Google BigQuery account. But when you connect a second account, it replaces the first.

If you manage separate Google BigQuery accounts for different products, regions, or business units, that quickly becomes frustrating.

Composio fixes this by keeping each Google BigQuery account separate and giving it a simple name, such as googlebigquery-1, googlebigquery-2, or googlebigquery-3. Claude can then use the right Google BigQuery account when you mention that name.

• One Composio connector in Claude
• Two or more Google BigQuery accounts connected behind it
• A clear name for each account
• The ability to work in the right Google BigQuery account from a single Claude chat

For example:

Search my googlebigquery-1 and googlebigquery-2 Google BigQuery accounts for anything that needs my attention from the last 7 days. Tell me which account each item came from.

Using the googlebigquery-1 account, run yesterday's sales summary query.

• A Claude account
• A free Composio account
• Access to each Google BigQuery account you want to connect

If you use Claude Free, you can have one custom connector. If you already use that slot, you will need to remove the existing custom connector first.

If you use Claude Team or Enterprise, an Owner may need to add the connector for the organisation. Each member can then connect their own accounts.

Step 1: Add Composio to Claude (one-time process)

1. Click the button below. This will take you to the Claude Custom Connector modal.

Add to Claude

2. Click Continue

3. In the next modal, click Add

4. It will take you to the authentication page. Sign in to Composio and approve the connection.

Then return to Claude and make sure Composio is enabled.

Step 2: Connect your first Google BigQuery account

In a new Claude chat, type:

Connect my googlebigquery-1 Google BigQuery account to Composio. Call it googlebigquery-1.

Claude will give you a sign-in link.

1. Click the link.
2. Sign in to your googlebigquery-1 Google BigQuery account.
3. Review and approve Google BigQuery's permission request.
4. Return to Claude.

Claude should confirm that the account is connected.

The name googlebigquery-1 is how Claude knows which Google BigQuery account to use. Choose short, obvious names. Good examples include:

• googlebigquery-1
• googlebigquery-2
• googlebigquery-3

Step 3: Connect your second Google BigQuery account

In the same Claude chat, type:

Connect another Google BigQuery account. Call it googlebigquery-2.

Claude will give you a new sign-in link.

1. Open the link.
2. Sign in to the second Google BigQuery account.
3. Review and approve Google BigQuery's permission request.
4. Return to Claude.

Claude should confirm that googlebigquery-2 is connected.

Important: Check that Google BigQuery is showing the second account before you approve access. If the wrong account appears, sign out or open the link in an incognito or private window.

Repeat this step for every other Google BigQuery account you want to add. Give each connection a short, descriptive name such as googlebigquery-1, googlebigquery-2, googlebigquery-3, or client-acme.

Step 4: Check your connected Google BigQuery accounts

Ask Claude:

List my connected Google BigQuery accounts in Composio. Show each account's name and connection status.

You should see every account you added, and each connection should show as ACTIVE.

For an extra check, ask:

Show the account email or ID and the account name for each connected Google BigQuery account.

This helps you confirm that every label points to the correct Google BigQuery account and that you did not connect the same account twice.

Step 5: Use the right Google BigQuery account

Mention the account name whenever you ask Claude to work with Google BigQuery. This is especially important when an action could change data.

Review activity across accounts

Check googlebigquery-1 and googlebigquery-2 for anything new in Google BigQuery from the last 14 days. Group the results by account.

Find top 10 customers by revenue

Using the googlebigquery-1 account, find top 10 customers by revenue.

Analyze traffic data for last quarter

Using the googlebigquery-2 account, analyze traffic data for last quarter.

Find something across accounts

Search all connected Google BigQuery accounts for customer@example.com. Show which account it appears in and summarise the latest activity.

For actions such as creating, changing, or deleting data, ask Claude to show you the planned action first and wait for your confirmation.

Add this to your Claude preferences or project instructions, replacing the examples with your own account names:

My Google BigQuery accounts are: googlebigquery-1 = my main account, googlebigquery-2 = my second account, and googlebigquery-3 = a client account. Always use the named account when I specify one. If I do not name an account, ask me which one to use. Before creating, changing, or deleting anything, show me the planned action and wait for confirmation.

If Claude's built-in Google BigQuery connector is also enabled, Claude may use it instead of Composio. For a clearer setup, turn off the built-in connector or explicitly tell Claude to use Google BigQuery through Composio.

The chat method is the quickest way to connect accounts. Use the dashboard when you want to add, rename, reconnect, or remove a connection.

1. Go to dashboard.composio.dev.

2. Sign in with the same Composio account you connected to Claude.
3. Open For You from the product switcher.
4. Find Google BigQuery.
5. Click Connect and complete the Google BigQuery authorisation flow.
6. Click Connect again to add another Google BigQuery account. Composio keeps it as a separate connection instead of replacing the first.
7. Give each connection a clear label, such as googlebigquery-1, googlebigquery-2, or googlebigquery-3.

If Google BigQuery opens the wrong account during authorisation, sign out first or use an incognito or private window.

From the dashboard, you can also:

• Rename a connection when a default label such as googlebigquery-2 is no longer useful.
• Disconnect or delete an account you no longer want Claude to access.
• Re-authorise an expired or revoked connection.