Modern Data Engineering with Medallion Architecture using DBT, Databricks, Spark and Azure Cloud

In this project, we setup and end to end data engineering using Apache Spark, Azure Databricks, Data Build Tool (DBT) using Azure as our cloud provider. This project illustrate the process of data ingestion to the lakehouse, data integration with ADF and data transformation with Databricks, and DBT.

System Architecture

Commands

Try running the following commands:

• dbt run # for running models
• dbt test # for tests
• dbt snapshot # for snapshotting and slowly changing dimensions
• dbt docs generate # for documentation
• dbt docs serve # for documentation preview

Resources:

• Medium Article
• DBT
• Databricks
• Azure
• Azure Data Factory
• Azure Data Lake Storage Gen2

Youtube Video