acryldata/datahub-helm

MSSQL does not have pyodbc in virtual environment

deebify opened this issue · 3 comments

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.

similar to this issue datahub-project/datahub#9298

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

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