Search code examples
azureintellij-ideapycharmazure-cosmosdb

How can I view an Azure CosmosDb using Pycharms or IntelliJ?


enter image description here

I can see loads of drivers, but nothing for DocumentDB. I did try searching for an appropriate driver, but I found nothing.

My DocumentDb is in Azure, so I have a URL and primary key, but I was unable to see how to connect via Pycharm using the "Data Source from URL" option.

How can I connect my DocumentDb to Pycharm (or IntelliJ) database explorer?


Solution

  • Cosmos DB is not a relational database, and you cannot simply connect to it as such.

    It supports several NoSQL protocol variants: DocumentDB (native document store), MongoDB API, Gremlin graph api, and Azure Table API. Not possible to connect via a relational database driver.

    If a tool doesn't explicitly support one of the above-mentioned protocols, you simply won't be able to use it, and will need to work with a different tool. And which tool you choose is really up to you (tool recommendation questions are off-topic).