Databricks SQL Runtime 18.0 and above: ATOMIC Compound Statement

Nidhig631
Databricks MVP

‎03-24-2026 11:09 AM

The ATOMIC Compound Statement in Databricks SQL is a block of statements that executes as a single, all-or-nothing transaction. If any statement inside the block fails, the entire block is rolled back.
compound statement.jpg

 

Read Complete Article here:
Databricks SQL Runtime 18.0 and above: ATOMIC Compound Statement 

Labels:

monedef536
New Contributor II

‎04-20-2026 11:12 PM

An ATOMIC compound statement in Databricks SQL runs multiple SQL commands as one transaction.
If any statement fails, everything is rolled back; if all succeed, all changes are committed together.  genesiscard com

0 Kudos