- 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
distributionparameter works only with tables that are persistent, such as PDTs and aggregate tables.
distributionis not supported for derived tables without a persistence strategy.
In addition, the
distributionparameter is not supported for derived tables that are defined using
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