GitHub user dosubot[bot] added a comment to the discussion: PortalDB database connection is dialect
<!-- Answer --> Since it's a PostgreSQL database, here's what you need: **1. Install the PostgreSQL driver** (if not already installed): ```bash pip install psycopg2 ``` Or if you're using Docker, add to `docker/requirements-local.txt`: ``` psycopg2-binary ``` **2. Use this SQLAlchemy URI format** when adding the database connection in Superset: ``` postgresql+psycopg2://username:password@host:5432/PortalDB ``` Replace `username`, `password`, `host`, and `5432` (if your port differs) with your actual database credentials. **3. Restart Superset** after installing the driver. If you're still seeing the dialect error after this, could you share the exact SQLAlchemy URI you're entering (with the password redacted) and the full error message? That will help pinpoint the issue. <!-- Dosu Comment Footer --> *To reply, just mention [@dosu](https://go.dosu.dev/dosubot?utm_source=github&utm_medium=bot-comment&utm_campaign=github-comment-footer-20260415&utm_content=reply-with-mention&utm_term=apache%2Fsuperset).* --- Share context across your team and agents. Try [Dosu](https://dosu.dev?utm_source=github&utm_medium=bot-comment&utm_campaign=github-comment-footer-20260415&utm_content=knowledge-infrastructure-tagline&utm_term=apache%2Fsuperset). [](https://app.dosu.dev/response-feedback?utm_source=github&utm_medium=bot-comment&utm_campaign=github-comment-footer-20260415&utm_content=knowledge-infrastructure-feedback&utm_term=apache%2Fsuperset&message_id=d7cd2ef8-c9d4-4258-8527-249b269b88ee) [](https://github.dosu.com/apache/superset?utm_source=github&utm_medium=bot-comment&utm_campaign=github-comment-footer-20260415&utm_content=knowledge-infrastructure-learn-repo&utm_term=apache%2Fsuperset) [](https://app.dosu.dev/signup?referrer=openSource&source=github-footer&utm_source=github&utm_medium=bot-comment&utm_campaign=github-comment-footer-20260415&utm_content=knowledge-infrastructure-add-team&utm_term=apache%2Fsuperset) GitHub link: https://github.com/apache/superset/discussions/40073#discussioncomment-16894647 ---- 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]
