Performing live query on Amazon S3 using Athena and viewing in Quicksight

Is there a way to perform a live query on AWS S3 CSVs using Athena and view the results real time in QS?
Say I have a visualization of Employee ID in QS. and if I would like to view Employee details on demand… Can I click on an employee ID to trigger a custom query which would access the data in S3 and send back to QS visual ?

Yes just make sure that your dataset is not using SPICE (but using Direct Query) and then all queries go directly to Athena.