Azure Datafactory: sink service in Data flow doesn't show source primary key column in Mapping.

asked 2021-11-13T01:03:45.847+00:00
Vijay Bhargav Nimmala 1 Reputation point

I'm using a Json from Azure Blobstorage on Azure datafactory

to flatten the nested strings by using unroll function

and I'm trying to sink flattened data to Azure PostgreSQL .

As an expected output I need the foreign key from Json object in my sink data but, I couldn't map it.

Please Find attached Screen shots.

Help Appreciated

Thanks,
Vijay 149023-pk.jpg149024-flattened.png149025-sink.png

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

1 answer

Sort by: Most helpful
  1. answered 2021-11-16T00:30:19.383+00:00
    KranthiPakala-MSFT 32,896 Reputation points Microsoft Employee

    Hi @Vijay Bhargav Nimmala ,

    Welcome to Microsoft Q&A forum and thanks for reaching out.

    Could you please try opening your sink dataset and try importing schema, then verify if you are able to see the expected sink column and then go to your data flow, remove your existing sink and add sink transformation again and then select your sink dataset and see if you are able to see the expected column in sink side?

    149544-image.png

    Do let us know how it goes.

    ----------

    • Please don't forget to click on 130616-image.png and upvote 130671-image.png button whenever the information provided helps you. 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
    • If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators