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.