The DuckHouse blog
The Pocket Warehouse
A field guide to owning your data, in ten parts: from numbers scattered across a dozen tools to answers you can ask for from your phone.
Part 10 · The Pocket Warehouse
One afternoon.
Years of answers.
Latest · Part 10 ·
Build a data warehouse in an afternoon
The whole series in one sitting: sources, syncs, models, questions and an AI in your pocket, and what keeps a small warehouse healthy, cheap and safe for years.
All ten parts
Read in order, the series follows one small business from scattered numbers to a warehouse it can question from anywhere. Each part also stands on its own. A new part comes out every week or two, on the dates below.
- 01What a data warehouse is, and why you might finally need oneOctober 1
- 02DuckDB, and why small data got fastOctober 2
- 03Inside the engine: how a columnar database reads so littleOctober 5
- 04Getting your data in: syncs, APIs and CSVs, without a pipeline teamOctober 7
- 05Shape it once: modeling a warehouse that people and AI can readOctober 9
- 06The SQL behind every business questionOctober 12
- 07MCP, explained: how AI assistants reach your dataOctober 14
- 08Your warehouse, in your pocketOctober 16
- 09DuckLake, explained: a lakehouse you can hold in your headOctober 27
- 10Build a data warehouse in an afternoonNovember 10
Launch your first warehouse.
No contracts and no minimums. Pick a size and a region, attach from your terminal, and pause it whenever you like.