Case 1 · cost model
What does the data warehouse itself cost?
A cloud warehouse, a connector pulling each office’s practice software data every night, and BI licenses for the people who read the dashboards. These bills renew every year.
| Line | 10 offices | 50 offices |
|---|---|---|
| Cloud warehouse computeAssumption: an XS warehouse 4 hours a day (10 offices) or a Small one 6 hours a day (50 offices) for nightly loads and dashboards. 1 or 2 credits an hour x $2.00 x 365. | $2,920 | $8,760 |
| Warehouse storageAssumption: 1 TB (10 offices) or 3 TB (50 offices) x $23.00 x 12 months. | $276 | $828 |
| Ingestion connectorsAssumption: each office's practice software database is one source, priced like the average source in Fivetran's own example ($511.15 for four, so $127.79 a month) x 12. | $15,335 | $76,674 |
| BI licensesAssumption: one user per office plus leadership, 15 or 65 users x $14.00 x 12. | $2,520 | $10,920 |
| Practice software data accessFees vary by practice software vendor and are not always published, so they are not counted here. | Not counted | Not counted |
| Per year | $21,051 | $97,182 |
Sources
- Snowflake Service Consumption Table, effective September 30, 2026. Standard warehouse: XS 1 credit per hour, S 2 credits per hour; On Demand Standard edition $2.00 per credit and storage $23.00 per TB per month (AWS US East).
- Fivetran pricing, accessed September 30, 2026. Published Standard plan example: four sources, $511.15 per month.
- Microsoft Power BI pricing, accessed September 30, 2026. Power BI Pro $14.00 per user per month, paid yearly.
- Open Dental fee schedule, accessed September 30, 2026. Lists the software fee per location; no API fee is published.


