Input Tool Truncating data (ODBC SQL Connection to Teradata DB)

phoebe_kelley

Hi, I am seeing some of my data being truncated by the input tool. I don't see an option in the tool to change field length for ODBC connections. I am connecting directly to our Teradata DB using SQL. When I pull the same data in Teradata, the data is not truncated.

For example, I have a text field with the data: "**PORK, WATER, BROWN SUGAR, GLUTEN FREE SOY SAUCE (WATER, ORGANIC SOYBEANS, SALT), SALT, CHILI PEPPER, SRIRACHA SEASONING [SPICES (INCLUDING CHILI), GARLIC POWDER, CORN STARCH, MALTODEXTRIN, SEA SALT, SUGAR, VINEGAR, ONION POWDER), CONTAINS 2% OR LESS OF CHILI POWDER, SPICES.**"

but on input to Alteryx, it truncates the last bit off: "**PORK, WATER, BROWN SUGAR, GLUTEN FREE SOY SAUCE (WATER, ORGANIC SOYBEANS, SALT), SALT, CHILI PEPPER, SRIRACHA SEASONING [SPICES (INCLUDING CHILI), GARLIC POWDER, CORN STARCH, MALTODEXTRIN, SEA SALT, SUGAR, VINEGAR, ONION POWDER), CONTAINS 2% OR LES..."

Here is my input tool config if that helps:

the SQL is not casting or transforming the field in any way, it should just pull it as-is. Any ideas?

thanks,

Phoebe

fmvizcaino

Hi @phoebe_kelley ,

Are you checking the data using a browse tool? If not, please check that out.

If that is not the problem, you could try to insert in the query the string size as well.

Best,

Fernando Vizcaino