As of Looker 3.36, when users of Amazon Redshift create a persistent derived table, the Redshift distribution style will default to ALL instead of EVEN.
Amazon Redshift allows database rows to be distributed in one of 3 ways:
All Distribution: All rows are fully copied to each node.
Even Distribution: Rows are distributed to different nodes in a round-robin fashion.
Key Distribution: Rows are distributed to different nodes based on unique values within a particular column.
Going Back to an EVEN Distribution
If you would like to go back to using an EVEN distribution on a derived table, you can do so by using the
distribution_style parameter as follows:
- view: customer_order_facts
COUNT(*) AS lifetime_orders
persist_for: 24 hours