With database connectors, you grant Actuals query access to a warehouse (for example Snowflake or Google BigQuery). Actuals runs agreed queries and imports the results.
This is often preferred once external sharing is set up: less file handling, clearer sync ownership with your data engineers.
Supported platforms
Google BigQuerySnowflakeHow it fits the new app
- Agree tables, filters, and incremental sync with Actuals data engineering.
- Share connection details / credentials as directed by your implementation consultant.
- Actuals stores connector secrets under Import › Setup › Credentials where applicable.
- Sources appear under Import › Setup › Sources; ingested data shows in Import › Files / Raw Data Explorer.
Synchronization
Discuss with Actuals:
- Which tables or views?
- Can rows change after sync?
- How are creates / updates / deletes represented?
Preferred: event-sourced (or append-only) data shared incrementally.
Related
- Data integration hub — preferred method order
- Import › Setup — Credentials and Sources
Contact your implementation consultant to enable a database connector for your administration.