How to Connect to Amazon Athena via Proxy Server That Requires Authentication (Username/Password)

Published: 14 Mar 2022
Last Modified Date: 15 Mar 2022

Question

How to Connect to Amazon Athena via Proxy Server That Requires Authentication (Username/Password)?

For example, the hostname and port number of the proxy could be added in [athena.properties] file, but in an environment where authentication information is required to connect to a proxy, where would the authentication information (username/password) be placed?

Environment

Tableau Desktop
Tableau Prep
Tableau Server
Proxy
Amazon Athena

Answer

To set key-value pairs of proxy_host, proxy_port, Username/Password in [athena.properties] file, follow the steps below.

1. Create a text file (Use ISO-8859-1/Latin-1 encoding, without BOM, Byte-Order-Mark) and name it [athena.properties].

2. Set the following key-value pairs in [athena.properties].

ProxyHost=<proxy hostname or IP address>
ProxyPort=<the port proxy server uses>
ProxyUID=<user name for accessing the server>
ProxyPWD=<password for accessing the server>

3. Place the [athena.properties] file in the following directories.

For Tableau Desktop: ...\My Tableau Repository\Datasources.
For Tableau Prep: ..\My Tableau Prep Repository\Datasources.
For Tableau Server: ...\Tableau Server Data Directory\tabsvc\vizqlserver\Datasources.

4. Restart Tableau Desktop/Tableau Prep or Tableau Server.

Note: If "ProxyHost" and "ProxyPort" do not work, try "proxy_host" and "proxy_port"