Direct Query

Question & Answer
1

I am using direct queries to visualize some dashboards. I cannot use spice as I cannot having 15 mins stale data.
But every-time I am having to refresh manually to see the new data coming in.
Is there a solution around it or any automation built around it.

@Sanjeeb2022 @EnriqueS

2 Likes
2

Hi @Sabiha - Direct Query should refresh the data but if there is any filter in the dashboard that needs to be refreshed manually.

Hi @Biswajit_1993 - Can you please provide your expert on this.

Regards - Sanjeeb

1 Like
3

Thank you @sanjeeb, just want to chk if there is way to programatically refresh the quicksight screen

2 Likes
4

HI @Sanjeeb2022 , This is the most required fetaure currently needed in QuickSight. Because manually referesh each filter every time is not correct method so can we tag product team so that they can take action on it.

Because if the number of filter is below 5 then we can do it if it more than 5 then every time refreshing is very difficult as a end-user.

Thanks & Regards
Biswajit Dash

2 Likes
5

Hi @Max @Koushik_Muthanna - Can we consider this as a feature request. We need an approach to refresh the dashboard automatically?

Please advise.

Regards - Sanjeeb

1 Like
6

What I understand from this is that the visuals need to be refreshed without the user having to reload the entire page ?
“But every-time I am having to refresh manually to see the new data coming in.”

The following post should help : Auto dashboard page refresh - #4 by Jesse

For filter controls ( Refreshing data in Amazon QuickSight - Amazon QuickSight ) , it’s automatically done every 24 hours .

Kind regards,
Koushik

4 Likes
7

Thanks @Koushik_Muthanna . But if the data refresh is happening every 1 hour, we should have the flexibility to refer the filter controls with less time. This should be set by the user as well. And the auto dashboard feature is only available in capacity planning not by default. Is this something can consider as a feature request and for enterprise license, it can add in coming days.

Please advise.

Regards - Sanjeeb

2 Likes
8

Thank you @Sanjeeb2022 @Biswajit_1993 @Koushik_Muthanna for this super useful response.
So I gather that I need to have capacity planning enabled to have the auto refreshes.
How can I decide which level of capacity planning I need to have. I am not sure when the dashboard will be accessed. But when accessed, and viewed it should have auto refreshing capability. Pls guide if you have any idea.
And thanks again.

1 Like
9
2 Likes
10

Hi @Sabiha - I believe it depends upon couple of parameters like number of users, number of dashboards, how many users are accessing to the dashboard. There is no simple calculation over here. However an average estimation can be considered in this case.

Hi @David_Wong @Max - Any expert advise on this.

Regards - Sanjeeb

2 Likes
11

Hi @Sabiha - You can always buy more sessions when you see you’re running out. What you see in the pricing page is the discount you will get based on the sessions you buy. The more the sessions the greater the discount.

In order to estimate the number of sessions use the following metrics to get started:

  • number of users logging and viewing the dashboards each day
  • avg duration of dashboard usage in 30min increments (each QuickSight session is 30mins longs)

For example:

I expect 30 daily users, each one using the dashboards for two hours. That means 30 * 4 sessions (120mins / 30) = 120 sessions per day or 120 * 30 = 3600 sessions per month.

The nice thing about capacity pricing is that you don’t have to be 100% accurate in your estimate. Sessions will be consumed when the users log in, and you can be alerted if you start consuming sessions at a greater rate and need to “top up”.

3 Likes
12

Thank you @eperts for great details. Good amount of information :slight_smile:

Regards - Sanjeeb

3 Likes
13

@eperts Beautiful!!! great info here,
So I want to enable auto refresh of one minute in the dashboard. That’s the only reason I am going for capacity planning.
Now when the dashboard is seen, it refreshes every 1 minute. Does that count as separate sessions, or session is of 30 mins irrespective of the refreshes.

It would be great to know that. Thanks

Also tagging my friend @Awanta

3 Likes
14

@Sabiha I checked with the QS team internally and the guidance is the following:

"The 30min session duration will be respected as long as you don’t call the GenerateEmbedUrlForAnonymousUser - Amazon QuickSight repeatedly. "

If you are embedding make sure you use the GenerateEmbedUrlForRegisteredUser - Amazon QuickSight API and then you don’t risk getting billed for extra calls within the 30min window.

PS: I’m going to mark Koushik’s answer as the solution to the original question.

4 Likes