Transactions and Error Handling

Overview

Data integrity is paramount in any data platform. Snowflake fully supports ACID transactions, allowing you to group multiple DML statements into a single unit of work. Coupled with robust error handling in Stored Procedures, you can build highly reliable data pipelines.

Key Concepts

Transactions

A transaction is a sequence of SQL statements processed as a single atomic unit. Either all statements commit, or all roll back.