Forum Discussion
Advocate IHow to add column to multiple tables
I am trying to add a date column to multiple tables that I am loading from our sql server. I have been able to add the date column when I only do one table within a copy data activity, but cannot figure out how to apply the column addition to multiple tables. I think the issue is related to the mapping and only being able to import one schema at a time. Is there a way to import schemas for all of the tables in the data load using a dynamic expression?
8 Replies
Hi jpelham ,
Did Houston-ho reply solve your problem? If so, please mark it as the correct solution, and point out if the problem persists.Best regards,
Adamk Kong
Houston-hohave you consider doing the "add column" steps after the copy activities?
and what is the sink for the copy? if that is SQL, you could run a stored procedures to update multiple tables at once.
jpelhamI am taking tables from our on-prem sql server and loading them into a Fabric Lakehouse. How would I go about adding a column after the copy activity?
- Houston-ho
If you are talking about adding calculated column, use the notebook to create a new column on your lakehouse table. This video is quite good.
https://youtu.be/2RuoHpNZbc4
