How to add a Joing Query for pipeline Source

Mahesh Madhusanka 106 Reputation points

Hi Team,

Currently i have configure integration Runtime and link services, After then I have to setup a join query for a pipeline source area as per below snap, but our concern is when i create a source connection i'm only allow to select one table but join quarry have a two tables, but that other table already available on same link service connection and same schema, So Can i create a join query as per below snap? and can i extract a data using below join Query? Could you please advise on this?




Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
6,295 questions
No comments
{count} votes

1 answer

Sort by: Most helpful
  1. ChiragMishra-MSFT 946 Reputation points

    Hi Mahesh,

    You can copy data from multiple tables using a query. To do so, you will have to do the following :

    1. In your dataset settings, select "None" for table, as shown below :


    1. In your copy activity source tab, write the query you want to in the "Query" text field as shown below :


    Hope this helps.