I am trying to add a postgres database to superset. This is my connection URI: postgresql://username:password@localhost/mydatabase. I keep getting the following error while trying to test connection: No module named psycopg2 !
I made sure I installed this module using pip install psycopg2 in shell but it's still not working!
Thank you @Nishant Bangarwa! "No module psycopg2" solved! Though I am getting another error now: Error: Fatal: no pg_hba.conf entry for host "x.x.x.x", user "x", database "x", SSL off. Plus, I am not sure about the user & password for my Postgres database