Which statements describe the use of transactions in Snowflake?
Snowflake supports BEGIN WORK and BEGIN TRANSACTION as explicit transaction-start statements, and supports COMMIT WORK as a synonym for COMMIT. Explicit transactions should contain only DML and query statements because every DDL statement implicitly commits any active transaction and executes separately.
BEGIN WORK
BEGIN TRANSACTION
COMMIT WORK
COMMIT
Community Discussion