Forum Discussion
Dataflow gen2 deployment best practices
Hi,
As far as I know, no, it is not possible yet, but in FabCon they told until end of year Dataflow gen2 support will come.
I suppose within the next 2 months native support will come. Question is, can you directly work on Prod, skipping DEV and Test and lates reverse engineer the whole.
Regards,
Oktay
Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.
Hi,
The way we did it it for having dynamic datasource based on DEV, TEST or PROD ist to do following:
- Use switch and as an expression use the Workspace ID (delivers @pipeline().DataFactory
- create for DEV, TEST and PROD a case with workspace ID to check
- as an activity have the same processing, however connecting to different source
This you can create in DEV and test it in TEST and PROD and should access the relating sources. Not a nice way, but works.
Regards,
Oktay
Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.
So to do this, you insert the dynamic content in the dataflow's Power Query calling for the current workspace ID. But how you do it for the Dataflow's ID? because when you go from DEV to TEST you'll need to create a new dataflow hence a new (and unknown) dataflow ID
No, in DEV you already create the three dataflows for dev, test and prod. However in the pipeline you use switch to execute the relating dataflow. for example, you create a swith in the pipeline and add the workspace ID. If that's the case it will run the dataflows, which has the dev source and target in it. The same you do test and prod.
The workspace Id, you can get from the url, when you select a workspace (try dev and test, you can see that only the eng with UID changes.