Lookup in adf

Vineet S 1,070 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,791 questions
0 comments No comments
{count} votes

Accepted answer
  1. Nandan Hegde 32,416 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 No comments

0 additional answers

Sort by: Most helpful

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.