Warehouse And Lakehouse — hobby stack.
For each requirement below, pick the option that fits your build — recommended first, then free and cheaper alternatives — or skip what your project doesn't need. Tap the info icon next to any requirement to see why it matters.
Warehouse Compute Primary
Where your code actually runs and serves requests. Picking the right host affects speed, scaling, and how much ops work you do.Pricing & free-tier limitsFREE: Snowflake $400 trial credits (14d), DuckDB unlimited local. PAID: Standard $2.00/credit, Enterprise $3.00/credit; XS=1 cr/hr (~$2/hr), S=2 cr/hr ($4/hr), M=4 cr/hr ($8/hr). Billed per-second min 60s. Overage $2-3/credit. Free: 0 after trial.
Lakehouse Storage Format (Delta / Iceberg / Hudi)
Where you keep files users upload or you serve — images, videos, documents — and how fast they reach visitors around the world.Pricing & free-tier limitsFREE: OSS unlimited tables, Apache 2.0 license, local. PAID: Databricks runtime included in DBU $0.40/DBU (SQL Compute). Onehouse $0.35/vCPU/hr + $500/mo min cluster. Storage separate. Free tier: OSS unlimited, managed 14d trial.
Object Storage for Lakehouse (S3 / R2 / GCS)
Where you keep files users upload or you serve — images, videos, documents — and how fast they reach visitors around the world.Pricing & free-tier limitsFREE: R2 10GB storage/mo, 10M Class A ops/mo, zero egress; MinIO unlimited self-hosted. PAID: S3 $0.023/GB/mo first 50TB, $0.005/1k PUT, $0.0004/1k GET, egress $0.09/GB. R2 $0.015/GB/mo, no egress. Overage linear.
Data Lake Catalog / Metastore
A piece of your stack you may or may not need, depending on scope. Pick the option that fits — or skip it if your project doesn’t require this capability yet.Pricing & free-tier limitsFREE: Hive Metastore unlimited self-hosted, Glue first 1M requests/mo free + 1M objects free. PAID: Glue $1.00/100k requests after free, Unity Catalog included with Databricks $0.40/DBU, Tabular $0/until $0.05/10k API calls, $349/mo starter. Overage $1/100k req.
Query Engine / Federation Layer
A piece of your stack you may or may not need, depending on scope. Pick the option that fits — or skip it if your project doesn’t require this capability yet.Pricing & free-tier limitsFREE: Trino OSS unlimited, self-hosted, 0 license. PAID: Starburst Galaxy $0 free dev 25$ credit, then $1.20/CPU-hr ($0.30/ECU-hr), Enterprise $3,000/mo min. Dremio $0.80/vCPU/hr. Free tier: 1 cluster paused after 7d inactivity.
ETL / ELT Ingestion into Warehouse
A piece of your stack you may or may not need, depending on scope. Pick the option that fits — or skip it if your project doesn’t require this capability yet.Pricing & free-tier limitsFREE: Airbyte OSS unlimited connectors self-hosted, Cloud free 2M records/mo. PAID: Airbyte Cloud $2.50/credit (~$0.015/M credits), Team $15k credits/mo $1,500. Fivetran $1.00/credit + MAR $120/mo min, free 500k rows/mo. Overage $2.50/credit.
BI Connector / SQL Gateway (JDBC/ODBC)
Persistent storage for your app’s data — users, products, orders. The single most important architectural decision for most projects.Pricing & free-tier limitsFREE: Snowflake/Trino/DuckDB drivers free Apache 2.0/MIT, unlimited connections. PAID: CData $999/yr per driver (standard), Enterprise $2,499/yr per driver, OEM $500/mo. Free tier: drivers free, CData 30d trial.
Caching Layer for Warehouse Queries
Stores frequent results in fast memory so you serve less from the database. Big lever for speed and cost.Pricing & free-tier limitsFREE: Snowflake result cache free 24h for identical queries, OSS cache unlimited self-hosted. PAID: Databricks predictive cache included (no extra DBU), CubeStore self-hosted free, Cloud $0.04/GB-hr cache, $256/mo min. No extra overage for snowflake cache.
Backup & Time Travel
Copies of your data so a bug, hack, or outage doesn’t become permanent loss. Cheap insurance every serious project needs.Pricing & free-tier limitsFREE: Delta/Iceberg time travel free, S3 versioning $0.023/GB/mo ver. PAID: Snowflake Time Travel Standard 1 day included (7d enterprise), Fail-safe 7d extra billed at $23/TB/mo (Standard) $30/TB/mo (Ent). Databricks backup incremental S3 cost only. Free limits: 1 day (std) then recovery via fail-safe.
Secrets Management for Warehouse Credentials
A piece of your stack you may or may not need, depending on scope. Pick the option that fits — or skip it if your project doesn’t require this capability yet.Pricing & free-tier limitsFREE: Vault OSS unlimited self-hosted, Infisical Free 3 envs, AWS Secrets 30d free rotation. PAID: AWS Secrets $0.40/secret/mo + $0.05/10k API calls. HCP Vault $0.03/hr dev, $1.58/hr Enterprise starter $630/mo. Free tier: AWS 30d trial, Infisical 3 projects free.
CI/CD & Schema Migration for Warehouse
Automates testing and deploying your code. Saves enormous time and prevents “works on my machine” releases.Pricing & free-tier limitsFREE: dbt Core unlimited, free IDE; dbt Cloud Dev free 1 seat, 1 project. PAID: dbt Cloud Team $50/user/mo ($100/mo min), Enterprise $250/user/mo. Flyway Teams $3,000/yr. Bytebase Pro $499/mo 10 instances. Overage dbt usage seats $50 ea.
How this hobby warehouse and lakehouse checklist works.
Each requirement below is something a hobby warehouse and lakehouse build typically needs. Pick one of the four researched options — recommended, free, cheaper or paid — add your own with "Other", or skip the requirement if your project doesn't need it. Nothing is mandatory; the plan on the right tracks what you've decided so nothing gets forgotten.
Your picks are saved in this browser automatically, so you can come back anytime. Options are researched per build level and refreshed as vendors change their plans — always verify details on the provider's page before committing.