We currently run a self-hosted Redash in our environment, and the endpoint for our Postgres instances will change often. We need to be able to, on deployment, run a script that will change the configuration settings of a data source. Is there an API endpoint or a good way to approach the problem?
Welcome to the forum and thanks for your question. You can use the /data_sources API endpoint to modify the connection details for a data source. it’s not really meant to change that frequently, though. So in your case it might make more sense to stand-up a proxy between Redash and your database. Then keep the proxy up-to-date.