All 7 Amazon QuickSight & Business Intelligence questions
More in Amazon QuickSight & Business Intelligence
What is Amazon QuickSight and what is it used for? What is the difference between SPICE import mode and direct query mode in QuickSight? How does QuickSight support row level security to control what data different users can see? What are QuickSight ML Insights, and how do they help business users find patterns in their data? How does QuickSight support embedding dashboards into external applications for customers or partners? What licensing and cost models are available for Amazon QuickSight, and how do they affect adoption across a large organization?
Advertisement
AWS › Amazon QuickSight & Business Intelligence

What is SPICE in QuickSight and why is it important for performance?

Beginner

Answer

SPICE, which stands for Super fast Parallel In memory Calculation Engine, is QuickSight's in memory data store that caches a copy of your dataset for extremely fast query performance, meaning dashboards built on SPICE respond quickly to user interactions like filtering or drilling down, since QuickSight does not need to query the original data source directly every single time a user interacts with a visualization.
aws quicksight create-data-set --aws-account-id 123456789012 --data-set-id sales-data --import-mode SPICE
Real-world example A sales dashboard used by hundreds of employees imports its underlying data into SPICE, so even during peak usage hours the dashboard remains fast and responsive instead of repeatedly hitting the original database.

Common follow-ups: How often does data in SPICE need to be refreshed?;What is the difference between SPICE mode and direct query mode?

Amazon Redshift & Data Warehousing;Amazon Athena
All 7 Amazon QuickSight & Business Intelligence questions