Is there a way to see the SQL query being sent to the SQL data source in Mapping Data Flow?

Question

I have been running into an issue debugging parameterised sql data sources in MDFs when the query is highly parameterised or has embedded MDF expressions. I don't seem to be able to see the query sent anywhere. Does anyone know how I can see the SQL query that was sent?

Yes, I know it's in the Query box but I am talking about the query actually sent when it contains parameters or MDF Expressions.

I know I can create a dummy data source, add on a derived column and add the same paramterised/expression SQL query and then see the results but that requires me to either have a dead end branch or edit my MDF in order to debug the data source.

Is there an easy way to see the SQL sent to the DB in the MDF?

Answer 1

Hi @Mathew Partridge ,

Thank you for posting query in Microsoft Q&A Platform.

There is no direct way to view your query sent to SQL. One work around would be as you said using create a dummy source and use derived column to store query.

Please feel free to log your feedback in below azure feedback portal. Azure data factory actively monitor feedbacks there and consider them to implement in future releases. Thank you.

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

• Please accept an answer if correct. 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 email-notifications.