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.
Problem
When approaching the CrateDB SQLAlchemy dialect with an erroneous connection string including the
database
path parameter, likecrate://localhost/dbname
, it fails using this exception message: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