As part of our commitment to enabling geospatial analysis natively within the cloud, today we announce the launch of our Spatial Analytics on Snowflake with CARTO!
Exciting news for Snowflake users! As part of our commitment to enabling geospatial analysis natively within the cloud, today we are announcing the launch of our Spatial Analytics on Snowflake with CARTO! Check out the official announcement on the Snowflake Blog.
We have been working with Snowflake for a number of months now to add more spatial capabilities to the popular data warehouse. Based on years of experience with PostGIS development this is a great milestone that brings the full power of Spatial SQL to the fast growing community of Snowflake users.
Most spatial analysis needs to be performed together with other 3rd party data so we are also happy to announce the availability of our Data Observatory on the Snowflake Data Marketplace, giving users seamless access to location data to enhance their spatial analyses.
There are many CARTO users already leveraging Snowflake to power their data infrastructure and now with full cloud native support for Snowflake they will benefit from:
- Increased performance. By running spatial analysis inside Snowflake users will be able to utilize its parallelization capabilities.
- Convenience and interoperability. By adding spatial support directly as an extension inSQL our users are able to integrate geospatial capabilities within their BI tools ETLs Low Code apps etc.
Enhanced connectivity and geospatial capabilities
Back in September we announced the availability of our Snowflake connector letting CARTO users seamlessly ingest spatial datasets hosted in the Snowflake cloud data platform as a first step to becoming Cloud Native. With our latest development we now provide a wealth of spatial capabilities built within Snowflake.
Spatial Analytics on Snowflake is distributed as a set of User Defined Functions (UDFs) that extends the capabilities of Snowflake for everything geo. It is available as a Snowflake data share so there is no need to install or manage anything special they just complement your existing Snowflake data warehouse.
This is a very innovative way of distributing new analytical capabilities, in fact, this is the first Snowflake Data Share that is used for distributing User Defined Functions. By working closely with Snowflake on this release we have been able to clearly see that this is going to be a fantastic distribution method for the future.We start by providing some foundational components such as support for spatial indexes like H3 or S2 or functions for spatial measurements and further build on this by adding more advanced capabilities.
Ready to try out the CARTO Spatial Extension for Snowflake?
Some example queries that you can perform the Spatial Analytics
There are a number of examples already available within the documentation so this is just a highlight of a few of them.
Computing US airports connections and routes interpolations
Compute all the paths that interconnect the main four US airports using Spatial Analytics ST_GREATCIRCLE
This query first creates all possible combinations between airports and then generates the paths between them using the ST_GREATCIRCLE function. The resulting paths contain 25 points, but you can set the number of points in order to make the lines smoother if needed (you could also exclude this parameter).
The result is displayed in this visualization. Notice that we are not using straight lines to interconnect the different airports but great circles instead.
New supplier offices based on store locations clusters
In this example we are going to use points clustering to analyze where to locate 10 new supplier offices in the US so they can best serve all Starbucks locations.
Analyzing store locations coverage using a Voronoi diagram
Voronoi diagrams are a very useful tool to calculate influence regions from a set of points and Spatial Analyticsprovides a convenient function to build them. An example application of these diagrams is the calculation of the coverage areas of a series of Starbucks stores. In the following query we are going to calculate these influence areas in Atlanta.
The result can be seen in the visualization below, where the color of each polygon indicates its area, which gives an insight on the coverage provided by each store.
These are just a few examples of how some of the 60 or so geospatial functions currently available as part of the Spatial Analytics on Snowflake with CARTO can be used to seamlessly enhance user data with 3rd party sources and surface valuable location-based insights right inside the Snowflake cloud data platform.
If you would like a personalized demo of the Spatial Analytics on Snowflake, reach out to us on the link below. Our team is really excited to showcase its full potential!
Want to see this in action? Request a personalized demo