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.