Cannot Connect To Spark SQL Or Databricks Through Proxy Server

Issue

When using the Spark SQL / Databricks connector to connect to a Spark cluster (e.g. Apache Spark, Azure Databricks) through a proxy server,

the following error may occur in Tableau Desktop:

[Simba][ThriftExtension] (14) Unexpected response from server during a HTTP connection: connect() failed: errno = 10060.
User-added image

the following error may occur in Tableau Server after clicked the "Test Connection" in Edit Connections on Tableau Server:

Unable to connect to the server

Environment

Tableau Desktop
Tableau Server
Spark SQL
Databricks
Proxy Server

Resolution

For Tableau Desktop
Use the ODBC driver configuration options and the Other Databases (ODBC) connector.
1. Download Simba Spark ODBC driver version 2.6.8 or above.
2. Create a DSN (data source name) to accommodate the ODBC driver (Driver Download page) and configure the driver's Proxy Server Configuration Options in the [HTTP Proxy Options] dialog box. For more related information see Proxy Server Configuration Options.
User-added image

3. (Option) Depend on the authentication method of the Spark cluster and if it's an SSL Proxy Server, the [HTTP Options] and [SSL Options] may need to be configured.
User-added image

4. Use the Other Databases (ODBC) connector and select the above DSN to connect. For more information see Other Databases (ODBC).

For Tableau Server
Use the published data source that connecting via the above Other Databases (ODBC) connector. The Tableau Server administrator needs to create the same DSN and install the associated ODBC driver on the Tableau Server computer.

Cause

Tableau supported connector does not work with setting a proxy server by design.
Proxy Server Configuration Options needs to be configured via Simba Spark ODBC driver version 2.6.8 or above. For more information See Simba Spark ODBC Driver Release Notes.