SPICE-only features - Amazon Quick Suite
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

SPICE-only features

Amazon Quick Sight's SPICE (Super-fast, Parallel, In-memory Calculation Engine) enables certain computationally intensive data preparation features. These transformations are materialized in SPICE for optimal performance, rather than being executed at query time.

SPICE-only features

Steps Other capabilities

  • Append

  • Aggregate

  • Pivot

  • Unpivot

  • Divergence

Features available in both SPICE and DirectQuery

Steps Other capabilities

  • Input

  • Add Calculated Columns

  • Change Data Type

  • Rename Columns

  • Select Columns

  • Filter

  • Join

  • Composite Datasets

Best practices

  • Use SPICE for workflows requiring SPICE-only features.

  • Choose SPICE to optimize performance for complex transformations and large datasets.

  • Consider DirectQuery for real-time data needs when SPICE-only features are not required.