Real-time dashboards with direct query mode

Question & Answer
, ,
1

I want to create a dashboard that shows fresh DynamoDB data that comes in real-time. Using direct query mode for the dataset, the concept worked for low number of incoming events.
Now, having event rate at ~10 events / second, and after refreshing the dashboard just once, I need to wait for several minutes until I see the following on both of my visuals (a table and a bar chart:

image
image1747×658 16.7 KB

The total data at the time of making the screenshot should amount to 2-3k of events.
What I would like to ask is:

  1. how to make the data displayable on demand?
  2. what are Quicksight DOs and DON’Ts when implementing this sort of semi-realtime dashboards?
2

Hi,

It all depend on your database configuration. How much time taking to respond QS.
Filters are also the overhead on direct query. Every click generate a query for dB engine.

You can use the schedule refresh with minute work with 15 minimum. This feature available in Enterprise versions of QS.

Regards,
Naveed Ali

3

Thanks. The point, still, is to make data refreshes on-demand instead of scheduled. There are two filters applied.
By database configuration, do you mean read throughput of the Dynamo table?

4

database configuration means the hardware database is using. You need to check, what’s QS query took the CPU/RAM etc of your database server.

1 Like