architecture decision
ADR-014: Use Snowflake for analytics exports
Curated commerce data products are exported to Snowflake for analytics workloads and BI access.
Decision RecordJanuary 16, 2025AcceptedWarehouse
Context
Analytics consumers need governed access to order, payment, and subscription data without reading from service databases.
Decision
Curated data products are exported to Snowflake. Service-owned databases remain operational stores and are not queried directly by BI tooling.
Consequences
Analytics workloads are isolated from operational systems. Data product owners must publish schemas and data quality expectations before export.