azure - Error while exporting from Azure Cosmos DB to Json file using Data Migration Tool

Question

I'm using the Microsoft Data migration tool to import from the Azure Cosmos Db container and export the content to a local JSON file.

I verified the connection string and it is successfully able to make connection with the database.

The query string is : SELECT * FROM ContainerName; Since I want all data.

However I'm facing the following error:

Edit:

The sample JSON that I'm trying to export:

[ { "id": "1", "SId": "101", "SName": "ABC" }, { "id": "2", "SId": "102", "SName": "XYZ" } ]

I've imported this JSON to Cosmos DB using the code on this link.

Please help me regarding this. Thank you.

标签： azureexportazure-cosmosdb

Answer 1

I can't reproduce your issue on my side,so please refer to my working steps:

Source configuration:

Sink configuration:

Results in json file:

If you already pass through the verification of connection string,you could try to lock the issue in the error file.

---

Just for summary:

Finally, the issue is resulted from additional symbol ; at the end of sql. Please remove it because it can't be identified by the tool.