How do I connect Great Expectations to a private Redshift cluster with SSH tunnel?

This AWS knowledge base article describes the steps of setting up an SSH tunnel and then pointing a client to the local post that will proxy to the private Redshift cluster:

Great Expectations is the client in this scenario, so specify localhost and the local port of your SSH tunnel when the CLI prompts you for the Redshift credentials.

Confirmed that this works if configured correctly! One tricky part is when the SSH tunnel is running, the DB connection information actually needs to point to localhost (not the remote DB host) and whichever port is on the local end of the tunnel

1 Like