AWS QuickSight Best Practice for creating SPICE

HI, First of all there is no Terminology as Spice Databases in QS. Its a in-memory Datastore in spice where you can import Data from your sources like(S3, Athena etc) to serve low latency Visualizations. So for example if you have a scenario where you need a analysis which needs fast execution, needs to be used multiple times and need to join data from multiple datasets , then as a best practice u should all those datasets imported to spice engine . Infact this will be a cost efficient rather than querying a source directly which has cost implications of querying it. Refer this link - https://docs.aws.amazon.com/quicksight/latest/user/spice.html

Also the cost of Spice engine is charged per GB/Month and has no co relation with how many datasets you have in spice engine. So import datasets in spice diligently only for analysis in scenarios mentioned above(refer the link above)

Please refer pricing link -https://aws.amazon.com/quicksight/pricing/

Thanks

Hi, @ZeBron.

I understood that SPICE database = dataset.
You can calculate the capacity in the following way.

https://dev.classmethod.jp/articles/quicksight-spice-sizing/

The SPICE usage can be calculated from the field size and the number of columns.
The answer is that when you create your analyzes and dashboards it depends on the data structure as the cost will vary depending on how many unnecessary fields and rows are included.
The number of SPICE datasets by itself does not matter.