exclude column in ADF pipeline

Jayesh Dave 296 Reputation points
2021-03-16T19:44:04.647+00:00

Hello:

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
    2021-03-16T20:15:34.43+00:00

    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! :)

    78451-img24.jpg


1 additional answer

Sort by: Most helpful
  1. Akhil 21 Reputation points
    2022-04-06T13:47:23.48+00:00

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

    0 comments No comments