MSSQL does not have pyodbc in virtual environment

[yeldeeb]

Describe the bug When running MSSQL ingestion in runtime, the ingestion is failed due to missing pyodbc in venv of the ingestion. I created my custom docker image for datahub-actions as follows because the datahub-action image does not have ODBC:

FROM acryldata/datahub-actions:head

RUN curl https://packages.microsoft.com/keys/microsoft.asc | tee /etc/apt/trusted.gpg.d/microsoft.asc
RUN echo "deb [arch=amd64,arm64,armhf] https://packages.microsoft.com/debian/12/prod bookworm main" > /etc/apt/sources.list.d/mssql-release.list
RUN apt-get update
RUN ACCEPT_EULA=Y apt-get install -y msodbcsql18
USER datahub

Ingestion failed because it creates a venv in runtime that should have the package "pyodbc". I can't install the in image as this runs in runtime of ingestion.

To Reproduce Steps to reproduce the behavior:

1. Go to '...'
2. Click on '....'
3. Scroll down to '....'
4. See error

Expected behavior A clear and concise description of what you expected to happen.

Screenshots If applicable, add screenshots to help explain your problem.

Additional context Add any other context about the problem here.

[yeldeeb]

similar to this issue https://github.com/datahub-project/datahub/issues/9298

[github-actions[bot]]

This issue is stale because it has been open for 30 days with no activity. If you believe this is still an issue on the latest DataHub release please leave a comment with the version that you tested it with. If this is a question/discussion please head to https://slack.datahubproject.io. For feature requests please use https://feature-requests.datahubproject.io

[github-actions[bot]]

This issue was closed because it has been inactive for 30 days since being marked as stale.