SPICE-only features - Amazon Quick Suite

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.