Skip to main content
Open

Add 'ON_ERROR' option settings to SnowFlake writer

Related products:Integrations
holmescm01
siennaatsafe
tcrossman
kennyo
martinkoch
+2
  • holmescm01
    holmescm01
  • siennaatsafe
    siennaatsafe
  • tcrossman
    tcrossman
  • kennyo
    kennyo
  • martinkoch
    martinkoch
  • terry.webber
    terry.webber
  • nickbroten

martinkoch
Supporter

I have been using the SnowFlake (spatial) writer now for some projects, and experience Snowflake to be quite picky when it comes to the geography it accepts...


Not particular Safe Softwares problem, but while struggling I often enountered


If you would like to continue loading when an error is encountered, use other values such as 'SKIP_FILE' or 'CONTINUE' for the ON_ERROR option. For more information on loading options, please run 'info loading_data' in a SQL client.


after the error message generated by the copy-command (copy-ing the contence of a .gz file to the table).


Could I please have some way of setting these ON_ERROR flags in the snowflake writer? Ofcourse aware of possible data corruption, I still would like them, if even only for debugging...


Kind regards,


Martin



0 replies

Be the first to reply!

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings