Importing Data into SPICE - Amazon QuickSight

Importing Data into SPICE

SPICE is the in-memory optimized calculation engine for Amazon QuickSight, designed specifically for fast, ad hoc data visualization. SPICE stores your data in a system architected for high availability, where it's saved until you choose to delete it. You can improve the performance of database datasets by importing the data into SPICE instead of using a direct query to the database. All datasets that aren't based on database data sources must use SPICE.

Each Amazon QuickSight account receives 10 GB of SPICE capacity per paid user, which is allocated when the user signs into Amazon QuickSight for the first time. Each Amazon QuickSight account also receives one free user with 1 GB of SPICE capacity. SPICE capacity is pooled across users for the Amazon QuickSight account. For example, suppose that you have four users, three paid and one free. Suppose also that you have 31 GB of SPICE capacity available. Any of the users in the account can use that capacity. All of your default SPICE capacity is allocated to your home AWS Region. Other AWS Regions have no SPICE capacity unless you choose to purchase some.

To free SPICE capacity, delete any unused datasets that you have imported into SPICE. For more information about deleting a dataset, see Deleting a Dataset.

You can purchase additional SPICE capacity if you want to, and you can also release purchased SPICE capacity that you aren't using. For information about purchasing or releasing SPICE capacity, and about monitoring SPICE usage, see Managing SPICE Capacity.

When you create a new dataset in SPICE, you can enable email notifications for data loading status. This option notifies the owners of the dataset if the data fails to load or refresh. To turn on notifications, enable the Email owners when a refresh fails option that displays on the Finish data set creation. This option isn't available for datasets that you create by using Upload a File on the datasets page.