0

I am trying to connect superset 0.23.3 which is in hdp to sql server 2014(local machine) through sqlalchemy but facing an error regarding no module found. Attachments of my sqlalchemy connection string and error is given below:

This is the image of my connection string and it is correct as i ran this string in spyder and successfully connected with sql server

Error i am getting after clicking on test connection button

As it is saying in error no module found but it is already installed in site-packages under C:\Python36\Lib\

Already installed in site-packages folder

Connected sql server with python via sqlalchemy

Any help is highly appreciated. Thanks in advance

Hashaam
  • 11
  • 4
  • Are you in a position to connect to that DB directly in python via sqlAlchemy? – David Tobiano Feb 27 '20 at 18:29
  • Yes, It is successfully connected and retreiving records via sqlalchemy using spyder.. pls check image[5] i added recently.. – Hashaam Feb 27 '20 at 18:48
  • OK. Great. Are you running superset in your global python environment, or in a virtual one? – David Tobiano Feb 29 '20 at 18:33
  • virtual environment (hdp sandbox 2.6.5,windows 10) and (hdp sandbox 3.0,redhat) in which python 2.7 and 3.6 both are installed but everything installs in python2.7 through shell e.g. pip install pymssql – Hashaam Feb 29 '20 at 18:51
  • I meant your python virtual env (venv). When you installed superset, did you create a python virtual environment as recommended, and pip-installed everything in that venv? This would explain why you're not seeing the error when connecting through your global python env, but you're hitting it in superset's env. – David Tobiano Mar 01 '20 at 19:18
  • Yes, i have created venv in python directory as well as in hdp shell where superset is installed. – Hashaam Mar 03 '20 at 21:13

0 Answers0