Data connector

Send BigQuery data to AI, reports, spreadsheets and ETL

Get started for free

No credit card required | 14 days | 10 million records | 30 pipelines

sso google logo
Sign up with Google
sso facebook logo
Sign up with Facebook
sso microsoft logo
Sign up with Microsoft
sso linkedin logo
Sign up with Linkedin

or sign up with your email

By signing up, you agree to Kondado’s Terms of service and Privacy policy

BigQuery

BigQuery is where many companies keep their most valuable records: transactional history, product usage events, marketing performance data, financial movements, operational logs and customer behavior. With Kondado you can centralize that BigQuery data and turn it into BigQuery analytics your team actually uses, from revenue and margin tracking to cohort retention, funnel conversion and demand forecasting. Instead of rebuilding spreadsheets by hand, you bring the datasets that matter and let Kondado keep them current on a schedule you define.

You choose what to bring

Bring your BigQuery tables in, exactly as they are

There is no fixed list of tables: you choose exactly what to bring (tables and views from your dataset) and Kondado keeps the same structure as your data.

Illustrative example
Dataset: marketing
  • campaigns
  • daily_costs
    datechannelcampaigncost
  • conversions
  • vw_cac_by_channel

The tables and views you choose arrive with the same column names.

Automatic updates: Kondado refreshes the data on the schedule you choose, from every 5 minutes to daily.

Ask the AI in Claude or ChatGPT
Which channel had the lowest cost per conversion last quarter?
How did daily cost evolve over the last 8 weeks?

Ask in natural language in Claude or ChatGPT, through Kondado's MCP server.

And to follow it every day: a dashboard in Power BI or Looker Studio, no database needed. Power BI · Looker Studio

If you prefer, also send it to a spreadsheet (Google Sheets, Excel) or to your own database or data warehouse (BigQuery, PostgreSQL, MySQL).

Try out all the features for free for 14 days

Kondado connects to BigQuery with Google Account OAuth authorization plus your Project ID and Dataset ID, and no IP whitelisting is needed. You choose exactly which tables and views of the dataset, with their own columns, to bring, and Kondado keeps the same structure of your data, with your own names for tables and views and their columns, updated automatically on a configurable schedule.

Data analysts, marketing teams, finance and RevOps use Kondado to centralize BigQuery data and build BigQuery analytics without extra engineering work. Through Via Kondado, the data feeds dashboards in Power BI and Looker Studio straight away, with no database of your own required. The same data is ready for natural language questions in Claude or ChatGPT, once you add Kondado’s MCP server and authorize it. Product managers can ask about activation trends while finance checks revenue by channel, all from the same updated source.

The Kondado platform takes care of refreshing BigQuery data, allowing you to stop wasting time with manual work and complex workflows, and focus on analyzing BigQuery data with AI (Claude, ChatGPT and MCP) or in your report, spreadsheet, data warehouse, data lake, or database

Try out all the features for free for 14 days

Turning BigQuery data into answers and dashboards starts with making it easy to reach. Once your BigQuery data arrives through Via Kondado, Power BI and Looker Studio can show revenue by channel, customer acquisition cost, average order value, retention by cohort or conversion by stage, without any database of your own in between. Teams track monthly recurring revenue, order volume, refund rates and campaign performance side by side in the same view. In Claude or ChatGPT, through Kondado’s MCP server, you can ask which product line grew fastest last quarter or which region missed its margin target, and get an answer in plain language. Combining BigQuery data with other sources connected in Kondado opens cross-platform analysis, for example matching warehouse revenue figures with advertising spend or CRM opportunities. Because Kondado updates the data on the schedule you configure, those dashboards and answers stay current.

How to visualize BigQuery data in 3 steps

Connect BigQuery to AI (Claude/ChatGPT via MCP), dashboards, spreadsheets, or databases — no code required.

1
Connect BigQuery and choose data

Authorize with your Google Account, enter your Project ID and Dataset ID, then choose exactly which tables and views of the dataset, with their own columns, you want to bring.

2
Choose where to use it

Via Kondado feeds dashboards in Power BI and Looker Studio and questions in Claude or ChatGPT, with no database of your own. If you prefer, send the data to Google Sheets, Excel, or a database or data warehouse such as BigQuery, PostgreSQL or MySQL.

3
Build dashboards and ask questions

Build your dashboard in Power BI or Looker Studio, or ask the AI in Claude or ChatGPT about your own data. Kondado keeps everything updated automatically on the schedule you configure.

Try out all the features for free for 14 days

Hundreds of data-driven companies trust Kondado
arezzo
brf
Contabilizei
dpz
Experian
grupo_soma
multilaser
olist
unimed
v4_company
webmotors
yooper

Pick an AI, Spreadsheet, Database, Data Warehouse or Data Lake to use BigQuery data

Choose a tool to visualize your BigQuery data

If the software you need is not listed, drop us a messagem. You can use almost every tool

Frequently Asked Questions (FAQ)

Find answers to common questions about connecting BigQuery to AI (Claude/ChatGPT via MCP), dashboards, spreadsheets, and databases

What do I need to connect BigQuery to Kondado? ▼
You authorize with your Google Account through OAuth and provide your Project ID and Dataset ID. After that, you select exactly which tables and views of the dataset, with their own columns, you want to bring. Kondado then reads that structure and keeps it updated on your schedule.
Do I need to whitelist IP addresses to connect BigQuery? ▼
No. The connection runs cloud to cloud, so there is no IP whitelisting step. You complete the Google Account authorization and enter your Project ID and Dataset ID, and the pipeline is ready to be configured.
Can I choose which tables and views of my BigQuery dataset are brought? ▼
Yes. BigQuery has no fixed schema, so every company has its own tables and views with their own columns. You pick exactly the ones you want, and Kondado keeps the same structure with your own names for tables and views and their columns.
How often does Kondado update the BigQuery data? ▼
You set the schedule for each pipeline, from every 5 minutes to once a day. Kondado refreshes the selected tables and views automatically at that interval. This keeps dashboards and AI answers aligned with the latest state of the data you chose.
Can I combine BigQuery data with other sources in Kondado? ▼
Yes. You can add other data sources in Kondado and analyze them alongside your BigQuery data, for example comparing warehouse revenue with advertising spend or CRM opportunities in one view. If you prefer, you can also send the result to Google Sheets, BigQuery or PostgreSQL.
How do I ask questions about my BigQuery data in Claude or ChatGPT? ▼
You add Kondado's MCP server in Claude (Web or Desktop) or in ChatGPT and authorize once with OAuth, with no token and no code. Then you ask questions in natural language about your own data. The AI does not change the data in the source and does not execute actions in your systems.
Can I build Power BI or Looker Studio dashboards from BigQuery without my own database? ▼
Yes. Via Kondado connects your BigQuery data straight to Power BI and Looker Studio, with no database of your own needed. You build custom dashboards on the tables and views you selected, and Kondado keeps them updated on your schedule.
Do I need to work with the BigQuery API to connect? ▼
No. You do not write code or call the BigQuery API directly. Kondado reads the structure of the tables and views you select once the Google Account authorization, Project ID and Dataset ID are in place.

Try out all the features for free for 14 days