Databricks SQL Runtime 18.0 and above: ATOMIC Compound Statement

[Nidhig631]

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.

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

[monedef536]

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