Connecting to Athena using SQL Tools extension

[adbdkb]

I am trying to set-up a VSCode connection using SQLTools to connect to Athena.

This is how I have the properties defined. I can logon to AWS Console and run Athena queries with the role that I am selecting.

This is my set-up

When I try to connect, I get this error

Error opening connection Inaccessible host: athena.us-east-1.amazonaws.com'. This service may not be available in the us-east-1' region.

Is there any additional setting I need to do or add any property in the json that gets generated ?

Appreciate any guidance

These are the errors I see in the output window for SQL Tools

[1683812646592] INFO (ext): EXECUTING COMMAND => sqltools.selectConnection [1683812646593] INFO (ext): EXECUTING COMMAND => sqltools.getConnections [1683812646612] INFO (ls): REQUEST RECEIVED => connection/GetConnectionsRequest [1683812646612] INFO (ext): EXECUTING COMMAND => sqltools.getConnections [1683812646613] INFO (ls): REQUEST RECEIVED => connection/GetConnectionsRequest [1683812646613] INFO (ls): REQUEST RECEIVED => connection/ConnectRequest [1683812646613] INFO (ls): Connection instance created for CCPS-PuSH-Athena. ns: "conn-manager" [1683812648019] ERROR (ls): Connecting error: {"code":-32001,"data":{"driver":"driver.athena","driverOptions":{}},"name":"UnknownEndpoint"} ns: "conn-manager" [1683812648019] ERROR (ls): Open connection error ns: "conn-manager" [1683812648020] ERROR (ext): ERROR: Error opening connection Inaccessible host: athena.us-east-1.amazonaws.com'. This service may not be available in the us-east-1' region., {"code":-32001,"data":{"driver":"driver.athena","driverOptions":{}}} ns: "error-handler" [1683813097036] INFO (ext): EXECUTING COMMAND => sqltools.openEditConnectionScreen [1683813097036] INFO (ext): EXECUTING COMMAND => sqltools.getConnections [1683813097037] INFO (ls): REQUEST RECEIVED => connection/GetConnectionsRequest [1683813097042] INFO (ext): getting extension brunoventura.sqltools-athena-driver information. ns: "ext-util" [1683813097042] INFO (ext): getting extension mtxr.sqltools-driver-pg information. ns: "ext-util" [1683813097042] INFO (ext): loaded extension information brunoventura.sqltools-athena-driver for driver driver.athena. ns: "ext-util" [1683813097043] INFO (ext): loaded extension information mtxr.sqltools-driver-pg for driver PostgreSQL/Cockroach. ns: "ext-util" [1683813097329] INFO (ext): getting extension brunoventura.sqltools-athena-driver information. ns: "ext-util" [1683813097329] INFO (ext): getting extension mtxr.sqltools-driver-pg information. ns: "ext-util" [1683813097329] INFO (ext): loaded extension information brunoventura.sqltools-athena-driver for driver driver.athena. ns: "ext-util" [1683813097329] INFO (ext): loaded extension information mtxr.sqltools-driver-pg for driver PostgreSQL/Cockroach. ns: "ext-util" [1683813129985] INFO (ext): EXECUTING COMMAND => sqltools.updateConnection [1683813130071] INFO (ext): Connection explorer changed. Will be updated. ns: "conn-man:explorer" [1683813130079] INFO (ext): EXECUTING COMMAND => sqltools.getConnections [1683813130080] INFO (ls): REQUEST RECEIVED => connection/GetConnectionsRequest [1683813130142] INFO (ext): Connection explorer changed. Will be updated. ns: "conn-man:explorer" [1683813130346] INFO (ext): EXECUTING COMMAND => sqltools.getConnections [1683813130346] INFO (ls): REQUEST RECEIVED => connection/GetConnectionsRequest [1683814557261] INFO (ext): EXECUTING COMMAND => sqltools.selectConnection [1683814557262] INFO (ext): EXECUTING COMMAND => sqltools.getConnections [1683814557263] INFO (ls): REQUEST RECEIVED => connection/GetConnectionsRequest [1683814557263] INFO (ext): EXECUTING COMMAND => sqltools.getConnections [1683814557264] INFO (ls): REQUEST RECEIVED => connection/GetConnectionsRequest [1683814557264] INFO (ls): REQUEST RECEIVED => connection/ConnectRequest [1683814557265] INFO (ls): Connection instance created for CCPS-PuSH-Athena. ns: "conn-manager" [1683814557828] ERROR (ls): Connecting error: {"code":-32001,"data":{"driver":"driver.athena","driverOptions":{}},"name":"UnknownEndpoint"} ns: "conn-manager" [1683814557829] ERROR (ls): Open connection error ns: "conn-manager" [1683814557830] ERROR (ext): ERROR: Error opening connection Inaccessible host: athena.us-east-1.amazonaws.com'. This service may not be available in the us-east-1' region., {"code":-32001,"data":{"driver":"driver.athena","driverOptions":{}}} ns: "error-handler"