Via Windows

Use bitvise

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

Via Ubuntu

Use Snowflake to connect to EC2

Via Pycharm

SSH Terminal

(1) SSH Configurations

Go to Settings > Tools > 'SSH Configurations'

Set Port = 22

Host = EC2 ip

Username = ubuntu

Auth Type = Key pair (putty)

(2) SSH Terminal

Go to Settings > Tools > SSH Terminal

Select the ssh config and hit ok

(3) Start an SSH Session

Tool > Start SSH session

SSH Database Connection

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