[gdal-dev] Snowflake Vector Driver

[Zachary Déziel]

Hi Greg,

Thanks for sharing! We have some ongoing conversations with Snowflake's
team. Lobbying hard the idea of making them more interoperable with the
geospatial ecosystem.

Sharing any shortcomings you experienced during your POC without needing
too many details would help drive some points home.

Let me know if I can help, and I would love to chat.

*Zachary Déziel*
Product Manager
Anagraph.io


Le mar. 30 août 2022 à 13:18, Hans Gregers Hedegaard Petersen <
gregers at septima.dk> a écrit :

> Hi Zachary,
>
>
> So, do you know about any efforts to create a Snowflake Vector driver?
>> What would it take for this to happen?
>>
>
> Please do not see this as discouragement, but we tried to make sense out
> of Snowflakes models (both in and out), and  must say we were impressed by
> their xml-capabilities; they can take any kind of in data and make an
> output model out of it.
>
> But
> It
> Is
> A
> Pain(!!!)
> To try to figure out anything consistent with the out-model of it.
>
> A lot of “magic” happens in their mapping, so we basically took a handful
> or two of in data files and reverse engineered (read; performed informed
> guessing) the configuration used for those, so we could hopefully produce
> the corresponding INSPIRE XML configuration for GeoServer.
>
> We found that the same (or so it seemed) Snowflake configuration can
> produce several different outputs depending on version/context/input
> database column configuration etc
>
> The journey was long, and our client ended up deprecating the services
> with a long notice (counted in years) and built “the same” (functionally
> and not backwards compatible) in a week or two in GeoServer.
>
> If you need some specific input, I might find an hour or so to scavenge
> our POC. But I am quite sure it is not worth it without the snowflake
> secret sauce.
>
>
> Cheers,
>
> Greg
>
>
> --
>
> *Hans Gregers Hedegaard Petersen*
> Partner, Seniorkonsulent
> gregers at septima.dk
> --------------------------
> Septima P/S
> Frederiksberggade 19, 2.
> 1459 København K
> www.septima.dk
> Tlf: +45 7230 0672
> Direkte: +45 9132 6945
> Cvr: 34900841
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/gdal-dev/attachments/20220830/7291bcd5/attachment-0001.htm>