ACID Transactions on Data Lakes

Problem

You want to build a data lakehouse that supports ACID transactions directly on Parquet files, allowing you to delete records or run updates safely. Write a query that outputs format with the value: "Table formats like Delta Lake, Apache Iceberg, and Apache Hudi enable ACID transactions on data lakes by maintaining a metadata transaction log."

Database Schema

This problem acts as a scratchpad. You will write your own DDL/DML or conceptual queries, so there is no predefined schema.

Try It

Hint

Solution