The more we explore Bindle’s data warehouse the more tables we see – users, purchases, books. Data warehouse could easily hold hundreds of tables and it could get messy. We need a way to organize tables and this is where
SCHEMA comes into play.
Schemas basically are folders we could group our tables in. The syntax is quite simple – we just prepend schema name to a table name. Pageviews and events are stored inside
As always, before we dive into complex queries let’s just see what’s inside...