Hey everyone,
I'm writing some data into a Snowflake database and getting a geometry validation error on the Snowflake side: SnowflakeSQLException: Geography validation failed.
When I run it thru the FME GeometryValidator - it passes.
If I run it thru the SQLExecutor and call ST_ISVALID it returns false so in theory, I could call the SQLExecutor for every record however with a million records, this really isn't feasible.
I thought about grouping the inserts by 1000 and if it fails, run those 1000 thru the SQLExecutor however I couldn't figure out how to have the FeatureWriter continue if it fails on a group.
Does anyone have any ideas on how to get these records to continue. I really just want FME to remove any bad geometries and log which one's failed.
Thanks!