multiple join in adf pipeline

Vineet S 910 Reputation points
2024-07-06T02:28:47.5633333+00:00

Hi,

and how to to handle select statement with multiple join in adf pipeline

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,916 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,678 questions
0 comments
Accepted answer
  1. Nandan Hegde 32,336 Reputation points MVP
    2024-07-06T03:36:59.5666667+00:00

    Based on your input, I would presume your source is a SQL database;

    1. So within the copy activity in case if your aspect is to copy data, you can select the source as your SQL database and then Select Query option and write your entire query which would have multiple joins

    User's image

    1. You can write your query in either lookup activity or script activity as well in case if that is your use case
    0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.