KNOWLEDGE BASE

Optimizing Redshift Connection Speed


Published: 18 Nov 2016
Last Modified Date: 10 Jul 2017

Question

How to get a better performance for a simple connection to Amazon Redshift from Tableau Desktop, as it may take a very long time to connect.

Environment

  • Tableau Desktop
  • Tableau Server
  • Amazon Redshift

Answer

Use a .tdc file similar to the one attached to this article. More information about this specific .tdc file can found in this third party article: Tableau Redshift TDC File.

Note: Although we make every effort to ensure links to external websites are accurate, up to date, and relevant, Tableau cannot take responsibility for the accuracy or freshness of pages maintained by external providers. Contact the external site for answers to questions regarding its content.

To use the tdc file, please follow these steps below: 
  1. Close Tableau Desktop. 
  2. Copy the .tdc file attached called 'Redshift_Test_Custom_connection.tdc' into the following folder : C:\Users\username\Documents\My Tableau Repository\Datasources\ 
  3. Open Tableau Desktop and try to connect.
Should you need to share it on Tableau Server, please read the following documentation to apply it to Redshift published data sources: Using a .tdc File with Tableau Server
Did this article resolve the issue?