KNOWLEDGE BASE

Unable to Connect to Snowflake From a Workbook That Was Created From a Computer That Required Proxy Configuration


Published: 29 Oct 2021
Last Modified Date: 30 Oct 2021

Issue

Unable to connect to Snowflake DB from a workbook that was created from a computer that required proxy configuration. New connections to the same Snowflake DB was possible from the affected computer.

Description of the situation:
A workbook is created from a computer on Environment-A. This workbook is then shared with a user with a computer on Environment-B. From Environment-B it is not possible to connect to Snowflake when opening the workbook, but new connections to the same Database can be created.

Environment-A:
When connecting to Snowflake from Tableau Desktop requires a proxy to be passed via Custom Driver Parameters from the Advanced tab.

Environment-B:
Does not require any Custom Driver Parameters.

Environment

  • Tableau Desktop
  • Snowflake
  • Proxy

Resolution

Create a Tableau Data source Customization (TDC) file and place in "My Tableau Repository/ Datasources" for Tableau Desktop. 

Create a TDC file as follows:

TDC - Environment-A:
<?xml version='1.0' encoding='utf-8' ?>
<connection-customization class='snowflake' enabled='true' version='10.5'>
<vendor name='snowflake' />
<driver name='snowflake' />
<customizations>
<customization name='odbc-connect-string-extras' value='proxy=http://192.162.1.10:8888' />
</customizations>
</connection-customization>
 
TDC - Environment-B:
<?xml version='1.0' encoding='utf-8' ?>
<connection-customization class='snowflake' enabled='true' version='10.5'>
<vendor name='snowflake' />
 <driver name='snowflake' />
<customizations>
 <customization name='odbc-connect-string-extras' value='' />
</customizations>
</connection-customization>

As the Environment-B does not require any additional configuration, the TDC file above will ensure the connection does not have any customization that was embedded when the workbook was created in Environment-A.

Note: Tableau does not test or support TDC files. These files should be used as a tool to explore or occasionally address issues with your data connection. Creating and maintaining TDC files requires careful manual editing, and there is no support for sharing these files.

Cause

The distinct environment requires distinct connection driver parameters (proxy) to connect to Snowflake.

Additional Information

TDC files is a way to create connection customization parameters when Tableau is connecting to a data source, once the new connection matches the information in the TDC file, the customizations for that specific data source, for example, Snowflake, will have the parameters applied.
 
The location of the files can be seen on: For more information, see: 
Did this article resolve the issue?