Another approach would be to create an SSH tunnel from your local macbook pro to the remote Linode VPS, configured so Redash (running on the macbook) can query PostgreSQL over the connection.
This is what I’m doing presently, for connecting to a remote host on Scaleway (instead of Linode). The raw command line to run is:
ssh -L127.0.0.1:5431:127.0.0.1:5432 -N linodeserver &
linodeserver should be the DNS name, or IP address, of your Linode VPS.
With that command run, ssh will start listening on port 5431. Anything that connects to it will be transparently connected through to 127.0.0.1 (localhost), port 5432 on the remote server.
You tell Redash to run queries against
127.0.0.1:5431 (localhost on your macbook), and ssh will do the tunneling between things.
That may be more secure than setting up Redash on a remote server if you’re not comfortable with securing servers on the internet. If you have a team that can secure a remote server for you though, that may be the better option.