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
