<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<p>Wondering if using the new (Geo)Parquet driver -
<a class="moz-txt-link-freetext" href="https://gdal.org/drivers/vector/parquet.html">https://gdal.org/drivers/vector/parquet.html</a> - wouldn't help for
interoperability with Snowflake ?</p>
<p>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<br>
</p>
<div class="moz-cite-prefix">Le 30/08/2022 à 22:18, Hans Gregers
Hedegaard Petersen a écrit :<br>
</div>
<blockquote type="cite"
cite="mid:CAA+ACAmoBWcNv90AZhNTFmF_Tn-DGLBRcOCU5Bb83FAD4vz2qA@mail.gmail.com">
<div>
<div dir="auto">Hi Zachary,</div>
</div>
<div>
<div dir="auto"><br>
</div>
<div dir="auto"><br>
</div>
<div>
<div class="gmail_quote">
<blockquote class="gmail_quote" dir="auto">
<div dir="ltr">
<div>So, do you know about any efforts to create a
Snowflake Vector driver? What would it take for this
to happen?</div>
</div>
</blockquote>
</div>
</div>
</div>
<div>
<div dir="auto"><br>
</div>
<div dir="auto">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.</div>
<div dir="auto"><br>
</div>
<div dir="auto">But</div>
<div dir="auto">It</div>
<div dir="auto">Is</div>
<div dir="auto">A</div>
<div dir="auto">Pain(!!!)</div>
<div dir="auto">To try to figure out anything consistent with
the out-model of it. </div>
<div dir="auto"><br>
</div>
<div dir="auto">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. </div>
<div dir="auto"><br>
</div>
<div dir="auto">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</div>
<div dir="auto"><br>
</div>
<div dir="auto">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.</div>
<div dir="auto"><br>
</div>
<div dir="auto">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.</div>
<div dir="auto"><br>
</div>
<div dir="auto"><br>
</div>
<div dir="auto">Cheers,</div>
<div dir="auto"><br>
</div>
<div dir="auto">Greg</div>
<div dir="auto"><br>
</div>
<div dir="auto"><br>
</div>
</div>
-- <br>
<div dir="ltr" class="gmail_signature"
data-smartmail="gmail_signature">
<div dir="ltr">
<div>
<div dir="ltr">
<div dir="ltr">
<div dir="ltr"><span><b>Hans Gregers Hedegaard Petersen<br>
</b>
<div>Partner, Seniorkonsulent</div>
<div><a href="mailto:gregers@septima.dk"
target="_blank" moz-do-not-send="true"
class="moz-txt-link-freetext">gregers@septima.dk</a></div>
<div>
--------------------------</div>
<div><span>Septima P/S</span><br>
</div>
<div>Frederiksberggade 19, 2.</div>
<div>1459 København K</div>
<div><a href="http://www.septima.dk" target="_blank"
moz-do-not-send="true">www.septima.dk</a></div>
<div>Tlf: +45 7230 0672</div>
<div>Direkte: +45 9132 6945</div>
<div>Cvr: 34900841</div>
<div><br>
</div>
</span></div>
</div>
</div>
</div>
</div>
</div>
<br>
<fieldset class="moz-mime-attachment-header"></fieldset>
<pre class="moz-quote-pre" wrap="">_______________________________________________
gdal-dev mailing list
<a class="moz-txt-link-abbreviated" href="mailto:gdal-dev@lists.osgeo.org">gdal-dev@lists.osgeo.org</a>
<a class="moz-txt-link-freetext" href="https://lists.osgeo.org/mailman/listinfo/gdal-dev">https://lists.osgeo.org/mailman/listinfo/gdal-dev</a>
</pre>
</blockquote>
<pre class="moz-signature" cols="72">--
<a class="moz-txt-link-freetext" href="http://www.spatialys.com">http://www.spatialys.com</a>
My software is free, but my time generally not.</pre>
</body>
</html>