Recent Articles

Snowflake, Snowflake,

Administrative Boundaries USA

Overview The dataset Administrative Boundaries USA contains border information as polygons about the following divisions of the fifty states, the District of Columbia, Puerto Rico, and the Island areas (American…

Uli Bethke December 20, 2021

Snowflake,

Data Warehouse 3.0. A Reference Architecture for the Modern Data Warehouse.

Reference data architecture for data management and analytics. An introduction. I frequently come across data architecture diagrams that are riddled with vendor names, tools, and technologies. Tools and technologies have…

Uli Bethke December 9, 2021

Data Warehouse, Snowflake,

Using Virtual Data Marts the right way

Virtual data marts can be a useful design pattern but there are a few things you should know before you use them. Virtual data marts are logical views dimensionally modelled…

Uli Bethke May 26, 2021

Snowflake, Data Marketplace,

Location analytics on Snowflake with OpenStreetMap, US property data, and our ready made Geography Dimension

We have made available a ready made Geography Dimension on the Snowflake Data Marketplace. The marketplace is one of the components of the Snowflake Data Cloud. It covers the first to…

Uli Bethke February 19, 2021

Snowflake, Snowflake,

Guide to Geography Dimension on the Snowflake Marketplace

As a priority for this morning can you make some changes to the geography dimension blog post We’ve published a universal Geography Dimension on the Snowflake Data Marketplace! This dataset…

Uli Bethke February 3, 2021

Snowflake, Snowflake,

Reverse Geocoding on Snowflake

In this blog post we will show how you can use OpenStreetMap data from the Snowflake data marketplace and the geospatial feature in the Snowflake data platform to reverse geocode…

Uli Bethke December 24, 2020