-- 1. orientation: Use 'column' for olap, 'row' for key-value queries. -- 2. distribution_key: Choose frequently joined or grouped columns (prefer single column) -- 3. clustering_key: Use for range ...
-- The satellite table is constructed by joining the source data with the hub keys.