BigQuery reports
and dashboards
Bring your BigQuery data into Filament. Create dashboards, build reports and explore your questions in plain English.
Your BigQuery data, connected.
BigQuery holds the tables your team has built, but putting them next to the rest of your data usually means another export or more SQL.
Filament replicates the BigQuery tables you choose straight into your warehouse, so you can explore them and join them to your other connected tools in plain English.
Data we sync
Selected TablesExample fields: All table columns, first synced at
The full rows of each BigQuery table you choose, replicated into your warehouse with their original columns and types. STRUCT, ARRAY and JSON fields are stored as JSON.
all table columns_first_synced_at
BigQuery works well with
Google Ads
Join replicated BigQuery tables with Google Ads campaign data to see how spend relates to the metrics you model in your warehouse.
Salesforce
Combine replicated BigQuery tables with Salesforce records to connect warehouse data to pipeline stages and deal outcomes.
Stripe
Bring replicated BigQuery tables together with Stripe transactions to compare revenue against the segments you build in your warehouse.
See the
whole picture.
Filament brings your apps together in a managed warehouse. Build dashboards, share reports and ask questions in plain English.
Explore the demo dashboard
$118,050 of $245,000
194 of 250
Trusted by the best
“Filament has been a game-changer. Everyone can self-serve and get answers on demand. The integrations are plug-and-play, and we've even cancelled our data warehouse plans — Filly does it all.”
“Filament has supercharged our efficiency and levelled up our outputs. Beyond time savings, the mental offload has been priceless, and I can focus on growth, not grind!”
Your questions, answered.
How do I connect BigQuery?
You need a Google Cloud project with the BigQuery API enabled, and permission to create a service account and JSON key. Use a dedicated account with BigQuery Job User on the project and BigQuery Data Viewer access to the datasets you want to sync.
Prepare the service account
- In Google Cloud Console, select your project. Under APIs & Services → Library, find and enable BigQuery API if needed.
- Open IAM & Admin → Service Accounts → Create service account. Name the account and grant BigQuery Job User on the project.
- In BigQuery, select each required dataset and use its Sharing → Permissions controls to grant BigQuery Data Viewer to the service account’s email address.
- Return to the service account and open Keys → Add key → Create new key. Choose JSON, create the key and keep the downloaded file private. If your organisation blocks key creation, ask your Google Cloud administrator to review the policy.
Connect in Filament
- Open Apps in Filament and add BigQuery.
- Paste the complete service account JSON key. Filament verifies it before saving.
- Choose a dataset and the tables to replicate. Only stored tables are listed; views and external tables are excluded.
- Add any useful context about your data and complete setup.
What does Filament sync from BigQuery?
The full contents of the tables you select from a dataset, every row and column, replicated into your Filament warehouse. It does not sync query history, jobs, or billing data.
How often does it sync, and is it incremental?
Once a day by default. Each sync is a full reload, so the warehouse copy matches the source table as of the last run.
Can I choose which tables to sync?
Yes. You pick a dataset and select the specific tables you want. Views and external tables are not listed, since only tables with stored data can be replicated.
Does syncing run up BigQuery query costs?
No. Filament reads table data directly rather than running SQL queries, so it does not incur BigQuery bytes-scanned query charges.
What happens if a BigQuery table is too large?
Tables above the per-table reload limit fail the sync instead of loading a partial copy. Select a smaller or filtered source table, or contact Filament about the limit.