GitHub user dosubot[bot] added a comment to the discussion: Production 
deployment issue in

<!-- Answer -->
The reason Superset is still connecting to the internal database is that the 
Helm chart does not use the externalDatabase block for its connection settings. 
Instead, it builds the database connection URI from the 
supersetNode.connections.* fields (db_host, db_port, db_user, db_pass, db_name) 
and not from extraEnv or externalDatabase. If you don’t set these fields, it 
defaults to the internal DB—even if you disable postgresql.enabled.

To fix this, add the following to your values.yaml (replace with your actual 
Azure DB values):

```yaml
supersetNode:
  connections:
    db_host: appsqlsscind01.private.postgres.database.azure.com
    db_port: "5432"
    db_user: sspsqladmin
    db_pass: Password123?sslmode=require
    db_name: superset
```

You can remove the externalDatabase block—it is ignored by the chart. Make sure 
you do not set SQLALCHEMY_DATABASE_URI directly anywhere else. After updating, 
redeploy with Helm and check pod logs to confirm Superset is using your 
external DB.

Reference: [Helm chart values and connection 
logic](https://github.com/apache/superset/blob/e3cbbca4f92b657ed7b4faa18ca661f8c2967831/helm/superset/values.yaml),
 [Helm chart template for 
SQLALCHEMY_DATABASE_URI](https://github.com/apache/superset/blob/e3cbbca4f92b657ed7b4faa18ca661f8c2967831/helm/superset/templates/_helpers.tpl)


<!-- 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/a8af23fd-368b-40bb-af11-6cea02f4f535?feedback_type=great_response)
 | 
[Irrelevant](https://app.dosu.dev/response-feedback/a8af23fd-368b-40bb-af11-6cea02f4f535?feedback_type=irrelevant_answer)
 | 
[Incorrect](https://app.dosu.dev/response-feedback/a8af23fd-368b-40bb-af11-6cea02f4f535?feedback_type=incorrect_sources)
 | 
[Verbose](https://app.dosu.dev/response-feedback/a8af23fd-368b-40bb-af11-6cea02f4f535?feedback_type=too_verbose)
 | 
[Hallucination](https://app.dosu.dev/response-feedback/a8af23fd-368b-40bb-af11-6cea02f4f535?feedback_type=hallucination)
 | [Report 
🐛](https://app.dosu.dev/response-feedback/a8af23fd-368b-40bb-af11-6cea02f4f535?feedback_type=bug_report)
 | 
[Other](https://app.dosu.dev/response-feedback/a8af23fd-368b-40bb-af11-6cea02f4f535?feedback_type=other)</sup>&nbsp;&nbsp;[![Join
 
Discord](https://img.shields.io/badge/join-5865F2?logo=discord&logoColor=white&label=)](https://go.dosu.dev/discord-bot)&nbsp;[![Sh
 are on 
X](https://img.shields.io/badge/X-share-black)](https://twitter.com/intent/tweet?text=%40dosu_ai%20helped%20me%20solve%20this%20issue!&url=https%3A//github.com/apache/superset/issues/33945)

GitHub link: 
https://github.com/apache/superset/discussions/33957#discussioncomment-13599739

----
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]

Reply via email to