Amazon Redshift Data API adds long polling, session visibility, flexible batching
Amazon Redshift Data API now supports long polling to reduce redundant API calls for statement status and results. New session management features allow applications to enumerate and filter active sessions, improving visibility. Flexible batch execution allows statements to run independently, preventing partial failures from rolling back entire batches, and enables parameter reuse.
- →Long polling for statement status and results
- →Session enumeration and filtering
- →Flexible batch execution with independent transactions
- →Parameter reuse in batch statements
- →General availability in all supported regions
Features (3) ›
- Long polling for statement status and results
Long polling reduces redundant API calls by allowing applications to wait for SQL statement completion. Specify the WaitTimeSeconds parameter on relevant Data API calls to enable this.
- Session enumeration and filtering
The new ListSessions API provides visibility into active sessions, enabling applications to enumerate and filter them by status, compute target, or database, eliminating the need for external session tracking.
- Flexible batch execution with independent transactions
BatchExecuteStatement now supports an AUTO_COMMIT execution mode, allowing individual statements within a batch to run in separate transactions. This prevents a single statement failure from rolling back the entire batch.
Enhancements (1) ›
- Parameter reuse in batch statements
BatchExecuteStatement now accepts an array of SqlParameter, enabling parameter definition once and reuse across all statements in a batch. This eliminates the need to embed literal values repeatedly.
Notes (1) ›
- General availability in all supported regions
These features are generally available for Amazon Redshift Provisioned and Serverless in all AWS commercial and AWS GovCloud (US) Regions that support the Amazon Redshift Data API.
https://aws.amazon.com/about-aws/whats-new/2026/07/amazon-redshift-data-api-longpolling-listsession-flexiblebatchexecute/
Related releases
- Amazon Redshift RG Instances Now on Trailing Track AWS What's New ·
- Redshift Serverless adds 3-year all-upfront pricing for cost savings AWS What's New ·
- SageMaker Studio Integrates with Amazon OpenSearch for Unified Data Analysis AWS What's New ·
- Amazon Redshift adds rg.large and rg.12xlarge Graviton-powered instance sizes AWS What's New ·
- AWS Glue adds SAP OData connector and zero-ETL to GovCloud regions AWS What's New ·
- Redshift Serverless preserves integrations during snapshot restores AWS What's New ·