[mritchie712]

we've built a business[0] around this workflow, but in cases where the source data isn't as simple as a CSV. Think Stripe, Hubspot, Salesforce, etc. where you'd normally need to write a ton of API calls or buy something like Fivetran. The flow for Definite is:

1. Add your sources (Postgres, S3, CRM, Quickbooks, Google Sheets, etc.)

2. We deploy standard, pre-baked data models (e.g. how do you calculate ARR using Stripe data)

3. AI answers questions using the standard models and starts updating the model with SQL for anything that's not already answered.

We spin up a datalake to store all the data (similar to this one[1]) for our customers, so it's very cost effective.

0 - https://www.definite.app/

1 - https://www.definite.app/blog/cloud-iceberg-duckdb-aws