07-13-2022 03:17 PM
I am trying to migrate the data from MySQL to Snowflake DB. I am getting th following error message with snowflake bulk load snap.
I have entered the data for all the columns but still getting the same error.
“reason”:
“The·input·to·the·SF·Bulk·Load·snap·should·contain·the·column·values·to·load·into·SF·database.”
“resolution”:
“All·columns·which·do·not·have·default·values·have·to·be·specified·in·the·input·document.”
“status_code”:
“error”
“snap_details”:{
“label”:“Snowflake·-·Bulk·Load”,“instance_id”:“eb0986a2-ccf4-4c13-90d3-219924d9b3a8”,“class_id”:“com-snaplogic-snaps-snowflake-bulkload”,“build_tag”:“429patches16458”,“views”:{…}
06-16-2023 04:30 PM
Your target system i.e. snowflake doesn’t have all the columns defined; meaning for instance, your upstream has 5 columns, snowflake has been defined with less than 5 columns thus data couldn’t be ingested.
Try to have a mapper before snowflake snap and if you have defined 3 cols, specify those 3 in the mapper prior and you will not see any error on execution.