By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre: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
Analytics
Tags
Amazon QuickSightAmazon Redshift
Language
English
srfsup
asked a year ago468 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.

profile picture
EXPERT
Sedat Salman
answered a year 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.

profile picture
EXPERT
iwasa
answered a year 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.

Guidelines for Answering Questions

Relevant content