Joining Queries in Azure Data Factory on Cosmos DB Sources

 dans Sites anglophones  étiqueté Azure Cosmos DB / Azure Data Factory / ETL/SSIS/Azure Data Factory par

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

Prerequisites

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