Column joins give us efficient ‘wide’ views but it’s limited to 1 hop. For analytical datasets we often need join multiple tables into an ‘ultra-wide’ view.
Let’s say we have a country table, a region table, an availability-zone table, and a instance table. We might be able to drastically improve query performance by joining all the tables in the metaschema instead of normal SQL JOINS.
