Tableau Prep Sometimes Drops the Original Table in Redshift When Using [Append to Table] Option to Export Data to Redshift

Published: 11 Oct 2023
Last Modified Date: 13 Oct 2023


In Tableau Prep Builder, sometimes when using [Append to Table] in the output step to export data to Amazon Redshift, the error below occurs and the table to be UPDATED is deleted on the Redshift side.

System error: Error creating new table <table name>. If there was an existing table, it was removed, but no new table was created. Contact your administrator.


  • Tableau Prep Builder 2022.2
  • Redshift
  • Append to Table



Split the flow into 2 parts and output to Amazon Redshift as [Append to Table] from a local hyper file.

(1) Output to a local hyper file from the original flow.
(2) Create a new flow to publish the output of (1) to Redshift ( [Append to Table] ) and run it.


This is a known issue under investigation - Issue ID: W-14256773
Did this article resolve the issue?