Delta table operations – create, read, and write

In this recipe, you will learn how to create, read, and write to Delta tables. You will learn how to write batch data to the Delta table. You will also learn how to perform DML operations such as insert, update, and delete on the Delta table.

Getting ready

Before starting, you need to ensure you have contributor access to the subscription or are an owner of the resource group.

For this recipe, you can follow along by running the steps in the 6.1-Reading Writing to Delta Tables notebook at https://github.com/PacktPublishing/Azure-Databricks-Cookbook/tree/main/Chapter06/.

Copy the Customer and Orders Parquet files from the following GitHub link. You will find folders named csvFiles and ParquetFiles – make sure to copy the files from the ParquetFiles folder at the following URL:

https://github.com/PacktPublishing/Azure-Databricks-Cookbook/tree/main/Common

We are mounting the ADLS Gen2 account and mounting...