Metaplane supports both SSH tunnels and reverse SSH tunnels for secure data warehouse access.
When configuring a source, press Use SSH Tunnel to configure the
If you are unable to provide direct port access to your instance, you can connect Metaplane to your database using a Reverse SSH Tunnel.
To get started, please provide the Metaplane sales engineering team with the following information:
- The public key corresponding to the SSH keypair you are using the establish the tunnel
- The IP address(es) of machines from which you'll be connecting to the Metaplane SSH server
After sending this information, our team will set up a secure SSH server and provide the SSH host, SSH user, and tunnel port number that you will need to establish the SSH connection.
We recommend using autossh, which will manage the lifecycle of the SSH connection, automatically restarting the tunnel if it goes down.
autossh -M 0 -f -N -R <TUNNEL_PORT>:<DATABASE_HOST_OR_IP>:<DATABASE_PORT> -i <SSH_PRIVATE_KEY> <METAPLANE_SSH_USER>@<METAPLANE_SSH_HOST> -o ServerAliveCountMax=1 -o ServerAliveInterval=10 -o ExitOnForwardFailure=yes
If you run into issues, please contact [email protected]
Updated over 1 year ago