GitHub user dosubot[bot] added a comment to the discussion: PortalDB database connection is dialect
<!-- Greeting --> Hi @kamya7! I'm [Dosu](https://go.dosu.dev/dosubot) and I’m helping the superset team. <!-- Answer --> The "dialect" error you're seeing when trying to connect your "PortalDB" database typically means **the required database driver is not installed** in your Superset environment. Superset uses SQLAlchemy under the hood, and each database type needs a specific Python driver package installed. Without it, Superset can't recognize the dialect in your connection URI. **To fix this:** 1. **Identify your database type** — What type of database is "PortalDB"? (PostgreSQL, MySQL, SQL Server, Oracle, etc.) 2. **Install the appropriate driver.** For example [[1]](https://github.com/apache/superset/blob/829e4d92d91ceae4b43b1ed3b063ffe45377799c/docs/docs/configuration/databases.mdx): ```bash pip install psycopg2 # PostgreSQL pip install mysqlclient # MySQL pip install pymssql # SQL Server pip install cx-Oracle # Oracle ``` 3. **Use the correct SQLAlchemy URI format** when adding the connection: ``` dialect+driver://username:password@host:port/database ``` For example: `postgresql+psycopg2://user:pass@host:5432/PortalDB` 4. **If using Docker**, add the driver to `docker/requirements-local.txt` [[1]](https://github.com/apache/superset/blob/829e4d92d91ceae4b43b1ed3b063ffe45377799c/docs/docs/configuration/databases.mdx): ```bash echo "psycopg2-binary" >> ./docker/requirements-local.txt ``` After installing the driver, restart Superset and try the connection again. Could you share what type of database "PortalDB" is and what SQLAlchemy URI you're using? That would help me give you the exact driver and URI format you need. <!-- 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).* --- Docs are dead. Just use [Dosu](https://dosu.dev?utm_source=github&utm_medium=bot-comment&utm_campaign=github-comment-footer-20260415&utm_content=static-docs-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=static-docs-feedback&utm_term=apache%2Fsuperset&message_id=93f52af6-8f76-40c6-b6fa-2899364d953b) [](https://github.dosu.com/apache/superset?utm_source=github&utm_medium=bot-comment&utm_campaign=github-comment-footer-20260415&utm_content=static-docs-ask-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=static-docs-share-team&utm_term=apache%2Fsuperset) GitHub link: https://github.com/apache/superset/discussions/40073#discussioncomment-16894634 ---- 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]
