GitHub user munishsharma11dec added a comment to the discussion: Don't expose the username / password when importing datasource using import_datasource sqlalchemy_uri
I have seen similar issue with Postgresql Db. To rectify that I installed `psycopg2` driver as mentioned in [Installing database drivers for superset](https://superset.apache.org/docs/configuration/databases#installing-database-drivers). And I also tweaked the sqlalchemy uri a little bit and used `postgresql+psycopg2://{username}:{password}@{host}:{port}/{database}`. See the **_+psycopg2_** part that I used which hid the password from User interface and also from Database entry in `dbs` table of superset. I recommend you install **_clickhouse-connect_** and try sqlalchemy URI as follows `clickhousedb+clickhouse-connect://{username}:{password}@{hostname}:{port}/{database}` GitHub link: https://github.com/apache/superset/discussions/30984#discussioncomment-12636918 ---- This is an automatically sent email for [email protected]. To unsubscribe, please send an email to: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
