Skip to main content
Open

Add 'ON_ERROR' option settings to SnowFlake writer

Related products:Integrations
siennaatsafe
danilo_fme
warrendev
kennyo
+6
  • siennaatsafe
    siennaatsafe
  • danilo_fme
    danilo_fme
  • warrendev
    warrendev
  • kennyo
    kennyo
  • michael.prior
  • anne_shanahan
  • mathew.cooper
    mathew.cooper
  • cwinfield
    cwinfield
  • geoal
    geoal
  • georgr
  • msennnoe

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