QuickBooks integration
QuickBooks data, in your warehouse.
A built-in ingestr connector: add credentials, pick tables, schedule it.
name: raw.customers
type: ingestr
parameters:
source_connection: quickbooks
source_table: 'customers'
destination: snowflake
incremental_strategy: merge$ bruin run assets/raw/quickbooks.asset.yml
- extract · QuickBooks customersincremental
- load · snowflake raw.customersmerged
- checks · not_null, unique
Loaded and checked. Downstream models can run.
How it connects
Connected in three steps.
Accounting software platform providing financial management, bookkeeping, and business accounting solutions for small and medium businesses.
- 01
Add a QuickBooks connection with its credentials.
- 02
Pick the tables to load and how: replace, append or merge.
- 03
Bruin runs it on your schedule and checks every load.
Connection parameters
- client_id
- QuickBooks app client ID
- client_secret
- QuickBooks app client secret
- refresh_token
- OAuth2 refresh token
- company_id
- QuickBooks company ID
- sandbox
- Use sandbox environment (true/false)
Tables
6 tables, ready to load.
customersvendorsitemsinvoicesbillspayments
Step-by-step
Pick a destination.
QuickBooks → Snowflake
Read the guide
QuickBooks → Google BigQuery
Read the guide
QuickBooks → Databricks
Read the guide
QuickBooks → Amazon Redshift
Read the guide
QuickBooks → PostgreSQL
Read the guide
QuickBooks → ClickHouse
Read the guide
QuickBooks → DuckDB
Read the guide
QuickBooks → MotherDuck
Read the guide
The platform
Part of the Bruin platform.
Data in, ready for everything downstream: the models, the checks, the lineage and the AI layer.
Sources
DatabasesWarehousesApps & APIsFiles & storageStreams & webhooksWeb scrapingMove
Data IngestionFinance & accounting
More tools, same category.
Frequently asked
Questions about QuickBooks.
Does Bruin have a built-in QuickBooks integration?
Yes. Built-in ingestr source.
Which QuickBooks tables can Bruin load?
customers, vendors, items, invoices, bills, payments.
Where can QuickBooks data go?
Snowflake, BigQuery, Databricks, Redshift, ClickHouse, Postgres, DuckDB, MotherDuck, Microsoft Fabric and more, plus files on S3 and GCS.
How fresh is the data?
As fresh as your schedule. Incremental loads append, merge or replace a time window, every few minutes if you like.
Do we need Bruin Cloud?
No. The Bruin CLI and ingestr run locally, in CI or in your own orchestrator. Bruin Cloud adds scheduling, lineage, alerts and the AI data analyst on top.
Ready to connect QuickBooks?
$100 in credits and 50 AI tasks. No credit card.
A demo walks through your own data.