LKData's avatar
LKData
Regular Visitor
5 months ago
Status:
New

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.

No CommentsBe the first to comment

Recent ideas