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

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

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

1 answer

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

    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

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.