Warehouses
BigQuery integration
Turn your BigQuery datasets into product and revenue dashboards in plain language.
Flitch is an AI BI tool that connects to BigQuery and turns your tables into shareable dashboards. Flitch reads your Google serverless warehouse read-only through OAuth or a service account, so you can build product analytics, retention and revenue dashboards from your BigQuery datasets and tables without writing a single query.
- Google OAuth or service account
- Query datasets and tables
- Schedule background refresh
How do you connect BigQuery to Flitch?
Connect with Google OAuth or a service account. Read-only.
Generate a dashboard
Pick a prompt to get started.
BigQuery integration FAQ
How do I connect BigQuery to Flitch?
Connect with Google OAuth or a service account. The link is read-only, letting Flitch query your BigQuery datasets and tables without changing anything in your project.
Can Flitch build dashboards from BigQuery without SQL?
Yes. Describe what you want in plain language and Flitch builds the charts and KPIs. You can also write custom SQL when you need to shape the query yourself.
Does Flitch support a BigQuery service account?
Yes. Alongside one-click Google OAuth, you can connect with a service account for shared or team-owned projects. Access stays read-only either way.
How does Flitch refresh BigQuery data?
Set a background refresh schedule and Flitch re-queries your datasets on that cadence, so your dashboards update as the underlying tables change.
Can I pick which BigQuery tables to import?
Yes. You choose the datasets and tables that matter, or write custom SQL, so you only bring in the data you actually want to chart.
Does Flitch copy my BigQuery data?
No. Flitch queries BigQuery where it sits and pushes the aggregation down as SQL, so it reads back totals rather than holding a copy of your tables. Nothing to keep in step, nothing extra to secure, and a large table stays your database's problem rather than something Flitch has to store. The queries are generated against your data model, so a figure means the same thing on every dashboard built from it.
More in Warehouses
Not the source you're after?