Convert JSON to CSV in Azure Cosmos DB or Azure Bl

Question

I need to move JSON data in Azure Cosmos DB to Azure Blob and eventually need data to be in CSV format.

Found out there's a feature that converts CSV data to JSON but can't find the other way around..

It really doesn't matter where I convert data from JSON to CSV, either in Azure Cosmos DB or in Azure Blob. How could I do this? Thanks!

Answer 1

You can use the Azure Cosmos DB: Data migration tool which supports Exporting from Azure Cosmos DB to JSON

Answer 2

Based on you requirements, I think Azure Data Factory is your perfect option.

You could follow this tutorial to configure Cosmos DB Output and Azure Blob Storage Input.

Input:

Output:

Then use Copy Pipelines to process data.

Copy Pipelines:

Result:

Hope it helps you.