Apache Superset connection to Apache Drill with Sql Alchemy

Question

I am trying to setup Superset in my local. I have a windows system, so i used VM Virtual Box, with Ubuntu 22.04 to setup and run the superset. I followed the docker instructions. Used the docker compose up command in order to start.

The I installed the SQL Alchemy following the https://thedataist.com/visualize-anything-with-superset-and-drill tutorial.

I have an Apache Drill hosted on a server online.

When i try to add the database using the url drill+sadrill://external-ip:8047?use_ssl=False , i am getting the following error. sqlalchemy.exc.NoSuchModuleError: Can't load plugin: sqlalchemy.dialects:drill.sadrill

I have tried various solutons, any help would be appreciated.

Answer 1

Resolved issue by adding the

requirements-local.txt

file in the docker folder and specifying the dependencies.