Skip to content
By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post
About re:Post

Should we use SPICE to store all data from each table, or only data from specific queries?

0

We are currently writing a number of queries in QuickSight using SPICE for storing the results. This is fine for one-off QuickSight reports, but we'd need to write new queries and store in new SPICE when we change parameters, such as date range (i.e. changing from 1-week to 1-month reporting periods). What is best practice for what to store in SPICE: querying and storing data from single queries, or all joining data from tables and storing all data in SPICE (so that we may change query parameters in the future)?

We are using Redshift + QuickSight

Topics
AnalyticsBusiness ApplicationsMachine Learning & AI
Tags
Amazon Quick SightAmazon Redshift
Language
English
asked 3 years ago789 views
2 Answers
4

Store the raw data from tables in SPICE, then perform filtering and aggregations in QuickSight. This allows for flexibility when changing query parameters without needing to rewrite queries and store new data in SPICE.

EXPERT
answered 3 years ago
4

Hi, @srfsup.

You need to save the unfiltered data to SPICE as sdtslmn says and query it with the filter function of the analysis.
Another option is to use direct query mode instead of SPICE mode to always issue queries to Redshift. In my experience, Redshift can be faster if it's optimally tuned.

EXPERT
answered 3 years ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Relevant content