Troubleshooting data ingestion issue from Hana with missing SQLAlchemy package

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

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.

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