KNOWLEDGE BASE

Cannot Connect To Spark SQL Or Databricks Through Proxy Server


Published: 25 Sep 2020
Last Modified Date: 14 Oct 2020

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

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