Troubleshooting data ingestion issue from Hana with missing SQLAlchemy package

troubleshoot
1

Original Slack Thread

Hi guys, I am facing problems while ingesting data from Hana, has anyone faced this issue below the log

    for wu in stream:
  File "/usr/local/lib/python3.10/site-packages/datahub/ingestion/api/source_helpers.py", line 150, in auto_materialize_referenced_tags
    for wu in stream:
  File "/usr/local/lib/python3.10/site-packages/datahub/ingestion/api/source_helpers.py", line 64, in auto_status_aspect
    for wu in stream:
  File "/usr/local/lib/python3.10/site-packages/datahub/ingestion/source/sql/sql_common.py", line 482, in get_workunits_internal
    for inspector in self.get_inspectors():
  File "/usr/local/lib/python3.10/site-packages/datahub/ingestion/source/sql/sql_common.py", line 363, in get_inspectors
    engine = create_engine(url, **self.config.options)
  File "<string>", line 2, in create_engine
  File "/usr/local/lib/python3.10/site-packages/sqlalchemy/util/deprecations.py", line 309, in warned
    return fn(*args, **kwargs)
  File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/create.py", line 522, in create_engine
    entrypoint = u._get_entrypoint()
  File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/url.py", line 655, in _get_entrypoint
    cls = registry.load(name)
  File "/usr/local/lib/python3.10/site-packages/sqlalchemy/util/langhelpers.py", line 343, in load
    raise exc.NoSuchModuleError(
sqlalchemy.exc.NoSuchModuleError: Can't load plugin: sqlalchemy.dialects:hana.hdbcli```
2

Looks like the package is not or maybe not full installed. Please try to install the python package via pip install sqlalchemy-hana on your ‘datahub-actions’ node.

3

<@U05B3RG1PD1> Thanks for the reply , I wish it was easy the sqlalchemy-hana is already available