I have been issues loading anything using the snowflake bulk loader. I did download the latest driver and I have attempted to follow the instructions my IS team has given me, however, it keeps giving me errors and doesn't like any of the data I give it.
Here is a list of the errors I get- I try to eliminate the columns giving me the error just see if I can get anything through.
Output Data (5) DataWrap2ODBC::SendBatch: String '62000' is too long and would be truncated Insert into "TUBEFAB"."RMTRANSACTION"("ITNBR","HOUSE","UPDDT","TRNDT","UPDTM","TCODE","TRQTY","ORDNO","DPTNO","WKCTR","OPSEQ_1","TBCDE","SRLHU","BADGE") Values (?,?,?,?,?,?,?,?,?,?,?,?,?,?)
Error: Output Data (5): DataWrap2ODBC::SendBatch: String '0100' is too long and would be truncated Insert into "RMTRANSACTION"("ITNBR","HOUSE","UPDDT","TRNDT","UPDTM","TCODE","TRQTY","ORDNO","DPTNO","OPSEQ_1","TBCDE","SRLHU","BADGE") Values (?,?,?,?,?,?,?,?,?,?,?,?,?)
Output Data (5) DataWrap2ODBC::SendBatch: String '1160717' is too long and would be truncated Insert into "TUBEFAB"."RMTRANSACTION"("ITNBR","HOUSE","UPDDT","TRNDT","UPDTM","TCODE","TRQTY","ORDNO","DPTNO","TBCDE","SRLHU","BADGE") Values (?,?,?,?,?,?,?,?,?,?,?,?)
Error: Output Data (5): DataWrap2ODBC::SendBatch: Numeric value '7279' is out of range Insert into "TUBEFAB"."RMTRANSACTION"("ITNBR","HOUSE","UPDTM","TCODE","TRQTY","ORDNO","DPTNO","TBCDE","SRLHU","BADGE") Values (?,?,?,?,?,?,?,?,?,?)
I tried to start from ground zero and simplify it so I can get it working before I try any of the data transforming and cleansing that I want to do so this is how I currently have my workflow looking
HI @Daflinders
Seems like it can be related to your data types. Try to increase the size for your string values and see if it works for string values. Let me know.
I tried adjusting the range and it still isn't liking it. It gives me another error
I even tried changing the data type to an 64integer and I still get the same error as shown in my previous comment.
Hi @Daflinders,
Try and change the Data size in your snowflake table where you are trying to insert the values.
It seems that it is giving me a new error now. I don't know why the the error changed but I'm guessing this is closer to the actual problem? Suggestions?