Hard Limit for SPICE Capacity within One QuickSight Account

sagmukhe · February 8, 2023, 6:30am

Hello QuickSight Experts,

Wanted to get an understanding or information, if there’s any hard limit on QuickSight SPICE capacity for a given account. I have already gone through one of the existing thread and understand that the hard limit is there for a given dataset. However, my question is specifically if there’s any hard limit at a QuickSight account level or we can purchase additional SPICE capacity and stretch the limit as large as possible for a given account as per our need.

Looking forward to your response to get a better understanding. Thank you!

Max · February 8, 2023, 5:30pm

I haven’t ran into any limit and we have processed a lot of data.

My guess is no… but I do not have an exact answer.

Max · February 8, 2023, 7:49pm

There is a 1TB limit per account per region

David_Wong · February 8, 2023, 9:35pm

Isn’t the 1TB limit per dataset and not per account? Our account has over 3TB in SPICE capacity without any issues.

Aneek_Arora · February 9, 2023, 10:13am

1 TB is only the soft limit per QuickSight account. There no known hard limits practically, It can be increased to desired capacity, on request.

github.com

awsdocs/amazon-quicksight-user-guide/blob/main/doc_source/managing-spice-capacity.md

# Managing SPICE Capacity<a name="managing-spice-capacity"></a>

You can use the admin page to see how much [SPICE](welcome.md#spice) capacity you have overall, and how much of that you are using\. SPICE capacity is allocated by AWS Region, so the information displayed is for the currently selected AWS Region\.

SPICE stores your data until you choose to delete it\. You can improve performance by importing the data into SPICE instead of using a direct query to the database\. All nondatabase data sets must use SPICE\.

SPICE capacity is pooled across users for the Amazon QuickSight account\. All of your default SPICE capacity is allocated to your home AWS Region\. The other AWS Regions have no SPICE capacity unless you choose to purchase some\.

To free up SPICE capacity, delete unused data sets from SPICE\. For more information about deleting a data set, see [Deleting a Data Set](delete-a-data-set.md)\. 

You can purchase additional SPICE capacity if you want to, up to a limit of 1 TB total capacity per QuickSight account\. If you need an exception to this limit, follow the instructions at [AWS Service Limits](https://docs.aws.amazon.com/general/latest/gr/aws_service_limits.html) to submit a limit increase request\. You can also release purchased SPICE capacity that you aren't using\. Purchasing or releasing SPICE capacity only affects the capacity for the currently selected AWS Region\. For information about additional SPICE pricing, see [Amazon QuickSight](https://quicksight.aws.amazon.com/)\.

## Capacity Planning for SPICE<a name="capacity-planning-for-spice"></a>

The amount of SPICE capacity a data set uses isn't the same as the size of its source file or table\. The logical size computation occurs after all the data type transformations and calculated columns you define during data preparation\. These fields are materialized in SPICE in a way that enhances query performance\. Any changes you make in an analysis have no effect on the logical size of the data in SPICE\. Only changes that are saved in the data set apply to SPICE capacity\.

In capacity planning for SPICE, consider what data types will be defined in the data set\. For example, the file you want to import may contain all strings \(text\)\. But in order for these to be used in a meaningful way in an analysis, you prepare the data by changing the data types to their proper form\. For example, fields containing prices are changed from strings to decimals, and fields containing dates are changed from strings to dates\. If you create a calculation to make the conversion, you can remove the original field from the data set and substitute the formatted calculated field\. In that case, you don't need to include the size of the original field in your capacity planning\. Only included fields are stored in SPICE\.

**Note**  
Geospatial data types use metadata to interpret the physical data type\. Latitutde and longitude are numeric\. All other geospatial categories are strings\.

This file has been truncated. show original

sagmukhe · February 9, 2023, 1:05pm

Thank you! That helps!

emilyzhu · February 29, 2024, 5:33pm

Hi All, I would like to clarify, 1TB is not total SPICE capacity limit, 1TB and 1B row is the current limitation for each dataset (as of Feb. 2024)

SPICE capacity is configured at account and region level, (meaning for each account in each region, customer can purchase their SPICE capacity to share with all the users). QS has implicit limit for 50TB per account per region, but it is a soft limit, customers can request to increase the capacity limit from QS.

QS also offer auto-purchase capability, customers don’t need to purhcase manually everytime they need more capacity, they can turn on the option and QS will automatically bump the capacity up to match customer usage. Details please see Amazon QuickSight supports SPICE capacity auto-purchase