Amazon Redshift now supports non-atomic transaction mode for stored procedures, enabling more flexible transaction management and easier migration from other data warehouses like Teradata.

<div>
<p>This article discusses enhancements to Amazon Redshift stored procedures for non-atomic transaction mode, providing more flexible transaction control and enabling easier migration from other data warehouse systems.</p>
<p>Specifically, the article covers:</p>
<ul>
<li>Non-atomic transaction mode: Allows each DML/DDL statement in a stored procedure to run in its own implicit transaction unless an explicit transaction is opened</li>
<li>Exception handling: In non-atomic mode, exceptions can be handled without automatically re-raising them, and a new RAISE statement allows re-throwing exceptions</li>
<li>START TRANSACTION statement: Begins an explicit transaction inside a non-atomic stored procedure</li>
<li>Advantages: Enables seamless migration of Teradata stored procedures, and provides more flexible exception handling</li>
<li>Conclusion: These enhancements make it easier to migrate stored procedures to Amazon Redshift from other systems and offer better transaction control</li>
</ul>
</div>


Stored procedure enhancements in Amazon Redshift

Related articles