Direct Query via Athena

Question & Answer
1

I have a dashboard which performs a direct-query on Athena to fetch data for the visualization.

The Athena Query generated by Quicksight includes an order by clause at the end. Is there an option to remove that clause somehow?

2

are you using custom sql?

3

Hi @Bilal_Shakir,

@Ying_Wang is alluding to the option to remove this clause being possible if you are using custom SQL for this query. If you are not, you would need to remove this clause from the Athena Query.

Does this solution work for you? I am marking this reply as, “Solution,” but let us know if this is not resolved. Thanks for posting your questions on the QuickSight Community Q&A Forum!