Connect BigQuery to clariBI
Sign in with Google, pick a project, dataset and table, or write a SELECT query, and clariBI syncs the rows as a dataset next to your other sources.
| Connection | Built in. Sign in with Google and approve read-only BigQuery access. |
| Data | Rows from one table (SELECT * with a row cap), or the result of a SELECT query you write |
| Row cap | 5,000 rows per sync by default; you can set 100 to 50,000 |
| Guard | Queries with write statements (INSERT, UPDATE, DELETE, CREATE and others) are refused |
| Sync | When the data is more than a day old, clariBI syncs it again before a question, dashboard refresh or report uses it. You can also press Sync now. Each sync runs the query again, and BigQuery bills it to your project. |
| Plans | Every plan, including Free, within its data source limit. Asking questions in plain English needs the trial or Starter and above. |
About BigQuery
BigQuery is Google Cloud's data warehouse. Teams keep event exports, billing data and modelled tables there and query them with SQL.
clariBI connects with the bigquery.readonly scope and runs your query through the BigQuery API. It reads every page of the result.
Vendor site: cloud.google.com/bigquery
What clariBI syncs
With a table picked, clariBI runs SELECT * on it up to the row cap. A query of your own overrides the table, so you can aggregate in SQL: a daily or weekly summary fits the cap and is quicker to chart than raw events.
With only a dataset and no table or query, clariBI lists the dataset's tables (ID, type, created and expiry time) without reading their rows.
How to connect BigQuery
Sign in with Google
In clariBI, open Data Sources > Add Data Source and pick BigQuery. Approve read-only BigQuery access.
Pick the data
Choose the Google Cloud project and dataset, then a table, or write a SELECT query in standard SQL instead. Set the row cap (5,000 by default). clariBI checks that a query only reads before running it.
Use the dashboard
clariBI syncs the rows, builds a dashboard for them, and reads them again on each later sync.
Questions you can ask
Asking in plain English uses AI credits, so it needs the trial or a Starter, Professional or Enterprise plan. Totals and trends are computed from the synced rows; the AI plans the question, picks the chart and writes the explanation.
- "How do weekly signups in our BigQuery events table line up with Stripe revenue?"
- "Which product areas in the usage summary grew fastest this quarter?"
About the BigQuery connector
Who pays for the query?
BigQuery bills each read to your Google Cloud project, as it would for any query. A SELECT * scans the whole table even with a row cap, so a summary query is cheaper on large tables.
Can clariBI change my data?
No. The scope is read-only and clariBI refuses queries that contain write statements.
Which clariBI plans include BigQuery?
Every plan can connect it, within its data source limit: 3 on Free, 5 on Lite, 10 on Starter, 50 on Professional and 100 on Enterprise. Each source gets an automatic dashboard on every plan. Asking questions in plain English and AI reports need the trial or a Starter, Professional or Enterprise plan.
Try BigQuery in clariBI
The trial lasts 14 days, includes 50 AI credits and needs no card. When it ends, your account moves to the Free plan and keeps its data and dashboards.