Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during AI Skills Fest. This week only. Secure your voucher now.

Copy Job - set Destination Schema for all Tables

Recently wanted to pull in hundreds of tables from an on-prem DB.

I want to put them into a (new) schema in a Lakehouse.

 

I do NOT want to type/paste in the schema for each of hundreds of tables.  There should be a better way to do this.

If there already is a better way to do this, it should be more obvious in the UI for people like me  😄

 

 

Even allowing us to modify the JSON for the Copy Job would be helpful because I could copy out the JSON, run some code against that to update the destination schema for each table and plop the JSON code back into the Copy Job.  But, it looks to be read-only.

Status: New