Amazon Redshift Data API announces long polling, session management, and flexible batch execution

Amazon Redshift Data API Updates

Amazon Redshift Data API introduces new capabilities to enhance performance and usability.

New Features

• Long polling: Retrieve SQL statement metadata or results without repeatedly polling until the SQL statement reaches a terminal state.
• ListSessions: Enumerate active sessions and filter by status, compute target, or database.
• Flexible batch execution: Execute each SQL statement in a batch independently, allowing partial completion without rolling back the entire batch.

What to do

• Use the WaitTimeSeconds parameter on ExecuteStatement, BatchExecuteStatement, DescribeStatement, GetStatementResult, or GetStatementResultV2 for long polling.
• Use ListSessions to manage active sessions across multiple queries.
• Use ExecutionMode parameter with AUTO_COMMIT mode in BatchExecuteStatement for flexible batch execution.

Source: AWS release notes

If you need further guidance on AWS, our experts are available at AWS@westloop.io. You may also reach us by submitting the Contact Us form.