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