This blog explains how to connect data from a transaction (OLTP) database and machine data obtained via spark streaming using Azure Databricks
I use the medallion architecture to join data from the OLTP database and machine database.
I will focus on the Gold layer of the architecture. The Bronze and Silver layers I will focus in my later blogs
The below picture explains the flow of data using the medallion architecture