Hi,
I downloaded the denodo dialect for python connexion to use with sqlAlchemy on the support site. (Denodo Dialect for SQLAlchemy).
I tried to add the dialect like I was told in this article : https://community.denodo.com/docs/html/document/denodoconnects/8.0/en/Denodo%20Dialect%20for%20SQLAlchemy%20(feat.%20support%20for%20Apache%20Superset%20and%20Jupyter%20Notebook)%20-%20User%20Manual
Sadly, that doesnt work. I got an error not finding the module.
Traceback (most recent call last):
File "C:/projets/poc-requete-complexe2/src/dockerlab/docker_write_high_volume.py", line 21, in <module>
engine = create_engine(f'denodo://{user}:{password}@{host}/{database}')
File "<string>", line 2, in create_engine
File "C:\projets\poc-requete-complexe2\venv\lib\site-packages\sqlalchemy\util\deprecations.py", line 298, in warned
return fn(*args, **kwargs)
File "C:\projets\poc-requete-complexe2\venv\lib\site-packages\sqlalchemy\engine\create.py", line 522, in create_engine
entrypoint = u._get_entrypoint()
File "C:\projets\poc-requete-complexe2\venv\lib\site-packages\sqlalchemy\engine\url.py", line 653, in _get_entrypoint
cls = registry.load(name)
File "C:\projets\poc-requete-complexe2\venv\lib\site-packages\sqlalchemy\util\langhelpers.py", line 339, in load
raise exc.NoSuchModuleError(
sqlalchemy.exc.NoSuchModuleError: Can't load plugin: sqlalchemy.dialects:denodo
I did add the dialect in my venv under : venv\Lib\site-packages\sqlalchemy\dialects
Here's my code for connexion :
engine = create_engine(f'denodo://{user}:{password}@{host}/{database}')
Thanks for your help,
David