crate-python
version 0.27.0 with a fix for https has been released
It is now possible to connect to tls/ssl secured clusters with:
crate://foo:bar@cratedb.example.org:4200/?ssl=true
crate-python
version 0.26.0 and older only
We recently published an updated blog post on using CrateDB with Apache Superset. Afterwards we noticed that a bug in the crate-python library prevents the usage of HTTPS connections.
Until this bug is fixed you can use the following workaround to use Apache Superset in combination with HTTPS.
Step 1
Add a database connection to CrateDB or edit your existing connection.
Step 2
Set the SQLAlchemy URI to crate://<username>:<password>@<url.to.cratedb.cluster>:4200/
Replace username, password and URL to your cluster.
Step 3
Switch to “Advanced Settings” => “Other” and set connect_args
in “Engine Parameters” as follows:
{"connect_args":{"servers":["https://<url.to.cratedb.cluster>:4200"]}}
Again replace the URL to your cluster accordingly.
Step 4
Test your connection and you should see the success message “Connection looks good!”. Press “Connect” or “Finish” to save your changes.