How to retrieve last 5 days data from Athena data source and stored in SPICE in quicksight?

Question & Answer
, ,
1

How to retrieve last 5 days data from Athena data source and stored in SPICE in quicksight?

2

Hi @dadithya1,

Are you using Custom SQL to pull from the Athena table?
Are you look at rolling 5 days or the past 5 days?

If you are looking into using incremental refresh with your data, then check out this documentation on refreshing SPICE data incrementally.

Thanks,

Bhasi

3

Hi Bhasi, actually looking for past 5 days data from athena.

Yes we use custom sql for athena table connection.