I have a datalake partitioned by client>year>month>day
I use Athena to query my datalake in S3.
When I set up the data source I use custom SQL and I have no problem setting up a WHERE clause to point to the specific client data.
I’m wandering how I can set up a where clause to dynamically query my year>month>date partitions when I’m using the relative date filter in my visualizations.
Is my understanding that If I only set up the “client WHERE clause” Athena will always scan the entire data partitions for year month day and not make use of my partitioned datalake (where i set up partition projections).
I’m just a bit confused on how QuickSight makes use of partitions and partition projection when it come to relative date filter.
Hello @Dom, unfortunately, the relative date filter doesn’t utilize parameters in a way that would allow it to pass values to the dataset. The only way you would be able to alter the where clause with date filters would be if you switched to 2 single date select parameters. Then, you would be able to run the query by client and date.
Since this feature is currently unavailable in QuickSight, I will tag it as a feature request. Please let me know if you have any further questions on this topic, otherwise I can archive this topic for the support team. Thank you!
Thank you for your reply and the feature request , that would be very useful to have.
As I’m not familiar with feature requests is there a place I can see a list of the open feature requests?