How do I link Apache Superset and SQL Server?

Question

For database I chose 'other', and I used the correct URI, I installed pymssql. I had it in the requirements-local.txt in the docker folder.

I also tried pyodbc. I checked about everything I could. I always get this error:

ERROR: Could not load database driver: MssqlEngineSpec

Can anybody help me?

Also some of my imports don't seem to work:

from celery.schedules import crontab
from flask import Blueprint
from flask_appbuilder.security.manager import AUTH_DB
from flask_caching.backends.base import BaseCache

I just want to connect the db to superset.

Answer 1

I think that it's not necessary touch docker-compose. It's possible to add python packages in ./Docker/requirements-local.txt, like pymssql. When executing docker compose up, the builder executes requirements-local.txt to install other package.