Where is the datasource connection (userid/ pwd) credentials stored

Issue Summary

We are having a self hosted dockerized version of redash.Redash connects to postgress datasource.
Could you please let me know as to where does redash stores the datasource credentials keyed into the redash add datasource tab.

In case redash is storing the password into the dockerised postgress, could you please let me know the table name and column that stores the password.

Technical details:

  • Redash Version: 7.0.0
  • Browser/OS: chrome
  • How did you install Redash:Dockerised (Self hosted)

Redash persists Data Source objects to the data_sources table in Postgres. Since v7.0, the data source options (URL, username, password, port etc) are encrypted with the application’s secret key. So you won’t be able to SELECT then normally. Here’s the relevant line in the Redash source.