Loading

Unable to Connect to Amazon Athena via Proxy Server

Udgivelsesdato: May 19, 2025
Beskrivelse

Issue

Tableau Desktop or Tableau Server cannot connect to Amazon Athena via proxy server.

The following error messages can be seen in tabprotosrv.txt:

 

2017-11-16T16:18:24.252: 4984-31cc MSG 
throw DataSourceException (type=Unknown): com.tableausoftware.jdbc.TableauJDBCException: Exception while connecting to server. 
Unable to execute HTTP request: Connect to <database location>] failed: connect timed out 

 

Connecting via SQL Workbench also fails with the same error above. At the same time, users can connect to Amazon Athena via a browser.

 

Cause

Windows proxy server settings are not configured.

 

Løsning

Tableau will read the Windows proxy server settings automatically. If proxy settings are not configured at the OS level, an athena.properties file can be used instead.

Set key-value pairs of proxy_host, proxy_port in athena.properties file.
 

1. Create a text file (Use ISO-8859-1/Latin-1 encoding, without BOM, Byte-Order-Mark) and name it athena.properties.
2. Set following key-value pairs in athena.properties.
 
proxy_host=<proxy hostname or IP address>
proxy_port=<the port proxy server uses>

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

For Tableau Desktop:  ...\My Tableau Repository\Datasources

For Tableau Prep Builder: ...\My Tableau Prep Repository\Datasources

Server: C:\Program Files\Tableau\Tableau Server\data\tabsvc\vizqlserver\Datasources
C:\Program Files\Tableau\Tableau Server\packages\bin.<build number>

Virtual Connections: C:\Program Files\Tableau\Tableau Server\data\tabsvc\minerva\Datasources

Prep Flows: C:\Program Files\Tableau\Tableau Server\data\tabsvc\flowprocessor\Datasources

Prep Web Authoring: C:\Program Files\Tableau\Tableau Server\data\tabsvc\flowminerva\Datasources


If it is not English Windows, but for example Japanese Windows, place the properties file in the localized named directory such as "データソース"

4. Restart Tableau Desktop or Tableau Server.

If Tableau Desktop or Tableau Server is properly reading athena.properties, following messages can be seen in tabprotosrv.txt:
 
{"ts":"2017-12-12T18:14:00.426","pid":15776,"tid":"3720","sev":"info","req":"-","sess":"-","site":"{XXXXXXXX-XXXX-XXXX-XXXXXXXXXXXXXXXXX}","user":"-","k":"jni-msg","v":"Jdbc custom connection properties: proxy_port=<proxy port>, proxy_host=<proxy host>","ctx":{"client-type":"vizportal","procid":"4572","requestID":"-","sessionid":"XXXXXXXXXXXXXXXXXXXXXXXX-0:0","tid":"9252","username":"tableauuser"}}
 
Note: If "proxy_host " and "proxy_port" do not work, try "ProxyHost" and "ProxyPort". 
 
Yderligere ressourcer

A similar issue can manifest which has a different solution. See Tableau Fails To Connect to Amazon Athena through Proxy With Error Code 37CE01A3 for more information.

If athena.properties is in UTF8 with BOM (EF BB BF) is attached in the first line, which prevents Tableau from reading key-value pairs properly like follows and results in failure of connection to Athena.

 

{"ts":"2017-12-12T18:44:00.541","pid":15776,"tid":"3720","sev":"info","req":"-","sess":"-","site":"{XXXXXXXX-XXXX-XXXX-XXXXXXXXXXXXXXXXX}","user":"-","k":"jni-msg","v":"Jdbc custom connection properties: proxy_port=<proxy port>, \u00ef\u00bb\u00bfproxy_host=<proxy host>","ctx":{"client-type":"vizportal","procid":"4572","requestID":"-","sessionid":"XXXXXXXXXXXXXXXXXXXXXXXX-0:0","tid":"9252","username":"tableauuser"}}


SQL Workbench can connect to Athena if additional properties are set in Extended Properties like follows. No space before and after "=" is required.

proxy_host=<proxy hostname or IP address>
proxy_port=<the port proxy server uses>

 

Vidensartikelnummer

001472847

 
Indlæser
Salesforce Help | Article