Posted On: Jan 25, 2023
Amazon QuickSight pivot tables now support more data than ever before with new the field limits, unlocking advance use cases. The value field well limits have been increased from 20 to 40, and Rows and Columns have been increased from 20 each to a combined limit of 40. For example, if the user has 34 fields in rows then they can add 40-34 = max 6 fields to the column field well. Refer here for more information.
To support this increase in field limits, we are also launching performance improvements to load pivot tables faster. Instead of fetching the entire data in the view port, it will only fetch the data for visible fields (expanded fields) along with a small subset of values under the collapsed field. Thus, making sure that data fetched in every new query will be used to render new values that can be displayed immediately. We have seen customers improve their load time from 2X to 10X depending on the complexity of their dataset.
The new field limits and performance improvement for pivot tables will be available in Amazon QuickSight Standard and Enterprise Editions in all QuickSight regions - US East (Ohio and N. Virginia), US West (Oregon), Asia Pacific (Mumbai, Seoul, Singapore, Sydney and Tokyo), Canada (Central), Europe (Frankfurt, Ireland and London), South America (São Paulo) and AWS GovCloud (US-West).