question

MaheshMadhusanka-2060 avatar image
0 Votes"
MaheshMadhusanka-2060 asked ·

How to add a Joing Query for pipeline Source

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
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

ChiragMishra-MSFT avatar image
0 Votes"
ChiragMishra-MSFT answered ·

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.



· 1 ·
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @MaheshMadhusanka-2060,

Just checking in to see if the above answer helped. If this answers your query, do click “Accept Answer" and Up-Vote for the same.

0 Votes 0 ·