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.
10,086 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. ShaikMaheer-MSFT 38,326 Reputation points Microsoft Employee
    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?