← All components
Analytics & processing
Data warehouse / OLAP
Columnar store for analytical queries across large historical datasets.
When to use
- Business reporting, experimentation, offline feature generation
Pitfalls
- Not for user-facing low-latency reads
Options by provider
The first option is what diagrams show for that provider.
Amazon Web Services
- Amazon RedshiftManaged
- Amazon AthenaManaged
Google Cloud
- BigQueryManaged
Microsoft Azure
- Microsoft FabricManaged
- Azure Synapse AnalyticsManaged
Open source / self-hosted
- ClickHouseSelf-hosted
- Apache DruidSelf-hosted
- TrinoSelf-hosted
Used in
- URL shortener
- Click analytics — Aggregated stats per link
- Driver booking & fleet management
- Fleet analytics — Utilisation and performance reports
- Buy now, pay later
- Risk analytics — Portfolio and model training data