search

qgis / QGIS

QGIS is a free, open source, cross platform (lin/win/mac) geographical information system (GIS)
https://qgis.org
GNU General Public License v2.0
10.32k stars 2.96k forks source link

Support Snowflake directly for vector layers. #52540

Open cmhh opened 1 year ago

cmhh commented 1 year ago

Feature description

The ability to drag-and-drop features directly from spatially-aware databases such as PostgreSQL / PostGIS or MSSQL is great, and it would be useful to be able to do the same thing with Snowflake tables which have a geometry or geography column.

Additional context

Note that it is possible to use Snowflake via the existing ODBC functionality, and this is a plausible workaround in practice, albeit a little tougher to use for non-technical analysts. However, in many enterprise settings, connecting to Snowflake using single sign-on is required, and the existing ODBC connectivity doesn't seem to support this. That is, attempting to use an ODBC string or DSN where authenticator=externalbrowser results in failure.

Note also that I've raised this directly with reps from Snowflake, and they've told me they've raised a feature request, but that's all I know about it.

Trippmadam commented 1 year ago

Given that Snowflake offers two data types (geometry and geography) and support for any spatial reference system in conjunction with the geometry data type, it seems only logical for connection to GIS applications to be facilitated. Import of spatial data could be easier than it currently is as well.

biellou commented 7 months ago

I agree with @Trippmadam that supporting Snowflake would enable many business users to utilize QGIS. Currently, these users depend on commercial solutions for conducting sophisticated geospatial analysis.