Analytics warehouse architecture
Lake, warehouse and BI, with archival storage for anything older than the retention window.
AWSwarehousebiglacierreporting
What is in it
Every resource, and what it costs.
Projections from August 2026 list prices for always-on resources. Connect an account and these become the figures your provider actually bills.
| Node | Type | What it is | Projected |
|---|---|---|---|
| S3 data lake | Storage | 1 TB standard | $24/mo |
| dbt runner ×2 | Compute | 2 × 0.25 vCPU · 0.5 GB | $18/mo |
| Redshift Serverless | Database | 8 RPU · ~25 h/month | from $75/mo |
| BI tool (external) | External | Existing subscription | no direct cost |
| S3 Glacier (archive) | Storage | 1 TB deep archive | from $1.00/mo |
Every figure is a projection from AWS list prices, before anything is built. 2 rows show from because those services bill by usage, so the total is a scenario at the stated volumes, not a quote.
Related
Similar templates.
Nightly batch ETL
Scheduled extract and load from source systems into a lake, then modelled into a warehouse.
EventBridge busLambdaS3 data lakeECS Fargate task ×2+2
from $145/mo projected6 nodes
Streaming ingest
Events land on a stream, are enriched in flight, and are written to both a lake and a search index.
API GatewayKinesis Data StreamLambdaS3 data lake+2
from $92/mo projected6 nodes
Open Analytics warehouse on the canvas.
It loads as an editable graph. Ask Archie to change it, then approve the plan and it is built in your own AWS account.