Analytics Toolbox for Snowflake

Analytics Toolbox for Snowflake

Examples

In this section we provide a set of examples that showcase how to leverage the functions of our Analytics Toolbox to unlock advanced spatial analyses in your data warehouse platform. They cover a broad range of use cases with methods for data transformations, enrichment, spatial indexing in Quadkey and H3, statistics, clustering, spatial data science methods and more.

The Analytics Toolbox can be leveraged from the SQL Query editor in Builder, your data warehouse console, or in SQL and Python Notebooks using the SQL clients provided by the different cloud platforms.

    Analyzing store location coverage using a Voronoi diagram

    Voronoi diagrams are a very useful tool to build influence regions from a set of points and the Analytics Toolbox provides 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.