Lookup in adf

Vineet S 730 Reputation points
2024-07-17T03:59:25.8066667+00:00

Hi, How to use look up table columns in copy activity and can we write sql in lookup any screenshot appreciated

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,521 questions
0 comments
Accepted answer
  1. Nandan Hegde 31,871 Reputation points MVP
    2024-07-17T04:48:03.0066667+00:00

    In case of lookup activity, you can use query property to write the SQL query of your need :

    User's image

    In case of copy activity, in source side with SQL as source, you can write the SQL query via query option :

    User's image

    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.