Hello everyone,
I have been assigned to do such tasks, but I am extremely new to this.
Firstly, I want to transform a table into a document type (JSON) using Python, or any better ways as suggested.
Secondly, then I will store those docs in COSMOS DB for further use.
My questions are how can I use Python script to perform such tasks? Can Python scripts be injected to Data Factory for this?
I am really open to all suggestions here.
Thank you in advance,
解决方案Hello nat236919. Thank you for your question. There are a number of ways to accomplish your task.
Here are some tutorials for copying data from on premise to the cloud. Although the tutorials use BLOB storage as a sink in their example, switching to use a different service as a sink is easy.
https://docs.microsoft.com/en-us/azure/data-factory/tutorial-hybrid-copy-portal
https://docs.microsoft.com/en-us/azure/data-factory/tutorial-hybrid-copy-data-tool
If these tutorials satisfy your needs, please mark this as answered. Otherwise feel free to ask more questions.