Loading

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

Julkaisupäivä: Apr 13, 2024
Kuvaus

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.

​

Cause

This is a known issue under investigation - Issue ID: W-14256773
Ratkaisu

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.
 
Knowledge-artikkelin numero

001497616

 
Ladataan
Salesforce Help | Article