Sink transformation in mapping data flow - Synapse Analitycs

Question

I am developing a dataflow in Synapse and in the sink step, I do not understand why reason in the mapping in the columns of the output does not let me define a name to the column, but I get selection.

Answer 1

Hi @Anonymous ,

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

When you have schema defined inside your dataset(which is used in your Sink Transformation) then you will be not allowed to define alias names for your output columns. You should select it from dropdown.

In your case your sink dataset may has schema defined inside it, hence data flows asking you to select output column names from dropdown.

If your sink dataset will not have schema defined in it, then data flow will allow users to give there own output column names.

Hope this will help. Please let us know if any further queries. 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 notification.