Delta Lake

• 11/22/2019
• 2 minutes to read
• • 

Delta Lake is an open source storage layer that brings reliability to data lakes. Delta Lake provides ACID transactions, scalable metadata handling, and unifies streaming and batch data processing. Delta Lake runs on top of your existing data lake and is fully compatible with Apache Spark APIs.

Delta Lake on Azure Databricks allows you to configure Delta Lake based on your workload patterns and provides optimized layouts and indexes for fast interactive queries.

This is the documentation for Delta Lake on Azure Databricks.

• Introduction to Delta Lake
  • Quickstart
  • Resources
• Introductory Notebooks
  • Delta Lake Quickstart Python notebook
  • Delta Lake Quickstart Scala notebook
  • Delta Lake Quickstart SQL notebook
• Table Batch Reads and Writes
  • Create a table
  • Read a table
  • Write to a table
  • Schema validation
  • Update table schema
  • Replace table schema
  • Views on tables
  • Table properties
  • Table metadata
• Table Streaming Reads and Writes
  • Delta table as a stream source
  • Delta table as a sink
• Table Deletes, Updates, and Merges
  • Delete from a table
  • Update a table
  • Upsert into a table using Merge
  • Merge examples
• Table Utility Commands
  • Vacuum
  • History
  • Convert to Delta
  • Convert Delta table to a Parquet table
• Delta Lake API Reference
• Concurrency Control
  • Optimistic concurrency control
• Migrate Workloads to Delta Lake
  • Example
• Optimizations
  • Optimize Performance with File Management
  • Auto Optimize
  • Optimize Performance with Caching
  • Isolation Levels
  • Replicate MySQL Tables to Delta Tables
  • Optimize Join Performance
  • Optimized Data Transformation
  • Table Versioning
• Best Practices
  • Provide data location hints
  • Choose the right partition column
  • Compact files
• Frequently Asked Questions (FAQ)
  • What is Delta Lake?
  • How is Delta Lake related to Apache Spark?
  • What format does Delta Lake use to store data?
  • How can I read and write data with Delta Lake?
  • Where does Delta Lake store the data?
  • Can I stream data directly into and from Delta tables?
  • Does Delta Lake support writes or reads using the Spark Streaming DStream API?
  • When I use Delta Lake, will I be able to port my code to other Spark platforms easily?
  • How do Delta tables compare to Hive SerDe tables?
  • What DDL and DML features does Delta Lake not support?
  • Does Delta Lake support multi-table transactions?
  • How can I change the type of a column?
  • What does it mean that Delta Lake supports multi-cluster writes?
  • Can I modify a Delta table from different workspaces?
  • Can I access Delta tables outside of Databricks Runtime?
• Additional Resources
  • Blog posts
  • Talks
  • Delta Lake transaction log specification