cancel
Showing results for 
Search instead for 
Did you mean: 

Error message on snowflake bulkload

Sandy
New Contributor

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”:{…}

1 REPLY 1

darshthakkar
Valued Contributor

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.