exclude column in ADF pipeline

Jayesh Dave 296 Reputation points


I want to know, how I can exclude one or two columns in ADF pipelines so the value of that column doesn't gets copied or loads into a target table.

Any help on this is greatly appreciated.

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,084 questions
{count} votes

Accepted answer
  1. Nasreen Akter 10,791 Reputation points

    Hi @Jayesh Dave ,

    If you are using CopyActivity, then:

    option#1: uncheck that specific column mapping from CopyActivity --> Mapping --> un-select checkbox for that specific column from Include (please see screenshots below)

    option#2: If you want to load static value for any columns e.g., Empty String, you can add additional column from CopyActivity --> Source --> Additional Columns. And then map this column to the target column

    Hope this helps! Thanks! :)


1 additional answer

Sort by: Most helpful
  1. Akhil 21 Reputation points

    Hi @Nasreen Akter
    How can we exclude Identity Column in the pipeline copy activity in adf

    0 comments No comments