Hey Team!
I'm scratching my head over a problem that I'm sure one of the gurus on here can help with.
I have some very large spatial files that I need to store in a Snowflake environment.
Snowflake has a few big issues when it comes to spatial data. It has very strict acceptance criteria on anything submitted as geometry so we have decided to store all of the spatial information as a binary field to pull out later (using GeometryExtractor) .
However when writing this binary attribute to snowflake there is a size limit of 16MB... and when some of your features have over a million vertices this is not really going to work.
We are looking into storing the FME binary over a number of attributes (_geom1, _geom2, ect.) to stick back together when needed, but cant get any string based functions to work due to it now being in binary format. I have tried substring extractors and attribute compressors with not much luck.
Any Idea?