Data warehouse integration
Dear CFO for BigQuery
Bring the data your team already keeps in BigQuery into the same reports as your accounting, without moving your warehouse.
Limited to the roles you give the service account.
BigQuery
What you can do
What BigQuery data does inside Dear CFO
Your warehouse, next to your books
Save a query once and its results join QuickBooks, Xero and your other sources in reports, metrics and the AI analyst.
Read live, or copy on a schedule
Query your project live, or copy results on a schedule so they can be joined with everything else.
You stay in control
Queries run in your own project, under a service account with only the roles you grant.
What syncs
What Dear CFO reads from BigQuery
There is no fixed list: every query you save becomes a table, read live from your project or copied on a schedule.
In full, Dear CFO copies the results of the queries you save. Your project stays yours; we copy the rows those queries return into your warehouse, so the contents are entirely up to you. How it is stored and protected is in our privacy policy.
How to connect
Set up in a few minutes
- 1Create a service account in Google Cloud with the BigQuery Data Viewer and BigQuery Job User roles.
- 2In Dear CFO, open Integrations, choose BigQuery, and enter your project ID, the service-account key and a default dataset.
- 3Save the queries you want to use. Each one becomes a table you can report on.
- Connection
- A service-account key for your Google Cloud project
- Access
- Only the roles you give the service account (Data Viewer and Job User)
- Sync
- Daily by default, or hourly, every 6 hours or every 12 hours, for copied queries.
- Accounts
- One BigQuery project per company
- Where it shows up
- Reports, metrics, dashboards and the AI analyst, joined to your other sources
Questions
BigQuery and Dear CFO
Who pays for the queries?
Queries run in your own Google Cloud project and are billed there. Each copy is dry-run first and size-limited.
Does my data have to leave BigQuery?
No. You can read it live from your project. Copying is only needed to join it with other sources on a schedule.
What access does Dear CFO need?
A service account with BigQuery Data Viewer and BigQuery Job User, nothing more.
Works well with
Connect the rest of the stack
What you can do with it
Connect BigQuery and see it against your own numbers.
Create a login and connect in minutes, or book a call and we will walk through it with your business in mind.