I am currently implementing Databricks. I want to update Databricks data in the dataset every minute, and I want the corresponding dataset to automatically update the dashboard when it is updated.
You can find out your plan there. SPICE capacity is different than the capacity plan… The name is probably misleading, as diff tiers are bundled with SPICE capacity as well.
If I subscribe to Session capacity pricing in “Your subscription,” does this enable the “enable auto-refresh for visualizations” option?
Additionally, does this activated option apply similarly to the Dataset connected to DataBricks?
Hi @kangbis - Welcome to AWS QuickSight community and thanks for posting the question. Yes, the screenshot provided by you is correct, but before doing it, I will suggest to raise a ticket to AWS Customer support team and understand in details as it may be a costly compare to standard/ enterprise edition.
Also it is possible for you to see the direct query will help you or not to get the real time refresh, however you may need a mechanism to refresh the page automatically.
Is it possible to revert back to ‘Per reader pricing’ after changing to ‘Session Capacity pricing’?
I have a feeling that once we switch to ‘Session Capacity pricing’, a button might appear for ‘Per reader pricing’.
Is the “a mechanism to refresh the page automatically” you mentioned unrelated to the “Session Capacity pricing” plan?
Is there something specific we need to request in “Manage Quicksight” for the updated data to be automatically reflected on the dashboard?
We have switched to Capacity Pricing, but the option is not visible when publishing on the dashboard.
Does the Quicksight representative from AWS need to manually activate this feature for us?
Hi @kangbis - Sorry for the late response. I will advise your to raise a ticket to AWS customer support team to help on this. They will analyze the issue by screenshare and fix it.
Thanks to your kind assistance, I was able to find several clues, and we’ve reached out to our cloud engineer to make the necessary requests to AWS. We received a response this week indicating that these functionalities will be activated soon. I want to express my gratitude for your help.
As this functionality is not officially supported, I had to piece together information from the community, which wasn’t always easy. It would be great if QuickSight could provide more detailed information on this in their documentation.
Due to this feature, we had considered conducting a PoC for Tableau integration. Nowadays, it seems that the trend is shifting towards real-time dashboards.
Additionally, having an annotation feature like the one described at https://www.tutorialgateway.org/tableau-annotations/ would be greatly appreciated. We currently lack this feature, and our service team has to download CSV files daily, update them in Google Spreadsheets, and keep a record of any changes and events.
I was quite impressed that QuickSight includes a Sankey chart by default. Furthermore, not having to manage instances specifically for BI and the favorable pricing of SPICE have been significant advantages.
I hope QuickSight continues to improve and thrive.
Hi @kangbis - Thank you. I am completely agree with you, QuickSight is evolving and day by day new features are getting added which improve customer experience, efficient better BI presentation as well. Can you mark your last post as solution so that the details can be visible to other community members.