---
title: "BigQuery: ask your data warehouse questions · Adea"
description: "Adea reads your BigQuery datasets with a read-only service account and answers business questions in plain words, with the SQL shown."
url: https://adea.app/integrations/bigquery
---

# Ask your BigQuery data a question without writing the SQL.

Give Adea a read-only service account for the datasets you choose, and ask about revenue, behaviour or cost in plain words. The SQL is shown with every answer.

[Connect BigQuery](https://adea.app/signup) [Read the setup guide](https://adea.app/docs/connect-database)

You can connect BigQuery today.

## What Adea reads from BigQuery

- Datasets and tables the service account can view
- Event, order and customer tables, read with SELECT queries
- Table sizes before a query runs, so cost stays in view
- Partitioned tables, read by date to keep queries small

## How it connects

A read-only service account

[Read the setup guide](https://adea.app/docs/connect-database)

## What you can ask

You ask

How many active users did we have each week in September?

Adea answers

Between 41,200 and 46,800 a week, peaking in the week of the 15th. The weekly average was 43,950.

You ask

Which campaigns brought the most first-time buyers last month?

Adea answers

Spring Restock brought 1,870 first-time buyers, 29 percent of all of them. The next two together brought 2,140.

## Questions about BigQuery

### How does Adea connect to BigQuery?

You create a service account with viewer rights on the datasets you choose and give Adea its key. Adea checks that it cannot write before reading.

### Will Adea run up my BigQuery bill?

Adea reads only the datasets you allow and estimates a query before running it, so large scans do not come as a surprise.

### Can Adea change my tables?

No. The service account can only read, and Adea only runs SELECT queries.

## Coming from a BI tool on BigQuery?

[Adea vs Metabase](https://adea.app/vs/metabase) [Adea vs Power BI](https://adea.app/vs/power-bi) [Adea vs Looker Studio](https://adea.app/vs/looker-studio) [Adea vs Tableau](https://adea.app/vs/tableau) [Adea vs Mode](https://adea.app/vs/mode) [Adea vs Hex](https://adea.app/vs/hex) [Adea vs Sigma](https://adea.app/vs/sigma) [Adea vs Omni](https://adea.app/vs/omni) [Adea vs ThoughtSpot](https://adea.app/vs/thoughtspot) [Adea vs Databox](https://adea.app/vs/databox)

## Other sources like this

[Snowflake](https://adea.app/integrations/snowflake) [Amazon Redshift](https://adea.app/integrations/redshift) [ClickHouse](https://adea.app/integrations/clickhouse) [Databricks](https://adea.app/integrations/databricks) [All sources](https://adea.app/integrations)

## What do you want to know?

[Start free](https://adea.app/signup) [Book 20 minutes](mailto:hello@adea.app?subject=20%20minutes%20about%20Adea)