Why does my Redshift connection work on DBeaver but not on VSCode SQLTools?

Question

I'm relatively new to SQL, but currently I'm using a VPN trying to connect into a Redshift database. Here are some of the details

Driver Name : AWS / Redshift
Host : 10.x.xxx.48
Port : 5439
Username : user_name
Database : database_name
SSL False

On my DBeaver, all of the details work, and I can connect to the DB. However, in my VSCode, I'm using

Driver : Redshift Driver (Dedicated ver)
Server Address : 10.x.xxx.48
Port : 5439
username : same as above
database : same as above
SSL Disabled

and I'm getting this error:

Error opening connection no pg_hba.conf entry for host "::ffff:10.16.14.166", user "user_name", database "database_name", SSL off

Anyone know why this happens and how to fix it? I want to emphasise that this is a company connection and I'm not the root user so I can't edit anything server-wise.

Answer 1

Note, the recommended way to connect to Redshift on VSCode is through the AWS Toolkit for Visual Studio Code.

https://docs.aws.amazon.com/toolkit-for-vscode/latest/userguide/redshift.html