Snowflake
What it is. A cloud data warehouse commonly used as the canonical store in composable CDP stacks.
Strengths in CDP context.
- Elastic compute — long-running complex queries complete (gated by cost rather than timeout).
- Consumption-based pricing — costs track actual usage.
- No vendor-imposed egress quotas; customer-controlled data movement.
- Healthy reverse-ETL ecosystem (Hightouch, Census, etc.) for activation.
What it does not provide out of the box.
- Identity resolution (must be built or sourced from a complementary tool).
- Real-time profile updates beyond what streaming + materialized views can deliver.
- Pre-built activation destinations (handled by reverse-ETL partners).
Egress costs and data transfer pricing. Cross-region data transfer in Snowflake is charged per byte: approximately $20/TB between US cloud regions, up to $140/TB between some Asia Pacific region pairs. Transfers within the same cloud provider region are free. For CDP architectures with multi-region data residency requirements (EU, APAC), cross-region Snowflake replication incurs these charges on each replication cycle.
Egress Cost Optimizer (ECO, April 2025). Snowflake's ECO uses intelligent caching to reduce cross-region replication costs by up to 96% for replication-heavy workloads. Organizations with replication-driven egress (versus query-driven egress) should evaluate ECO before sizing cross-region costs as prohibitive.
Relevant constraint: constraint.snowflake-egress-cross-region.
Cost model contrast with AEP. AEP's data mobility is quota-bounded (KB/profile/year per constraint.aep-second-gen-export-1500kb); Snowflake's is cost-bounded. In Snowflake, exports always succeed but scale in cost with volume; in AEP, exports fail when quota is exhausted. For tradeoff.cost-predictability, the Snowflake model favors consumption-based FinOps governance; the AEP model favors contract-bounded spend.
Where it fits. Organizations with mature data engineering, an existing CDW investment, and a preference for assembly over packaged offerings. Less suited to organizations with thin DE staffing or a strong preference for vendor-curated activation ecosystems.
Alternative-to. vendor.databricks, vendor.bigquery (peer cloud data warehouses); vendor.adobe-experience-platform (as the packaged-CDP alternative).