Amazon QuickSight offers SPICE and direct query modes to optimize dashboard performance and data freshness; this post explores best practices, benefits, and considerations for using each mode based on data latency requirements, data volume, update frequency, and source performance.

<div>
<p>This article discusses the best practices for using SPICE (Super-fast, Parallel, In-memory Calculation Engine) and direct query mode in Amazon QuickSight for accessing data sources.</p>
<p>Specifically, the article covers:</p>
<ul>
<li>Benefits of using SPICE, including enhanced performance, cost efficiency, improved security, and automatic scaling</li>
<li>Factors to consider when using SPICE, such as data size limits, refresh limits, and capacity management</li>
<li>Benefits of using direct query mode, such as near real-time data access and no data size limits</li>
<li>Factors to consider when using direct query mode, such as data source performance and query timeouts</li>
<li>Suggested query modes for different scenarios, such as daily data updates, near real-time data requirements, and temporarily unavailable data sources</li>
</ul>
</div>


Related articles