I’m aiming to develop a real-time dashboard with a refresh rate of at least every 10 seconds. The data will be sourced from a Redshift cluster located in another team’s AWS account. The objective is to present data for a specified period chosen by users. I intend to implement a parameter allowing users to select time intervals ranging from 1 second to 30 minutes. This data includes epoch values stored as strings, enabling users to view data based on their chosen time interval. For example, selecting 10 seconds will display data from the past 10 seconds, starting from the current time.
Is it possible in quicksight?