How do I load QuickBooks data into my warehouse?
QuickBooks exposes accounting records such as customers and invoices through its API. ingestr lands these into your warehouse with a single command.
Command
ingestr ingestDefined in
CLI
Works with
QuickBooks to any ingestr destination
What you get
QuickBooks API sourceno connector codeOAuth refresh token auth
How it works in code
$ ingestr ingest \
--source-uri 'quickbooks://?company_id=1234567890&client_id=cid&client_secret=csecret&refresh_token=rtoken' \
--source-table 'customers' \
--dest-uri $SNOWFLAKE_URI --dest-table 'quickbooks.customers'Run ingestr ingest and ingestr loads the QuickBooks data into your warehouse.
Related use cases
Load a specific source
Replicate a Postgres database into Snowflake
How do I replicate a Postgres database into Snowflake?
Load a specific sourceReplicate a database incrementally
How do I keep a database table in sync without full reloads (CDC-style)?
Load a specific sourceLoad Google Sheets into your warehouse
How do I load a Google Sheet into my warehouse?
Move data with one command
Open source. Source URI in, destination URI out, incremental by default.