KNOWLEDGE BASE

Temp Tables Created in Redshift Data Source when Publishing


Published: 23 May 2014
Last Modified Date: 10 Oct 2014

Issue

When you publish workbooks connected to Redshift data sources to Tableau Server or Tableau Online, temporary tables with a _tableau prefix in the name might be created in the Redshift data source.

Environment

  • Tableau Desktop
  • Tableau Server
  • Tableau Online
  • Amazon Redshift

Resolution

Option 1

Work with your Redshift database administrator to revoke CREATE privileges from the user account used to connect to Redshift. For more information, see Default Database User Privileges and GRANT in AWS Documentation.

Option 2

Use a custom TDC file that includes the setting:

CAP_CREATE_TEMP_TABLES = No

For more information about creating and using TDC files, see Customizing and Tuning ODBC Connections in the Tableau Knowledge Base.

Cause

The Redshift data source allows Tableau Desktop and Tableau Server or Tableau Online to create temporary tables in the Redshift database. Tableau checks to see if CREATE privileges are granted, and if they are, Tableau will create temporary tables as needed.
Did this article resolve the issue?