jackDanielle
jackDanielle

Reputation: 184

Convert JSON to CSV in Azure Cosmos DB or Azure Blob

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!

Upvotes: 1

Views: 2373

Answers (1)

Jay Gong
Jay Gong

Reputation: 23782

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:

enter image description here

Output:

enter image description here

Then use Copy Pipelines to process data.

Copy Pipelines:

enter image description here

Result:

enter image description here

Hope it helps you.

Upvotes: 1

Related Questions