Unable to access remote database without SSH

I have a bunch of queries which were previously connected to a remote AWS database and working fine. However, I have recently needed to access a different remote AWS database - via SSH (see connection details below.)

This connects successfully and I can fetch the data in the Database Manager.

I have updated my queries to reference the new database, yet when I deploy my page the data is missing. Here is the error generated:

I assume I’m missing something quite obvious, but can’t quite work out what to do next. Any help would be appreciated.

Cheers.

Community Page
Last updated: