That's great to hear! Good luck with getting started! I'm glad this is video was useful, if you have any suggestions for other videos that might be useful let me know!
Hi @oleksiibielov, thanks for the comment! Unfortunately this connection is only one way, so you can't write back to Snowflake with it. One way of automatically writing changes to Snowflake is Snowpipe docs.snowflake.com/en/user-guide/data-load-snowpipe-streaming-overview, you might be able to make something work for you there.
I followed the steps, but in the end I received an error: Connection failed - Check settings and try again. Extended error information: Unable to initialize ODBC connection to DSN for {user}/{password}@{dbname} It works with other apps... Which version of QGIS were you using?
I tried to do this at work where I'm using SSO to connect to Snowflake, i.e. in the connection string, the authentication method is set to 'externalbrowser'. The DSN is configured correctly, and it works correctly from R, Python, etc., but QGIS just says 'Unable to intialize ODBC connection to DSN for xxx,'. I don't suppose you've ever confirmed this works with SSO?
Thanks for posting a question. I'm getting the error too and this is one of the next things on the list to figure out. Just to help with testing - would you mind letting me know if you have an '@' symbol in your username? Im wondering if @ causes an error as it seems to change your username to xxx@Snowflake when creating the connection.
@@dotpi5907 My username is my email address so, yes, it has an @ it it. Unfortunately, authentication is exclusively via Azure Active Directory, and I have no control over it. So there's literally nothing I can do to trouble shoot :)
Hi cmhhansen, I've been looking into this and it seems like QGIS isn't setup to connect to Snowflake using SSO unfortunately. I have a good workaround option though. If you connect Snowflake to MS Access, then MS Access to QGIS you will still get a live data feed from Snowflake without even having to open MS Access. I've done some testing using SSO and this seems to work well. Here is a video on connecting Snowflake to Access and then other softwares th-cam.com/video/5bFYKG9vZDU/w-d-xo.html I will make a QGIS specific one at some point too. Let me know how you go
@@dotpi5907 Thanks for looking into it. Unfortunately, MS Access is effectively banned where I work. I've not really looked into it, but I wonder if it's just possible to write a snowflake extension... perhaps in Python. I might do a little research. Actually, it would be nice to create a GDAL driver for snowflake, but I have looked at the GDAL source code and I don't think I have the energy for that!
Hi Adil, that sounds like a good topic to make a video on! Could you send me an example of what you're trying to do on the Contact Us page of the DotPi website? dot-pi.com/contact/
@@adilmajeed8439 I don't know how you'd prefer to load spatial data, but if you have a table with a geometry type in it, then you can load a plain csv etc. where the geometry is stored as a WKT string. I routinely do this from R just using the DBI::dbAppendTable (and I use the sf package to create the WKT column from an st_geometry column).
![[LIVE] Transforming Geospatial Analysis with Snowflake in QGIS](/img/n.gif)
Just about to get started on my first proper data engineering project, and I'll be using QGIS as my visualisation tool at the end. This is awesome!
That's great to hear! Good luck with getting started! I'm glad this is video was useful, if you have any suggestions for other videos that might be useful let me know!
Fantastic video! Thank you for sharing! 😀
I had to put "dsn=my-db-name" in the "Database" field, instead of just "my-db-name". Not sure why.
Thanks for the awesome guide. Can I write my changes back to Snowflake using this connection?
Hi @oleksiibielov, thanks for the comment! Unfortunately this connection is only one way, so you can't write back to Snowflake with it. One way of automatically writing changes to Snowflake is Snowpipe docs.snowflake.com/en/user-guide/data-load-snowpipe-streaming-overview, you might be able to make something work for you there.
I followed the steps, but in the end I received an error:
Connection failed - Check settings and try again.
Extended error information:
Unable to initialize ODBC connection to DSN for {user}/{password}@{dbname}
It works with other apps...
Which version of QGIS were you using?
Hi Pedro, thank you for the comment. I'm using QGIS 3.22.5. Can I ask - are you using a username and password or an external browser authentication?
@@dotpi5907 username + password
@@dotpi5907 It's working now; I was mistyping the DB name. ty.
@@PedroRoque-xw2jm That's great to hear!
I tried to do this at work where I'm using SSO to connect to Snowflake, i.e. in the connection string, the authentication method is set to 'externalbrowser'. The DSN is configured correctly, and it works correctly from R, Python, etc., but QGIS just says 'Unable to intialize ODBC connection to DSN for xxx,'. I don't suppose you've ever confirmed this works with SSO?
Thanks for posting a question. I'm getting the error too and this is one of the next things on the list to figure out. Just to help with testing - would you mind letting me know if you have an '@' symbol in your username? Im wondering if @ causes an error as it seems to change your username to xxx@Snowflake when creating the connection.
@@dotpi5907 My username is my email address so, yes, it has an @ it it. Unfortunately, authentication is exclusively via Azure Active Directory, and I have no control over it. So there's literally nothing I can do to trouble shoot :)
Hi cmhhansen, I've been looking into this and it seems like QGIS isn't setup to connect to Snowflake using SSO unfortunately.
I have a good workaround option though. If you connect Snowflake to MS Access, then MS Access to QGIS you will still get a live data feed from Snowflake without even having to open MS Access. I've done some testing using SSO and this seems to work well.
Here is a video on connecting Snowflake to Access and then other softwares th-cam.com/video/5bFYKG9vZDU/w-d-xo.html I will make a QGIS specific one at some point too. Let me know how you go
@@dotpi5907 Thanks for looking into it. Unfortunately, MS Access is effectively banned where I work. I've not really looked into it, but I wonder if it's just possible to write a snowflake extension... perhaps in Python. I might do a little research.
Actually, it would be nice to create a GDAL driver for snowflake, but I have looked at the GDAL source code and I don't think I have the energy for that!
Not able to connect, its giving an error of "could not resolve the proxy name". Any pointers?
I was able to connect after restarting the system
That's great to know, thanks Adil!
@@dotpi5907 how about loading any spatial format data to snowflake as the current process is very obscure?
Hi Adil, that sounds like a good topic to make a video on! Could you send me an example of what you're trying to do on the Contact Us page of the DotPi website? dot-pi.com/contact/
@@adilmajeed8439 I don't know how you'd prefer to load spatial data, but if you have a table with a geometry type in it, then you can load a plain csv etc. where the geometry is stored as a WKT string. I routinely do this from R just using the DBI::dbAppendTable (and I use the sf package to create the WKT column from an st_geometry column).