Forum Discussion
Lakehouse supports ACID compliant
Hi Srisakthi ,
Yes, Lakehouses support ACID transactions. The Delta Table format stores previous and current versions of data and seamlessly transfers between them. You can also use Time Travel to restore or view previous versions of the data (until VACUUM/OPTIMIZE are ran, anyway)
From here; https://learn.microsoft.com/en-us/fabric/data-science/tutorial-data-science-ingest-dataLakehouse - A lakehouse is a collection of files/folders/tables that represent a database over a data lake used by the Spark engine and SQL engine for big data processing and that includes enhanced capabilities for ACID transactions when using the open-source Delta formatted tables.
Delta Lake - Delta Lake is an open-source storage layer that brings ACID transactions, scalable metadata management, and batch and streaming data processing to Apache Spark. A Delta Lake table is a data table format that extends Parquet data files with a file-based transaction log for ACID transactions and scalable metadata management.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Srisakthi ,
Yes, Lakehouses support ACID transactions. The Delta Table format stores previous and current versions of data and seamlessly transfers between them. You can also use Time Travel to restore or view previous versions of the data (until VACUUM/OPTIMIZE are ran, anyway)
From here; https://learn.microsoft.com/en-us/fabric/data-science/tutorial-data-science-ingest-data
Lakehouse - A lakehouse is a collection of files/folders/tables that represent a database over a data lake used by the Spark engine and SQL engine for big data processing and that includes enhanced capabilities for ACID transactions when using the open-source Delta formatted tables.
Delta Lake - Delta Lake is an open-source storage layer that brings ACID transactions, scalable metadata management, and batch and streaming data processing to Apache Spark. A Delta Lake table is a data table format that extends Parquet data files with a file-based transaction log for ACID transactions and scalable metadata management.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.