Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,521 questions
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Hi, How to use look up table columns in copy activity and can we write sql in lookup any screenshot appreciated
In case of lookup activity, you can use query property to write the SQL query of your need :
In case of copy activity, in source side with SQL as source, you can write the SQL query via query option :