I am using the hosted Metabase service to connect to an AWS RDS Postgres instance in a private VPC. I am connecting using an SSH tunnel through an SSH bastion, configured through the UI. The connection works fine after I save the connection details, but eventually, it disconnects and never recovers. The only thing that fixes the connection is pressing the Save Changes button. The proposed workaround is to set up the SSH tunnel myself, which isn’t possible since this a hosted version on Metabase’s own servers.
What options do I have? Thanks in advance…
{
"browser-info": {
"language": "en-US",
"platform": "MacIntel",
"userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/87.0.4280.141 Safari/537.36",
"vendor": "Google Inc."
},
"system-info": {
"file.encoding": "UTF-8",
"java.runtime.name": "OpenJDK Runtime Environment",
"java.runtime.version": "11.0.7+10",
"java.vendor": "AdoptOpenJDK",
"java.vendor.url": "https://adoptopenjdk.net/",
"java.version": "11.0.7",
"java.vm.name": "OpenJDK 64-Bit Server VM",
"java.vm.version": "11.0.7+10",
"os.name": "Linux",
"os.version": "4.14.186-146.268.amzn2.x86_64",
"user.language": "en",
"user.timezone": "GMT"
},
"metabase-info": {
"databases": [
"h2",
"postgres"
],
"hosting-env": "unknown",
"application-database": "postgres",
"application-database-details": {
"database": {
"name": "PostgreSQL",
"version": "11.7"
},
"jdbc-driver": {
"name": "PostgreSQL JDBC Driver",
"version": "42.2.8"
}
},
"run-mode": "prod",
"version": {
"date": "2021-01-13",
"tag": "v1.37.6",
"branch": "release-x.37.x",
"hash": "344e5e0"
},
"settings": {
"report-timezone": null
}
}
}