[gdal-dev] Snowflake Vector Driver

[Even Rouault]

Wondering if using the new (Geo)Parquet driver - 
https://gdal.org/drivers/vector/parquet.html - wouldn't help for 
interoperability with Snowflake ?

At least it should currently understand the non-geo part of it, and I 
presume the geo part will come at some point as it seems Snowflake 
support, among others, was one of the driver to develop GeoParquet

Le 30/08/2022 à 22:18, Hans Gregers Hedegaard Petersen 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 <http://www.septima.dk>
> Tlf: +45 7230 0672
> Direkte: +45 9132 6945
> Cvr: 34900841
>
>
> _______________________________________________
> gdal-dev mailing list
> gdal-dev at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/gdal-dev

-- 
http://www.spatialys.com
My software is free, but my time generally not.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/gdal-dev/attachments/20220830/802e6de3/attachment.htm>