-2

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.

codeforHarman
  • 115
  • 1
  • 10
  • Have you installed the sadrill package https://pypi.org/project/sqlalchemy-drill/ ? – snakecharmerb Jun 01 '23 at 08:26
  • Yes, followed the instructions for all that – codeforHarman Jun 01 '23 at 08:34
  • 1
    Probably the package is installed in a different (virtual) environment from sqlalchemy. If you are following the instructions from the link, ensure that the `python` that calls `setup.py install` is the same `python` that you used to install `sqlalchemy`. – snakecharmerb Jun 01 '23 at 12:07
  • I have used same python i expect, is there any way to confirm this @snakecharmerb – codeforHarman Jun 01 '23 at 12:09
  • You can do `python -m pip list | grep -i sqlalchemy` assuming you have a bash shell. The output should be all installed packages for that python with sqlalchemy in their name. – snakecharmerb Jun 01 '23 at 12:12
  • SQLAlchemy 2.0.15 sqlalchemy-drill 1.1.4 SQLAlchemy-Utils 0.41.1 They are installed – codeforHarman Jun 01 '23 at 12:15
  • Let us [continue this discussion in chat](https://chat.stackoverflow.com/rooms/253916/discussion-between-codeforharman-and-snakecharmerb). – codeforHarman Jun 01 '23 at 12:15

1 Answers1

1

Resolved issue by adding the

requirements-local.txt

file in the docker folder and specifying the dependencies.

codeforHarman
  • 115
  • 1
  • 10