How to add a Joing Query for pipeline Source

Question

question

MaheshMadhusanka-2060 asked Jun 4, '20 ChiragMishra-MSFT commented Jun 11, '20

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&#39;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

copy-data-source-table-config.jpg (63.4 KiB)

join-query-added-source-sql.jpg (66.0 KiB)

join-source-query-2.jpg (76.1 KiB)

5 |1600 characters needed characters left characters exceeded

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

Answer 1 · 2020-06-04T10:38:17.823Z

ChiragMishra-MSFT answered Jun 4, '20 ChiragMishra-MSFT commented Jun 11, '20

Hi Mahesh,

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

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

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

Hope this helps.

table-none-setting.jpg (23.0 KiB)

copy-query-multiple-tables.jpg (23.5 KiB)

· 1

5 |1600 characters needed characters left characters exceeded

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

ChiragMishra-MSFT · Jun 11, 2020 at 06:02 AM

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 ·

question