Temp Tables Created in Redshift Data Source when Publishing

Published: 23 May 2014
Last Modified Date: 27 Aug 2020


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.


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


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:


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


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 TEMPORARY privileges are granted, and if they are, Tableau will create temporary tables as needed.
Did this article resolve the issue?