How to connect to Azure CosmosDB Core/SQL DB?

Hi!

I am running ReDash self-hosted on a Ubuntu VM. How do I connect to a CosmosDB Core SQL DB?

I can’t connect to it using ReDash as MongoDB, so I assume I should use either SQL Server or MySQL. However, there’s no ODBC driver for Linux https://docs.microsoft.com/en-us/azure/cosmos-db/odbc-driver.

The connection String that I am getting from Azure Portal for that DB is something like this:
AccountEndpoint=https://.documents.azure.com:443/;AccountKey=;

Did anyone successfully connect to that DB?

Thanks!