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

Question

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

Answer

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.

Answer

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.

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

Contenuto pertinente