Defining Char Length When Writing The Output Of A Prep Flow To Db

Published: 13 May 2021
Last Modified Date: 08 Jul 2022

Question

Defining char length when writing the output of a prep flow to DB. Example: Using the char length for a field as varchar(50) always instead of default when writing the output back to DB

Environment

Tableau Prep Builder

Answer

As a possible workaround,

1. Create a Table in the DB with predefined DDL. Example: Varchar(50) for field in the DB

User-added image

2. When running the flow output choose Append to table or Replace data

User-added image

Additional Information

The ability to do this is not currently built in the product. Please vote for the following idea: https://community.tableau.com/s/idea/0874T000000HFcdQAG/detail