Agenda: I need to get a refreshed quick sight dashboard.
What I have done : I have db dump at s3 and I am crawling data from s3 to aws glue catalogue database.
i am able to use Athena queries on the same database. When i am trying to use athena as my data source in quick sight its giving me option custom sql query(that is working fine for me) this dataset is not allowing me to refresh data which is problem for me. here is overall connectivity i am using:
S3 Data → Crawling and adding to catalogue DB → Athena workgroup → Quick sight data source as Athena → quick sight Analysis
I would really appreciate if someone can help if there is any better approach or there is problem with this one.