KNOWLEDGE BASE

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"
Did this article resolve the issue?