Delta Lake uses OptimisticTransaction for transactional writes. A commit is successful when the transaction can write the actions to a delta file (in the transactional log). In case the delta file for the commit version already exists, the transaction is retried.
Structured queries can write (transactionally) to a delta table using the following interfaces:
More importantly, multiple queries can write to the same delta table simultaneously (at exactly the same time).
Delta Lake provides DeltaTable API to programmatically access Delta tables. A delta table can be created based on a parquet table (DeltaTable.convertToDelta) or from scratch (DeltaTable.forPath).
Delta Lake supports batch and streaming queries (Spark SQL and Structured Streaming, respectively) using delta format.
Delta Lake supports reading and writing in batch queries:
Delta Lake supports reading and writing in streaming queries: