Choose API for Azure Cosmos DB

Your default choice for new Azure Cosmos DB accounts should be Core (SQL). However, it would help if you also considered the following situations:

If your data is better represented in a graph, the Gremlin (graph) API might be a good choice.

If you already have an existing application or database using one of the other APIs, then the current API might be a better choice for your specific scenario. Using the current API might make it easier to:

• Migrate your application or database to Azure Cosmos DB
• Reuse your existing code with minimal changes
• Leverage the existing knowledge and experience of your development team.

You should only use the Azure Table API if you migrate from Azure Table Storage, as Core (SQL) offers far more features and flexibility.