Import a .csv to cosmos db

Question

I have 5 mb csv file and i want to import in azure cosmos db. What is the quickest way to do that.

Answer 1

One way to import a CSV file into Azure Cosmos DB is to use the Azure Cosmos DB Data Migration tool. Here are the steps you can follow:

1. Download and install the Azure Cosmos DB Data Migration tool from the Azure Portal.
2. Open the tool and create a new migration project.
3. Choose the source type as "CSV" and select the CSV file you want to import.
4. Choose the target type as "DocumentDB" (the previous name for Azure Cosmos DB).
5. Enter your Azure Cosmos DB account details and select the appropriate database and collection to import the data into.
6. Map the fields in your CSV file to the corresponding fields in your Azure Cosmos DB collection.
7. Review the settings and start the migration.

The tool will automatically create the appropriate documents in your Azure Cosmos DB collection based on the data in your CSV file. This method is typically faster than manually inserting the data using the Azure Portal or API calls.

Answer 2

Hi @Şükrü Tanrıverdi

Thanks for the question.

If you want automatic import a CSV into a Cosmos DB to update data an Azure Function is the best option for this.

You can import a CSV in a Cosmos DB over Azure Function

Here is document for your reference.

https://github.com/dajor/azurefunction-cosmos

Blog- https://medium.com/@daniel.jordan/import-a-csv-in-a-cosmos-db-over-azure-function-231880f2ddec

Thank you!

Answer 3

@Şükrü Tanrıverdi

If you are using NoSQL API the easiest way is to go with Bulk Executor.

https://learn.microsoft.com/en-us/azure/cosmos-db/bulk-executor-overview

Regards

Geetha