- or -
AcceptsThe name of a column in a derived table or aggregate table
distribution lets you specify the column from a persistent derived table (PDT) or an aggregate table on which to apply a distribution key. Currently,
distribution works only with Redshift and Aster databases. For other SQL dialects (such as MySQL and Postgres), use
Generally speaking, a distribution key should be applied to the column that will be acting as a foreign key (the column you use to join your table to others). Refer to the documentation for your dialect for best practices.
customer_order_facts persistent derived table with a distribution key on
customer_order_facts derived table based on a SQL query with a distribution key on