ACID transactions refers to database inserts, updates, and deletions that have four characteristics:
The use of ACID transactions ensures data reliability and integrity. ACID transactions prevent data from falling into an inconsistent state because an operation has partially completed.
Data lakes often do not support ACID transactions. Data warehouses and data lakehouses do support ACID transactions. (This is one of the defining characteristics of the data lakehouse vs. the data lake.)
Related terms: data lake; data lakehouse
On the Onehouse website:
Be the first to hear about news and product updates