Amazon Redshift Query Editor V2 Increases Maximum Result Set and Export size to 100MB

AWS announces Amazon Redshift Query Editor V2 now supports increased maximum result set and export size to 100MB of your query result sets with no row limit. Prior to this limit of your query result sets was* 5MB or 100,000 rows. This enhancement provides greater flexibility for you and your team to work with large datasets, enabling you to generate, analyze, and export more comprehensive data without previous constraints.

If you work with large datasets, such as security logs, gaming data, and other big data workloads, that require in-depth analysis, the previous 5MB or 100,000-row limit on result sets and exports often fell short of your needs, forcing you to piece together insights from multiple queries and downloads. With the new 100MB result set size and export capabilities in Amazon Redshift Query Editor, you can now generate a single, more complete view of your data, export it directly as a CSV or JSON file, and conduct richer analysis to drive better-informed business decisions.

The increased 100MB result set and export size capabilities for Amazon Redshift Query Editor V2 are available in all AWS commercial Regions. For more information about the AWS Regions where Redshift is available, please refer to the AWS Regions table.

To learn more, see the Amazon Redshift documentation.