Output Error Msg: "DataWrap2ODBC: Numeric Precision Data Will be Lost"

[svora]

Hello fellow Alteryx members,

I am trying put all my workflow data into a Teradata table but get the following message in output:

"DataWrap2ODBC:: send batch:[Teradata][ODBC Teradata Driver] Numeric Precision Data Will be Lost INSERT into..... values (?????)"

I made sure the same columns from my select tool --> going to my output match my table columns, but not sure what this error means.

Anyone else come accross this error?!

Thanks!

Sabeen Vora

[patrick_mcauliffe · Accepted solution]

@svora  this is usually caused by a field being the wrong type for the data it contains.

If you're loading into an existing table, make sure that the type of field used in the table is of equivalence to what you're outputting from Alteryx (ie. if the field is a BigInt in Teradata, it would be a Int64 in Alteryx).

[svora]

@patrick_mcauliffe that was it!

In Teradata I had Int instead of BigInt for all my Int64 data types in Alteryx.

Next time, I am going to utilize the 'create table' option in the output to avoid these errors, then can change the output option to 'delete data & append' after successfully loading into the table.

Thank YOU!

svora