Can a Quicksight custom query be filtered before running against a database?


Does QuickSight provide a way to filter a direct query running against a database, based on filters selected by the user when the report is run? We have a report that needs to return financial balances for a period of time, based on the filters that a user chooses. So, if the user chooses a specific date, we would be expected to show a balance for that date and for 4 weeks previous, 8 weeks, 12 weeks etc. The only way we can achieve this currently is to have the balance for every single date for the last few financial years returned by our custom SQL query, for each separate account. This results in millions of rows needed in the dataset to cater for every filter date that the user may choose. The query also takes a long time to run because of this.

If the answer to this question is no, would this be something that may become available in the future please?

asked 2 years ago306 views
1 Answer
Accepted Answer

This feature is currently not supported in Quicksight, I do see a feature request in place for the functionality and it is on the Quicksight roadmap, but we do not have an ETA at this moment.

In the meantime, I request you to please follow this link to stay updated on the latest developments in QuickSight:

answered 2 years ago
profile picture
reviewed 3 months ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions