Joining Queries in Azure Data Factory on Cosmos DB Sources

This article illustrates how to join two queries using ADF (Azure data factory).


First, prepare your data sources. Make sure you have at least two data sources (such as tables, files, or databases) that you intend to join together. Additionally, ensure that these data sources have been properly registered within your Azure Data Factory. Here are my two datasets with their details.

Dataset #1

Dataset #2


Please note: ‘vehicleCustomerRelation’ is a data that is available in the ‘vehicle’ database. Hence the datasetname is ‘vehicleCustomerRelation’ and the database name is ‘vehicle’

Note : Make sure the datasets use