Connect BigQuery to clariBI
Warehouse-scale analytics in plain English. Browse your GCP projects, select datasets and tables, and build interactive dashboards without writing a single line of SQL.
OAuth-secured with bigquery.readonly and cloudresourcemanager.readonly scopes. Local caching to minimize BigQuery scan costs, plus 440+ ready-to-use analysis templates.
What is BigQuery?
Google BigQuery is a serverless, highly scalable data warehouse designed for fast SQL analytics over massive datasets. Companies use it to centralize data from multiple sources - marketing platforms, product event streams, financial systems, IoT devices - and run analytical queries that would be impractical on traditional databases.
BigQuery can process petabytes of data in seconds, but accessing that power typically requires SQL expertise and familiarity with BigQuery's pricing model (you pay for the amount of data scanned by each query). This creates a bottleneck: the data is there, but only engineers and analysts who know SQL can use it.
clariBI connects to BigQuery via OAuth with bigquery.readonly and cloudresourcemanager.readonly scopes. It lists your GCP projects, lets you browse datasets and tables, and syncs selected tables locally. Once synced, clariBI's AI engine makes every column and row available for natural-language querying, dashboard generation, and automated insight reports.
Because clariBI caches data locally after the initial sync, your team can run unlimited queries and build unlimited dashboards without incurring additional BigQuery scan charges. The sync itself uses a single read query per table, keeping your BigQuery costs predictable.
Learn more about BigQuery at cloud.google.com/bigquery →How to connect BigQuery to clariBI
The entire setup takes under five minutes. You need a Google account with BigQuery Data Viewer (or equivalent) access on the project you want to query.
Authorize your Google account
From your clariBI workspace, navigate to Data Sources and click + Add Data Source. Select BigQuery from the list. clariBI will open a Google OAuth consent screen requesting bigquery.readonly access via incremental OAuth. Approve the permissions to continue.
Select your GCP project
clariBI uses the cloudresourcemanager.readonly scope to list the GCP projects your account has access to. Pick the project containing the BigQuery datasets you want to analyze.
Choose datasets and tables
Browse your BigQuery datasets and select the specific tables you want to sync. You can pick individual tables or sync entire datasets. clariBI shows you table schemas, row counts, and sizes before you commit.
Data syncs and caches locally
clariBI queries your BigQuery tables and caches the data locally for fast, interactive analysis. This single sync query is the only BigQuery scan cost you incur. Subsequent queries and dashboards run against the local cache.
Ask questions in plain English
Your BigQuery data is now available for conversational analytics, 440+ analysis templates, and auto-generated dashboards. Ask "What's our total revenue by region for Q1?" and get an instant, chart-ready answer.
What you can analyze
Once connected, every synced BigQuery table becomes a data source for clariBI's full suite of analytics features.
-
Any BigQuery table or view
Standard tables, partitioned tables, and views are all supported. clariBI reads schema metadata and data types automatically.
-
Cross-dataset analysis
Sync tables from multiple BigQuery datasets and analyze them together in a single clariBI dashboard.
-
Petabyte-scale data
BigQuery handles the heavy lifting. clariBI syncs the data you need and makes it available for fast, interactive querying.
-
Read-only access (no data modification)
clariBI only reads from your BigQuery tables. The readonly OAuth scope makes it technically impossible to modify your warehouse data.
-
440+ pre-built analysis templates
Finance, marketing, product, operations - choose from 440+ templates across 30 business categories and apply them to your BigQuery data.
-
Automated dashboard generation
After syncing, clariBI auto-generates a starter dashboard from your most important tables - ready to share with your team in seconds.
-
Combine with other data sources
Mix BigQuery data with Google Ads, Google Sheets, database, or file-based data sources in a single unified dashboard.
-
Export results as PDF, CSV, or Excel
Generate polished reports from your warehouse data and export them in the format your stakeholders prefer.
Connection details
Reference these parameters when configuring your BigQuery connection in clariBI. Authentication is handled entirely through Google OAuth - no service account JSON files needed.
| Parameter | Value / Notes |
|---|---|
| OAuth scopes |
bigquery.readonly +
cloudresourcemanager.readonly
|
| Token management | OAuth 2.0 refresh tokens stored with Fernet encryption; automatic token renewal via incremental OAuth |
| API version | BigQuery API v2 + Cloud Resource Manager API v1 |
| Auth method | Google OAuth 2.0 incremental consent flow (no service account JSON files required) |
| Access model | Read-only; clariBI never writes to, modifies, or creates BigQuery resources |
Use cases
BigQuery powers some of the most data-intensive workloads in modern business. clariBI makes that data accessible to every team member.
Data Warehouse Reporting
Query your centralized data warehouse in plain English. Get instant answers from tables that would take minutes to query manually with SQL. Share dashboards with stakeholders who do not know SQL.
Marketing Analytics
Analyze marketing data pipelines that land in BigQuery from Google Analytics, Google Ads, and third-party ETL platforms. Track campaign performance, attribution, and ROI across channels.
Product Analytics
Query event-level product usage data stored in BigQuery to understand feature adoption, conversion funnels, and user retention. Build dashboards that product managers can explore without SQL.
Financial Analysis
Run revenue reconciliation, cost analysis, and financial reporting across large transaction datasets. Ask "What is our gross margin by product line for Q3?" without writing SQL.
Cross-Source Analysis
Combine BigQuery data with Google Ads, Google Sheets, or database data in clariBI for unified cross-platform dashboards. Break down data silos without ETL engineering.
Executive Dashboards
Build self-service dashboards for executives and stakeholders who need warehouse insights but do not know SQL. Share live dashboards that update automatically on a schedule you define.
Security & requirements
Warehouse data demands careful handling. Here is how clariBI protects your BigQuery connection and what you need to get started.
Security measures
-
OAuth 2.0 with minimal scopes
clariBI requests only
bigquery.readonlyandcloudresourcemanager.readonly. No write or admin permissions are ever requested. -
Encrypted token storage
OAuth refresh tokens are stored with Fernet symmetric encryption at rest. The encryption key is managed separately from the data store.
-
Read-only access guaranteed
clariBI never writes to BigQuery. The readonly OAuth scope makes it technically impossible to modify, delete, or create tables in your warehouse.
-
Local caching minimizes scan costs
Data is synced once and cached locally. Subsequent queries run against the local cache, not BigQuery, so you do not incur repeated scan charges.
-
Audit logging
All BigQuery sync events and data access are logged in clariBI's audit trail, visible to workspace administrators at any time.
Prerequisites
-
GCP project with BigQuery
You need a Google Cloud Platform project with BigQuery enabled and at least one dataset containing tables you want to analyze.
-
BigQuery Data Viewer role
Your Google account must have the BigQuery Data Viewer role (or equivalent) on the project and datasets you want to query. This is the minimum required IAM permission.
-
BigQuery costs
BigQuery charges for data scanned by queries. clariBI syncs data once and caches it locally, minimizing repeated scan costs. Standard BigQuery on-demand pricing applies to the initial sync.
-
Table size considerations
Very large tables (billions of rows) can be synced but may take longer and incur higher BigQuery scan costs. Consider syncing a subset of columns or using date-partitioned tables.
-
No software installation
Everything runs in the browser. No extensions, plugins, service account files, or desktop software required on your end.
Pricing & availability
BigQuery integration is included on all paid clariBI plans and the free 14-day trial. No extra fees, no per-query charges from clariBI (standard BigQuery scan pricing applies separately).
Annual billing saves up to 17% • All plans include unlimited dashboards, reports, and data source connections within your plan's limits • See full pricing details
Connect BigQuery in minutes
Start your free 14-day trial and have your first BigQuery-powered dashboard live today. No credit card required.
440+ analysis templates • OAuth read-only access • Local caching to minimize costs • All paid plans from $99/month