Forum Discussion
Advocate IChanging a copy job destination
TheFifthJoin Unfortunately, you cannot directly change the destination of an existing copy job once it's created. The UI only allows you to modify the source tables, not the target lakehouse or destination.
Recommended Workaround
Here’s what you can do:
- Delete the Existing Copy Job
- Go to your Data Factory workspace in Fabric
- Locate the copy job under the “Data pipeline” or “Copy data” section
- Delete the job that points to the old lakehouse
- Create a New Copy Job
- Use the same source tables
- Point the destination to your newly created lakehouse (with correct collation)
- Reapply any transformations or mappings you had in the original job
- Optional: Use Pipelines for Flexibility
- If you want more control, consider using a Data Pipeline instead of a basic copy job
- Pipelines allow you to define dynamic parameters, making it easier to switch destinations in future
Super UserTheFifthJoin Unfortunately, you cannot directly change the destination of an existing copy job once it's created. The UI only allows you to modify the source tables, not the target lakehouse or destination.
Recommended Workaround
Here’s what you can do:
- Delete the Existing Copy Job
- Go to your Data Factory workspace in Fabric
- Locate the copy job under the “Data pipeline” or “Copy data” section
- Delete the job that points to the old lakehouse
- Create a New Copy Job
- Use the same source tables
- Point the destination to your newly created lakehouse (with correct collation)
- Reapply any transformations or mappings you had in the original job
- Optional: Use Pipelines for Flexibility
- If you want more control, consider using a Data Pipeline instead of a basic copy job
- Pipelines allow you to define dynamic parameters, making it easier to switch destinations in future
Advocate II worried this was the case. Really surprised that level of basic editing for a job isn't available. I intentially used a copy job over a copy job activity as I've read its more efficient if you're just A-B copying and don't require any kind of transformation. Thanks for the reply, I best go start rebuilding copy jobs!