linux python开发环境sql数据迁移到mysql,使用Python将数据从MySQL（内部部署）迁移到COSMOS（SQL api）...

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.