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

KNOWLEDGE BASE

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

Issue

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.

Environment

Tableau Prep Builder 2022.2
Redshift
Append to Table

Resolution

Workaround

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.