Fail to Write Some Records Which Have More Than 3072 Characters in One Column to MS SQL Server

Published: 02 Sep 2021
Last Modified Date: 08 Sep 2021


When using Tableau Prep Builder on the web, some records which have more than 3072 characters in one column fail to be written to MS SQL Server.


  • Tableau Prep Builder 2021.2.2


Current workaround:
Adding a Clean node before the output node with the calculation: LEFT(<field>, 3072)


 This behavior is caused by a defect, ID 1292181, which is currently under investigation. 

Additional Information

For more information, see Tableau Prep on the Web

Up to 3072 characters can be written for text field values. Longer values will be truncated.
Did this article resolve the issue?