Problem

When approaching the CrateDB SQLAlchemy dialect with an erroneous connection string including the database path parameter, like crate://localhost/dbname, it fails using this exception message:

(crate.client.exceptions.ProgrammingError) Connection.__init__() got an unexpected keyword argument 'database'

The error message may be improved, specifically because this works well with other databases. However, it can't work with CrateDB, because it does not understand the concept of "databases" at all, but uses "schemas" instead.

References

• AutoML: Improve notebooks for easier usage on Google Colab cratedb-examples#174 (comment)