Architecting Modern Data Engineering using Azure Databricks

Data is the new oil

There should no doubts in anyone’s mind about how Big Data and AI are fueling the next revolution. Data is the new oil, and AI refines the oil. The questions to ask is the following:

  • How well are you placed to use data as a strategic asset?
  • Are your technologies equipped to harness data effectively? At the right speed and in the proper manner?
  • Are you able to reduce the data to insight turnover time and ensure that the right insight is available to the right stakeholders promptly?

Data Engineering has become vital for any organization that is serious about harnessing data.

This blog illustrates how Azure Databricks strives to modernize and yet simplify data engineering to reduce the data to insight turnover time.

Let us start by understanding the market.

IDC Major Trends

According to IDC, there are three major trends when it comes to Data and AI.

  • The 1st is the astronomical explosion of data: By 2025, data will reach around 175 ZB. To put things into perspective, 1 PB is equivalent to 13.3 years of HD video. 1 ZB is equal to 13.3 million years of watching HD video. That is a binge-watching till infinity.
  • The 2nd trend is AI investment. 80% of organizations are experimenting with AI-related technologies. No one wants to be left behind. The mantra is: adapt or die.
  • The 3rd major trend validates the 2nd trend. AI investment is skyrocketing and is poised to increase by 300% through 2023.

Cloud computing is the primary catalyst to make these changes happen. Cloud enables innovation.

Forbes Prediction

Forbes predicts that, in 2030, the global business value derived from Advanced Analytics & AI will be $15 trillion. This bucket is distributed across smart products, virtual agents, and decision automation.

The potential is immense.

The Challenges

The path to innovation is never easy. It has its road-blocks. Three key challenges prevent organizations from realizing their objectives with Big Data projects are:

  1. The complexity of solutions: There are so many data engineering solutions and offerings that is becomes difficult to understand and implement them.
  2. Data silos: Siloed data across teams and departments inhibit the development of unified data pipelines.
  3. Scaling: Scaling challenges and model performance constraints often represent a cost and implementation barrier for data engineering teams.
TDWI: Challenges with Data and ML projects

By mapping these challenges to the study conducted by TDWI, it is clear that most companies are not satisfied with their current solutions:

  • Less than half are satisfied with the ease of use of their analytics software.
  • Only 21% are satisfied with their access to semi-structured and unstructured data.
  • And only 28% are satisfied with their ability to scale to handle unexpected requirements.

New problems strive for new solutions. Addressing these considerations requires a modern data engineering strategy.

Azure Databricks

Azure Databricks strives to hit the sweet spot. Azure Databricks is the jointly-developed Data and AI service from Databricks and Microsoft with a razor-sharp focus on data engineering and data science.

Let us deep-dive into the key five capabilities of Azure Databricks.

Azure Databricks

Azure Databricks provides five key capabilities:

  1. It is a powerful data processing engine. Azure Databricks, as I like to call it, is Spark on steroids. The enhancements made to the Databricks Runtime has made it up to 10x faster than open-source Apache Spark™. It leverages Azure Data Lake Storage to process both streaming and batch data at scale with almost zero maintenance.
  2. It is a first-class Azure product. What is means is that it has parity with any other Azure service and has tight integration to many Azure services, including Azure Machine Learning, Synapse, Azure Data Factory, and Azure DataLake Storage (ADLS). Nowhere in the cloud world exists such tight integration with Databricks.
  3. It provides a platform for end-end lifecycle management of data engineering and data science workloads using collaborative workspaces and notebooks. That means that multiple teams can work on the same data engineering job without overwriting each other.
  4. It provides best-in-class security features. It provides enterprise-grade security with encryption, fine-grained role-based access control, and is HITRUST certified, building on the foundation of HIPAA, NIST, ISO, COBIT, and SOC 2.
  5. Last but not least, it is a platform as a service. That implies there is minimal maintenance overhead. Compute and Storage are decoupled. Customers get excellent value for money.

Azure Databricks along with Azure’s ecosystem offers a solution that is innovative, scalable, and focuses on value at the right cost.

Modern Data Engineering on Azure

Now that there is a better understanding of Azure Databricks, let us deep-dive into the Architectural constructs of a modern data engineering platform.

Modern Data Engineering on Azure

These are the four critical pillars of modern data engineering. Ingest. Store. Prep and Train. Model and Serve. It will look traditional, but the devils are in the details.

Let us drill down into it:

  1. The Ingestion: The data is ingested and stored in the data lake store. Azure Data Factory, Azure’s defacto data integration tool, provides more than 50 connectors that will enable us to integrate data from disparate sources into the raw data lake.
  2. The Storage: Azure Data Lake Store provides HDFS compliant storage, which theoretically has limitless capacity. ADLS can natively store data in Delta Format that provides additional capabilities like ACID compliance, schema enforcement, data versioning, audit history, to name a few.
  3. The Preparation: Now we are into the kitchen, Azure Databricks has all the right ingredients to process both batch and streaming data, at scale and make it ready to be served to stakeholders. As you would know by now, it will use best in class Apache Spark for the processing. It will also streamline the workflow, and one can also deploy ML workflows using Azure Databricks.
  4. The Serving: Here comes the power of Azure Synapse that has native integration with Azure Databricks. Synapse is an on-demand Massively Parallel Processing (MPP) engine that will help to serve the data for reporting and downstream analysis include Azure Machine Learning.

The Architecture is scalable, on-demand, with built-in high availability (HA), and is capable of processing and serving petabytes of data at lightning speed.

Key Takeaways

The architecture illustrated in the previous section is tried and tested with multiple customers across the globe. Architecture is such that it gives the right levers for cost and functionality control.

There are a few fundamental principles to note in this Architecture:

  1. All components are platform-as-a-service: This implies that it has built-in HA and can be configured to only pay for what you use.
  2. Compute is decoupled from Storage: Now, that is very neat. The Storage is persistent, and the compute ephemeral. You spin up on-demand, process what you need, and then shut it down. Pay for only the time it processes.
  3. All components are loosely coupled but tightly integrated. The components used in Architecture integrate very well with each other. The development effort to weave them together is minimal. They are also loosely coupled. One can replace any component with another component that satisfies the same functionality without impacting others.

This Architectural pattern enables data engineers to focus on doing data engineering with a single goal in mind: To reduce data to insight turnover time. Focus less on technicalities. Focus more on functionality.

--

--

--

#Data and #AI Strategist @ Microsoft. Impact driven. Executive-level interpersonal skills. Hands-On. #WorldTraveller. #Blogger

Love podcasts or audiobooks? Learn on the go with our new app.

Recommended from Medium

Mathematics Behind Logistic Regression

Platform as enablers of data driven enterprises

Visualizing the Pandemic in the United States

Support Vector Machine — Explained

The Rule of Three: calculating the probability of events that have not yet occurred

Portfolio Optimization with minimum risk using QAOA

Simple Data Visualization Tools

WeGene Reviews: What You Should Know Before Buying

WeGene Reviews: What You Should Know Before Buying

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Pradeep Menon

Pradeep Menon

#Data and #AI Strategist @ Microsoft. Impact driven. Executive-level interpersonal skills. Hands-On. #WorldTraveller. #Blogger

More from Medium

ETL using Azure Data Factory

How to pass parameters between Data Factory and Databricks

Passing parameters between Data Factory and Databricks by Azure Tutorials

Introduction to Databricks Workspace Terminologies

Beginners Guide to Read and Write data in Azure Databricks