Amazon QuickSight launches Common Sub-expression Elimination for SPICE performance optimization

What's New / Blog
1

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.

This is a companion discussion topic for the original entry at https://aws.amazon.com/about-aws/whats-new/2023/05/amazon-quicksight-common-sub-expression-elimination/
4 Likes
2

For existing customers who are using SPICE, do we need to perform any change to take the advantage of CSE? Please confirm.

@Max @David_Wong @Kristin - looks like it is an awesome feature and will improve the SPICE refresh performance.

@Biswajit_1993 - Fyi.

Regards - Sanjeeb

1 Like
3

Hi All, no changes needed from the end-user side. The CSE will seamlessly applied to your QS experience.

2 Likes
4

Thank you @emilyzhu .

Regards - Sanjeeb

1 Like
5

Thanks for the update @emilyzhu!

6

Hi @Sanjeeb2022 thanks for your information. Yes it is really needed feature which will help to increase the performance of the SPICE datasets.
For the TOP & Bottom filter & mostly for conditional formatting the loading of the dashboard bit slow. But after releasing this feature we will have much improvement on performance side.

Thanks & Regards
Biswajit Dash

2 Likes