question

EddynsonVega-8570 avatar image
0 Votes"
EddynsonVega-8570 asked ShaikMaheer-MSFT commented

Sink transformation in mapping data flow - Synapse Analitycs

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.

124802-screenshot-14.png


azure-synapse-analytics
screenshot-14.png (26.7 KiB)
· 3
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

I should get out this way

124822-screenshot-1.png


0 Votes 0 ·
screenshot-1.png (17.3 KiB)

Hi @EddynsonVega-8570 ,

Following up to see check if below answer helps you? If yes Please Accept Answer. Accepting answer will help community as well. Please let us know if any further queries. Thank you.

0 Votes 0 ·

Hi @EddynsonVega-8570 ,

Just checking if below answer helps you? If yes Please Accept Answer. Accepting answer will help community as well. Please let us know if any further queries. Thank you.

0 Votes 0 ·

1 Answer

ShaikMaheer-MSFT avatar image
0 Votes"
ShaikMaheer-MSFT answered

Hi @EddynsonVega-8570 ,

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.


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.