What's a data warehouse?

Where warehouse workers means something else

The TL;DR

A data warehouse is a special type of database designed for analytics instead of transactions

  • There are two types of database use cases: transactional and analytical

  • Transactional databases like PostgreSQL are built for adding, updating, and removing data, but analytical DBs are for complex queries and joins

  • Data gets moved from transactional to…

This post is for paying subscribers