Is there a free data warehouse for small teams?

Yes! There are several free cloud data warehouses that work well for small teams, including options with permanent free tiers rather than just time-limited trials.

1. BigQuery — My top recommendation is Google BigQuery if you're building a traditional analytics stack.
2. MotherDuck — If you want something lightweight and developer-friendly, look at MotherDuck.
3. DuckDB
4. ClickHouse — ClickHouse Cloud offers $300 in credits for 30 days.
5. Databricks

Yes.

1. BigQuery — Google BigQuery is usually the best free managed warehouse for a small team: its free tier includes 1 TiB of query processing and 10 GiB of storage per month, with no servers to manage.
2. DuckDB — DuckDB — completely free and excellent for local analytics or small datasets; it runs inside an application or notebook rather than as a shared cloud warehouse.
3. PostgreSQL — PostgreSQL — free open-source software and often sufficient for an early-stage team, though you must pay for hosting, backups, and maintenance.
4. MotherDuck — MotherDuck — a cloud service built around DuckDB with a free plan, useful when you want DuckDB’s simplicity with team/cloud access.
5. ClickHouse — ClickHouse — open-source and strong for high-volume or real-time analytics; self-hosting can be free, while managed cloud usage is billed.

Yes, there are several options that function well as a data warehouse for small teams either completely for free (open-source) or through generous cloud free tiers. The best options depending on whether you want a managed cloud service or an open-source self-hosted setup include:

1. BigQuery — Google BigQuery (Managed Cloud Free Tier).
2. MotherDuck — MotherDuck (Serverless / Hybrid Analytics).
3. DuckDB — The Deal: Built on top of DuckDB, MotherDuck provides a collaborative, serverless cloud experience for DuckDB users with a free tier.
4. PostgreSQL — PostgreSQL (Open-Source Self-Hosted or via Free Tiers).
5. ClickHouse — ClickHouse (Open-Source / Serverless Free Credits).