Is there SQLAlchemy dialect support JDBC?

Question

I want to connect superset to a database by a JDBC driver. But from what I find there is no a SQLAlchemy dialect ready for this purpose. The closest option may be jaydebeapi but it does not have a SQLAlchemy dialect either.

Question is if there is a way from SQLAlchemy DB Engine to connect a database through JDBC driver? Or is there a way to use JDBC driver in superset?

Answer 1

This something I keep coming up against - it's a real shame that neither the SQLAlchemy project nor the JayDeBeAPI project want to cross this bridge.

It would automatically enable so much additional functionality in any tool that chooses SQLAlchemy like Superset.

I understand that SQL Alchemy needs a deeper understanding of the specific DB's SQL dialect for it's ORM functionalty, but it should be fairly simple to implement a mostly functional generic JDBC layer and/or inherit the existing dialects.

The most up to date reference I can find is this:

JayDeBeAPI Comment

Answer 2

It looks like the JDBC API was released fairly recently (October 2020):

https://pypi.org/project/sqlalchemy-jdbcapi/