How to add a Joing Query for pipeline Source

Mahesh Madhusanka 106 Reputation points
2020-06-04T02:45:02.047+00:00

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?

9010-copy-data-source-table-config.jpg

9066-join-query-added-source-sql.jpg

9037-join-source-query-2.jpg

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
    2020-06-04T10:38:17.823+00:00

    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 :

    9123-table-none-setting.jpg

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

    9047-copy-query-multiple-tables.jpg

    Hope this helps.