Real time data - Quicksight -Direct queries

Question & Answer
,
1

Good morning,

I’m currently using the enterprise edition of QuickSight.

My requirement is to have nearly real-time price data. I’ve set up a Lambda function that runs every 2 minutes and injects fresh data. Given this setup, I expected the price data in QuickSight to update every 2 minutes.

However, I’ve configured the database to refresh every 15 minutes, which seems to be the shortest refresh interval available. Consequently, I’ve come to the conclusion that I can only obtain accurate price data every 15 minutes.

Anyways, I’ve been trying both direct queries and SPICE, but they return prices that are 1 hour old.

I’m puzzled as to where my thinking might be incorrect. Why is it that 1 hour is the best refresh rate I can achieve, even though I’ve set up a Lambda function to update the data every 2 minutes?

Thank you

2

Working now: the direct query was the answer indeed with direct access to the data

3

Could you please solve the topic then? Thx.