Data preparation limits
Amazon Quick Sight's data preparation experience is designed to handle enterprise-scale datasets while maintaining optimal performance. The following limits ensure reliable functionality.
Dataset size limits (SPICE)
-
Output size: Up to 1TB or 2 billion rows
-
Total input size: Combined input sources cannot exceed 1TB
-
Secondary tables size: Combined size is limited to 20GB
Note
Primary tables are those with maxiumum size in a workflow; all others are secondary.
Workflow structure limits
-
Maximum steps: Up to 256 transformation steps per workflow
-
Source tables: Maximum 32 import steps per workflow
-
Output columns: Up to 2048 columns at any step in the workflow and final output table with 2000 columns
-
Divergent paths: Maximum 5 paths from a single step (SPICE only, not applicable for DirectQuery)
-
Dataset as a source: Up to 10 levels for both SPICE and DirectQuery
These limits are designed to balance flexibility with performance, enabling complex data transformations while ensuring optimal analysis capabilities.
