GitHub user dosubot[bot] added a comment to the discussion: Unable to connect
to Dremio instance
<!-- Answer -->
You're correct—Dremio Community Edition does not support token authentication,
and username/password is the expected method for Arrow Flight connections in
Superset. The official Superset docs and recent updates show the recommended
format as `dremio+flight://{username}:{password}@{host}:32010/dremio` with
optional `?UseEncryption=true/false`
([docs](https://github.com/apache/superset/blob/829e4d92d91ceae4b43b1ed3b063ffe45377799c/docs/docs/configuration/databases.mdx),
[recent PR](https://github.com/apache/superset/pull/30315)).
If Datagrip works but Superset doesn't, the most common causes are: a mismatch
in the `sqlalchemy-dremio` driver version, special characters in the password
that need URL encoding, or SSL/certificate issues. Make sure your Superset
container uses `sqlalchemy-dremio >=1.2.1,<4` and that your connection string
is formatted and encoded exactly as in the docs. If you have special characters
in your password, encode them with `urllib.parse.quote_plus`. If SSL is enabled
on your Dremio instance, try adding
`?UseEncryption=true&disableCertificateVerification=true` to the connection
string.
If it still fails, try running the same connection string in a standalone
Python script with the same driver version as Superset to isolate whether the
issue is with the environment or the Superset integration.
<!-- Dosu Comment Footer -->
*To reply, just mention [@dosu](https://go.dosu.dev/dosubot).*
---
<sup>How did I do?
[Good](https://app.dosu.dev/response-feedback/357b664e-9bca-4d93-93d9-906d971b05a7?feedback_type=great_response)
|
[Irrelevant](https://app.dosu.dev/response-feedback/357b664e-9bca-4d93-93d9-906d971b05a7?feedback_type=irrelevant_answer)
|
[Incorrect](https://app.dosu.dev/response-feedback/357b664e-9bca-4d93-93d9-906d971b05a7?feedback_type=incorrect_sources)
|
[Verbose](https://app.dosu.dev/response-feedback/357b664e-9bca-4d93-93d9-906d971b05a7?feedback_type=too_verbose)
|
[Hallucination](https://app.dosu.dev/response-feedback/357b664e-9bca-4d93-93d9-906d971b05a7?feedback_type=hallucination)
| [Report
🐛](https://app.dosu.dev/response-feedback/357b664e-9bca-4d93-93d9-906d971b05a7?feedback_type=bug_report)
|
[Other](https://app.dosu.dev/response-feedback/357b664e-9bca-4d93-93d9-906d971b05a7?feedback_type=other)</sup> [](https://app.dosu.dev/a28d3c7e-a9d3-459e-9fb6-3a6f9ff4f357/ask?utm_source=github)&
nbsp;[](https://go.dosu.dev/discord-bot) [](https://twitter.com/intent/tweet?text=%40dosu_ai%20helped%20me%20solve%20this%20issue!&url=https%3A//github.com/apache/superset/discussions/34527)
GitHub link:
https://github.com/apache/superset/discussions/34527#discussioncomment-13978462
----
This is an automatically sent email for notifications@superset.apache.org.
To unsubscribe, please send an email to:
notifications-unsubscr...@superset.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscr...@superset.apache.org
For additional commands, e-mail: notifications-h...@superset.apache.org
