Question 180567 in Ubuntu Question posted in
The official Ubuntu documentation can be found here.

Can Ubuntu connect Apache Superset to Apache Drill with Sql Alchemy?

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.

Tags:

2

Answers


  1. Chosen as BEST ANSWER
    0

    Resolved issue by adding the

    requirements-local.txt

    file in the docker folder and specifying the dependencies.


  2. 0

    If had to guess, the problem originates from something like what you’ve been discussing with @snakecharmerb in the comments. Perhaps you’re running Superset inside a Docker container but installed sqlalchemy-drill outside that Docker container?

    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search