Don't miss your chance to take the Fabric Data Engineer (DP-700) exam on us!
Learn moreNext up in the FabCon + SQLCon recap series: The roadmap for Microsoft SQL and Maximizing Developer experiences in Fabric. All sessions are available on-demand after the live show. Register now
Hi there
I've created my Data Pipeline using the Copy Assistant Wizard. Once it's created, is there a way to edit the pipeline using the wizard again?
Scenario:
I built a new pipeline using Copy Assistant Wizard to ingest 10 tables.
Then, ran Pipeline to ingest data.
Now I want to update pipeline to add more tables using the Copy Assistant Wizard. But I cannot see where/how to do this.
Is this possible yet?
If not, how does one go about adding more tables to the same copy activity? or do I need new copy activities every time I want to add tables?
Thanks!
Solved! Go to Solution.
Hi @MonztaInc
Thanks for the information.
You can refer to this video for copying bulk tables : Link1
Hope this helps. Please let me know if you have any further questions.
hi @Anonymous
Thanks for the response.
As part of the Copy Assistant Wizard, I can select multiple tables.
This then wraps the Copy Activity in a ForEach
Any reason that the Copy Wizard shouldn't be used to update the Copy Activity? (besides the fact the functionality doesn't exist)
If I've got 100's of tables, I don't want to have a 100's of copy activities.
Also don't want to have to re-create the Copy activity each time as this has it's own drawbacks.
Hi @MonztaInc
Thanks for the information.
You can refer to this video for copying bulk tables : Link1
Hope this helps. Please let me know if you have any further questions.
Thanks @Anonymous
Thanks for the link! It's a work around, but will give it a try and see if it fits into the workflow.
Would much prefer the copy wizard to be able to update the copy activities.
Much appreciated.
Hi @MonztaInc
Thanks for your feedback.
Appreciate if you could share the feedback on our feedback channel which would be open for the user community to upvote & comment on. This allows our product teams to effectively prioritize your request against our existing feature backlog and gives insight into the potential impact of implementing the suggested feature.
Hope this helps. Please let me know if you have any further queries.
Hi @MonztaInc
Thanks for using Fabric Community.
As I understand you are using Copy Assistant Wizard to ingest 10 tables. How are you doing this?
Can you please attach the screenshots of the pipeline? This would help me in understanding the issue better.
However, the Copy Assistant Wizard does not allow you to add more tables to the same copy activity. You can only edit the existing settings of the copy activity, such as the source, destination, mapping, and performance.
You should create a new copy activity for each table that you want to add to your pipeline.
Experience the highlights from FabCon & SQLCon, available live and on-demand starting April 14th.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
| User | Count |
|---|---|
| 2 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |