AcceptsThe name of a column in a derived table
distribution lets you specify the column from a persistent derived table on which to apply a distribution key. Currently,
distribution only works with Redshift and Aster databases. Traditional SQL dialects (such as MySQL and Postgres) should use
Generally speaking, a distribution key should be applied to the column that will be acting as a foreign key (i.e. the column you’ll use to join your derived table to others). More information can be found in the Redshift documentation and Aster documentation.
customer_order_facts persistent native derived table (NDT) with a distribution key on
customer_order_facts derived table based on a SQL query with a distribution key on
distribution Only Works with Derived Tables That Are Persisted
Derived tables can be calculated at query time, or they can be made persistent using
distribution parameter works only with persistent derived tables.