PARTNER CERTIFIED SOLUTION
Create Interactive Map Dashboards using the Honeycomb Maps Native App
SELECT
poi.poi_name,
poi.category_main,
poi.category_alternate,
addr.latitude,
addr.longitude,
addr.city,
addr.state,
addr.zip
FROM US_REAL_ESTATE.cybersyn.point_of_interest_index AS poi
JOIN US_REAL_ESTATE.cybersyn.point_of_interest_addresses_relationships AS map
ON (poi.poi_id = map.poi_id)
JOIN US_REAL_ESTATE.cybersyn.us_addresses AS addr
ON (map.address_id = addr.address_id)
WHERE addr.city = 'New York'
AND addr.state = 'NY'
AND poi.category_main = 'Pizza Restaurant';
SELECT
poi.poi_name,
poi.category_main,
poi.category_alternate,
addr.latitude,
addr.longitude,
addr.city,
addr.state,
addr.zip
FROM US_REAL_ESTATE.cybersyn.point_of_interest_index AS poi
JOIN US_REAL_ESTATE.cybersyn.point_of_interest_addresses_relationships AS map
ON (poi.poi_id = map.poi_id)
JOIN US_REAL_ESTATE.cybersyn.us_addresses AS addr
ON (map.address_id = addr.address_id)
WHERE addr.city = 'New York'
AND addr.state = 'NY'
AND poi.category_main = 'Pizza Restaurant';
SELECT
poi.poi_name,
poi.category_main,
poi.category_alternate,
addr.latitude,
addr.longitude,
addr.city,
addr.state,
addr.zip
FROM US_REAL_ESTATE.cybersyn.point_of_interest_index AS poi
JOIN US_REAL_ESTATE.cybersyn.point_of_interest_addresses_relationships AS map
ON (poi.poi_id = map.poi_id)
JOIN US_REAL_ESTATE.cybersyn.us_addresses AS addr
ON (map.address_id = addr.address_id)
WHERE addr.city = 'New York'
AND addr.state = 'NY'
AND poi.category_main = 'Pizza Restaurant';
SELECT
poi.poi_name,
poi.category_main,
poi.category_alternate,
addr.latitude,
addr.longitude,
addr.city,
addr.state,
addr.zip
FROM US_REAL_ESTATE.cybersyn.point_of_interest_index AS poi
JOIN US_REAL_ESTATE.cybersyn.point_of_interest_addresses_relationships AS map
ON (poi.poi_id = map.poi_id)
JOIN US_REAL_ESTATE.cybersyn.us_addresses AS addr
ON (map.address_id = addr.address_id)
WHERE addr.city = 'New York'
AND addr.state = 'NY'
AND poi.category_main = 'Pizza Restaurant';
Overview
Learn how to create and share interactive maps that display data from Snowflake tables
This solution architecture shows how you can develop a location data platform within Snowflake. It utilizes Snowflake’s support for GEOGRAPHY types and H3 indexes as well as visualization on interactive map dashboards using the Honeycomb Maps native app.
Here are sample use cases for a location data platform:
Delivery companies can visualize their delivery zones and identify specific areas where performance is below average
Mobility companies can visualize their fleet of vehicles and create maps that show where demand is highest, using H3 cells
Retail and CPG companies can create maps showing their distribution partner reach compared with population density to identify gaps in their distribution network
This solution:
Utilizes Snowflake’s native support for GEOGRAPHY types and H3 functions
Enriches first-party data with free or paid third-party data from Snowflake Marketplace
Visualizes data on interactive maps, using the Honeycomb Maps Native App installed from the Snowflake Marketplace
Leverages customers’ existing Snowflake security configuration, including Single-Sign On and Row Based Access Control (RBAC)
The result:
Business users can view their data on easy-to-use, interactive maps (no SQL needed)
Data teams do not need to build & maintain custom map applications
Data stays in Snowflake and is secured with mandatory SSO
Location Data Platform Reference Architecture
First and third-party data is imported into Snowflake.
Data is enriched with Snowflake’s built-in geospatial and H3 functions.
Spatial data is incorporated into dimensional models alongside non-spatial data.
An ‘H3 Data Mart’ pre-aggregates metrics by H3 for efficient reporting.
Internal users access Honeycomb through a dedicated URL.
Honeycomb uses Snowflake’s SSO to authenticate users.
Honeycomb fetches data from Snowflake tables one time when the map is loaded (all subsequent processing is done in-browser).
Users can save and share maps created within Honeycomb.
This solution was created, tested, and verified by a member of the Snowflake Partner Network and meets compatibility requirements with Snowflake instances as of date of publication.
Solution not working as expected? Contact our team for assistance.
SOLUTION PARTNER
