CosmosDB Core API (SQL) DataSource

Please support Azure CosmosDB Core API (SQL) as a new datasource in ReDash.

The CosmosDB Core API, even though it says ‘SQL’, is actually a document-based API. The ReDash SQL datasources can not connect to that without extra commercial ODBC drivers.

For CosmosDB Core API details, see https://docs.microsoft.com/en-us/azure/cosmos-db/sql-query-getting-started. There is a CosmosDB Python API for that Core API, see https://docs.microsoft.com/en-us/azure/cosmos-db/sql-api-sdk-python.

The CosmosDB Mongo API is supported by the standard MongoDB ReDash datasource. However, that doesn’t help with CosmosDBs that use the Core API.

Would you be able to write this yourself? The Redash team usually doesn’t add query runners unless they have a demo environment for testing.