Posted On: May 15, 2023
Amazon QuickSight is excited to announce the launch of Common Sub-expression Elimination (CSE) - a performance optimization initiative for better query generation for SPICE datasets. The CSE improves QuickSight user experience through pushing down repeated use of complex expressions into intermediate tables hence simplify complex queries, such as for totals/subtotals, top bottom filter, conditional formatting, and “others” bucket for charts, etc. Through the CSE query optimization, customers would observe faster loading dashboards, especially for complex dashboards and time-consuming interactions. Currently, the CSE is released with SPICE datasets only. There is no customer configuration needed, the backend change will seamlessly apply to the QuickSight usage.
The new SPICE CSE optimization is now available in Amazon QuickSight Standard and Enterprise Editions in all QuickSight regions - US East (N. Virginia and Ohio), US West (Oregon), Canada, Sao Paulo, Europe (Frankfurt, Ireland and London), Asia Pacific (Mumbai, Seoul, Singapore, Sydney and Tokyo), and the AWS GovCloud (US-West) Region. Customers don’t need to make any change from their side, the change will seamlessly apply to all QuickSight users.