We have a scenario where a docker container which has python 3.8 as base image and built on top of meltano ETL framework(opern source) is deployed in cloudrun in GCP.
This container is invoked from composer DAG.
The code in docker container(meltano framework) is supposed to extrat data from MSSQL server and load it to GCP BigQuery.
But it throws an error on execution "INFOrootpymssql._mssql.MSSQLDriverException: Connection to the database failed for an unknown reason."
We already installed pymssql(version 2.2.8) and can be seen inside docker image. Installation of prior versions of pymssql is failing
We suspect the issue could be due to the version of pymssql(2.2.8) version used, some dependent packages missig for prior versions of pymssql or with the way connection string is created for pymssql connection.
Please share your ideas as well based on your experience to help us troubleshoot this.