SSH: To EC2
adeemacdowell edited this page Jun 1, 2023
·
4 revisions
Get the private key from upstream as the .pem
In Bitvise - Create new profile
Host: ec2-13-126-59-222.ap-south-1.compute.amazonaws.com
Port: 22
Username: ubuntu
Initial Method: publickey
Elevation: Default
Click 'Client Key Manager'
Hit 'Import'
Browse to the .pem or .ppk file
Save and login
Use Snowflake to connect to EC2
Go to Settings > Tools > 'SSH Configurations'
Set Port = 22
Host = EC2 ip
Username = ubuntu
Auth Type = Key pair (putty)
Go to Settings > Tools > SSH Terminal
Select the ssh config and hit ok
Tool > Start SSH session
Create a new Data Source (Mysql)
Go to the SSH/SSL tab
Use SSH tunnel
Select the configuration that we created above
Hit apply
In the General tab, fill the inputs as per usual
Hit apply