key column dropdown is not displayed in sink optimize option in mapping data flow in ADF.

Sumit Rauniyar 6 Reputation points
2021-10-06T13:45:25.467+00:00

138203-capture.png

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,658 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. ShaikMaheer-MSFT 38,551 Reputation points Microsoft Employee Moderator
    2021-10-07T14:39:31.943+00:00

    Hi @Sumit Rauniyar ,

    Welcome to Microsoft Q&A Platform. Thank you for posting query here.

    I tried same with Parquet type dataset in Sink transformation, I am able to see key column option available.

    138547-image.png

    Could you please try below requested points and share updates how it goes?

    • I guess it may be UI glitch. Could you please close all browser sessions and see if that helps?
    • Is your inspect tab under sink transformation getting schema?
    • Are you able to perform data preview without any issues?

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.