Could not load database driver: MssqlEngineSpec (repost)

[dec818181]

When I test my connection using this connection string in the SQL Alchemy field: mssql+pymssql://myuser:mypass@mydbserver I get the error:
Could not load database driver: MssqlEngineSpec

I have run pip install pymssql and also added the following to my Dockerfile.

##  mssql
FROM apache/superset:4.0.0
RUN pip install pymssql
## / mssql

# ...

RUN python -m compileall /app/superset

I deleted all the containers then ran
docker compose up --build

There is a similar discussion but the solution there does not seem to be working for me.

[dosubot[bot]]

Hey there, @dec818181! I'm here to help you out with any bugs, questions, or contributions. Let's tackle this issue together!

There is a known issue with using the pymssql driver in Apache Superset, which results in the error message "Could not load database driver: MssqlEngineSpec" when testing the connection ^[1].

To troubleshoot this issue, ensure that the pymssql package is correctly installed in your Docker environment. You can verify this by checking the logs during the Docker build process to confirm that pymssql is installed without errors. Additionally, make sure that the SQLAlchemy URI is correctly formatted and that there are no typos in the connection string.

If the issue persists, consider using an alternative driver like pyodbc for connecting to MS SQL databases, as it might offer better compatibility with Superset. You can install pyodbc by adding RUN pip install pyodbc to your Dockerfile and adjusting your connection string accordingly.

To continue talking to Dosu, mention @dosu.

---

^{Help Dosu learn! Give it feedback: Great Response | Irrelevant Answer | Incorrect Sources | Too Verbose | Hallucination | Other}

[dec818181]

I started again and followed the install guide closely and it worked this time. Thank you.