Skip to main content
DataDoe HubHub
(opens in a new tab)
ChatGPT (opens in a new tab)
Claude (opens in a new tab)

How to connect DataDoe to BigQuery

DataDoe can export your Amazon data directly to Google BigQuery. After you connect it, you can query, visualise, and build on your data. Use any BigQuery-compatible tool, such as SQL editors, Jupyter notebooks, or MCP-enabled AI assistants.

Step 1: Create a DataDoe BigQuery integration

  1. In the DataDoe app, go to Integrations → BigQuery.
  2. Select Create New Integration and follow the prompts to select your Google Cloud project and target dataset, then give the integration a name.

After you create it, DataDoe starts syncing your Amazon data to the BigQuery dataset.

Step 2: Authenticate with Google Cloud

Most tools that work with BigQuery, such as MCP Toolbox, Jupyter notebooks, and scripts, need local Google Cloud credentials. The easiest way to set them up is with the Google Cloud CLI.

Make sure the BigQuery API is enabled on your Google Cloud project. You can enable it in the Google Cloud Console (opens in a new tab) or ask your Google Cloud administrator to enable it.

Your Google Cloud account also needs the following roles on the project:

  • BigQuery Data Viewer (roles/bigquery.dataViewer)
  • BigQuery User (roles/bigquery.user)
  • Service Usage Consumer (roles/serviceusage.serviceUsageConsumer)

If you are unsure, ask your Google Cloud administrator to grant them.

Install Google Cloud CLI

Download and install it from cloud.google.com/sdk/docs/install (opens in a new tab).

After installation, run this command in your terminal to initialise the CLI:

bash
1gcloud init

A browser window will open. Sign in with your Google account and select the project that contains your BigQuery dataset.

Set up application-default credentials

Run the following command to create local credentials that applications can use to access BigQuery:

bash
1gcloud auth application-default login

This opens a browser window where you sign in, or select an account that is already signed in. It creates a credentials file on your machine that tools such as MCP Toolbox, Python clients, and Node.js clients pick up automatically.

Next steps

Your data is syncing and your credentials are set up. Pick a tool to start working with your data:

  • use MCP Toolbox to query BigQuery from AI assistants such as Cursor, Claude, and Windsurf
  • use Python Jupyter to explore and analyse your data in Jupyter notebooks