ADF DataFlow Logic to Query

Question

Hi Every One,

Is there any way to convert ADF Dataflow to SQL.In data flow we have used some transformation.is there any way to convert ADF Dataflows to Equaling SQL or any other way to write Queries easiest way.

Please suggest.

Answer 1

Hello @Raj0125 ,

Thanks for the question and using MS Q&A platform.

As per my understanding you have a data flow with transformation logic, and you would like to know if you can convert that code to a SQL query and use it in SQL instead of ADF mapping dataflow. Please correct if my understanding is not clear.

Unfortunately, there is no easy way to directly convert the dataflow logic/code to a SQL query. You may have to build a new query/procedure based on similar logic you have implemented in dataflow.

But if you have any feedback that you would like to suggest for ADF product team, we recommend you to please log it in IDEAS forum here: https://feedback.azure.com/d365community/forum/1219ec2d-6c26-ec11-b6e6-000d3a4f032c

All the feedback shared in this forum are actively monitored by ADF engineering team.
Also please do share the feedback link here once it is posted so that other users with similar idea can up-vote and comment on your suggestion to help increase the priority of the request.

Hope this will help. Please let us know if any further queries.

------------------------------

• Please don't forget to click on or upvote button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
• Want a reminder to come back and check responses? Here is how to subscribe to a notification
• If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators