Skip to main content

Data Factory

Under Review

Update Copy Data Activity to allow for adding columns to multiple tables

Vote (2) Share
Jennifer Pelham's profile image

Jennifer Pelham on 17 Sep 2024 13:08:09

Currently custom columns can be added to one table, but when importing multiple tables and needing to add the same columns to every table, this is not possible. Our specific use case is that we are loading multiple tables from our SQL server into a Lakehouse and want to add a Load_Date column and a Pipeline_RunID column to every table that is loaded. When loading one table this is very easy, but when we load more than one table, the current functionality of the mapping tab within the copy data activity does not allow this.