Connect Google BigQuery to Actuals with a service account so Actuals can query agreed tables (read-only).
Prerequisites
Administrator rights in your BigQuery / Google Cloud project.
Create a service account key
- Sign in to the Google Cloud console.
- Enable the BigQuery API if needed: BigQuery API library.
- Open Service accounts, select your BigQuery project, then Create service account.
- Use a clear name, for example
ActualsPlatformBigQuery_[yourcustomername]. Choose Create and continue.
- Grant a BigQuery role with read-only access to the tables Actuals needs. Continue, then Done.
- Open the new service account → Keys → Add key → Create new key → JSON → Create.
- Save the JSON key file and share it with your Actuals implementation consultant.
Best practices
- Prefer least privilege: read-only, only the tables required for the setup.
In the new app
After Actuals configures the connector:
- Secrets may appear under Import › Setup › Credentials
- Feeds under Import › Setup › Sources
- Ingested data under Import › Files / Raw Data Explorer
Agree incremental sync (tables, change detection) with Actuals data engineering first — see 3. Database connectors.