Book Image

Azure Databricks Cookbook

By : Phani Raj, Vinod Jaiswal
Book Image

Azure Databricks Cookbook

By: Phani Raj, Vinod Jaiswal

Overview of this book

Azure Databricks is a unified collaborative platform for performing scalable analytics in an interactive environment. The Azure Databricks Cookbook provides recipes to get hands-on with the analytics process, including ingesting data from various batch and streaming sources and building a modern data warehouse. The book starts by teaching you how to create an Azure Databricks instance within the Azure portal, Azure CLI, and ARM templates. You’ll work through clusters in Databricks and explore recipes for ingesting data from sources, including files, databases, and streaming sources such as Apache Kafka and EventHub. The book will help you explore all the features supported by Azure Databricks for building powerful end-to-end data pipelines. You'll also find out how to build a modern data warehouse by using Delta tables and Azure Synapse Analytics. Later, you’ll learn how to write ad hoc queries and extract meaningful insights from the data lake by creating visualizations and dashboards with Databricks SQL. Finally, you'll deploy and productionize a data pipeline as well as deploy notebooks and Azure Databricks service using continuous integration and continuous delivery (CI/CD). By the end of this Azure book, you'll be able to use Azure Databricks to streamline different processes involved in building data-driven apps.
Table of Contents (12 chapters)

Versioning in Delta tables

In today's world, data is growing day by day and sometimes we need to access the historical data. To access the data for a particular period, data needs to be saved at a point in time, meaning a snapshot of the data at an interval of time. Having such a snapshot will make it easy to audit data changes and perform rollbacks for bad writes or accidentally deleted data.

When the data is written into Delta Lake, every transaction is versioned, and it can be accessed at any point in time. This is called Time Travel. It provides the flexibility to travel back to a previous time and access the data of the current Delta table as it was then. The transaction log contains the versioning information of the Delta table.

Delta Lake always provides backward compatibility, but sometimes suffers from forward-compatibility breaks, meaning a lower version of the Databricks runtime may not be able to read and write data that was written using a higher version of...