Quicksight always adds "order by" to sql query

[robdhondt]

@akurinov

Hi all.
i have a “table” view on my dashboard.
when I use ‘direct query’ or even ‘custom sql’ quicksight always adds “order by column1, column 2 , …” to sql query.
I need to run sql without sorting due it affects the performance significantly.
how to disable this sorting? i still have no ideas .. please advise.

Hi @akurinov -

Look into this relatively new feature that helps to address this problem. If you have a column/field that can be used as an unique key, that can be used as a more performant option than the generated ORDER BY clause.

Adding a unique key to an Amazon QuickSight dataset - Amazon QuickSight

Amazon QuickSight Launches Unique Key for Dataset

Amazon QuickSight is excited to announce the launch of Unique Key for Dataset, enabling users to define additional aspects of their data semantics. The unique key will be used to improve performance for QuickSight visuals, especially un-aggregated table charts. Previously, to maintain table pagination stability, all columns in the table visual were sorted, which was an expensive query causing performance latency. Now, with the unique key defined in the dataset, once the column is used in the vis…