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?

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

It looks like the JDBC API was released fairly recently (October 2020): https://pypi.org/project/sqlalchemy-jdbcapi/

Is there SQLAlchemy dialect support JDBC?

Tags:

sqlalchemy

superset

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?

772

asked Nov 21 '17 08:11

robert

2 Answers

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

134

answered Oct 05 '22 20:10

Euan

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

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

answered Oct 05 '22 20:10

RianLauw

Related questions
                            
                                Connection is closed when a SQLAlchemy event triggers a Celery task
                            
                                SQLAlchemy: filter by relationship
                            
                                Define name for column func.count in sqlalchemy
                            
                                SQLAlchemy order_by string column with int values
                            
                                How can I get a connection URL from an SQLAlchemy Engine instance?
                            
                                SSH tunnel forwarding with jump host and remote database
                            
                                When inheriting SQLAlchemy class from abstract class exception thrown: metaclass conflict: the metaclass of a derived class must be
                            
                                Define minimum length for PostgreSQL string column with SQLAlchemy
                            
                                flask "get_or_404" like function but with another status code
                            
                                Creating Stored Procedures with SQLAlchemy
                            
                                Completing object with its relations and avoiding unnecessary queries in sqlalchemy
                            
                                connecting sqlalchemy to MSAccess
                            
                                sqlalchemy connect to server, with not specify database
                            
                                Use sqlalchemy to select only one row from related table
                            
                                Sqlalchemy - Updating row with a filter produces List Index Error
                            
                                Flask Admin Custom Form Validation for Multiple Fields?
                            
                                Output SQL as string from pandas.DataFrame.to_sql
                            
                                Using bulk_insert_mappings
                            
                                Setting an index limit in SQLAlchemy
                            
                                Calculate DATEDIFF in POSTGRES using SQLAlchemy

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!

Donate Us With