Recent Articles

Snowflake,

7 guardrails against common mistakes that inflate Snowflake credit usage

Dodge costly pitfalls Snowflake implementation has pioneered dozens of innovations in the data platform space. The long list includes separation of compute and storage, physical workload separation, data sharing, data…

Uli Bethke September 13, 2023

Snowflake,

Country & City Dimension

Country The COUNTRY table serves as a comprehensive repository, capturing essential attributes and details about countries globally. It encompasses unique identifiers, standardized codes, geographical data, and practical information. COUNTRY_CD: Description:…

Uli Bethke August 18, 2023

Snowflake,

How Snowflake EXCLUDE and ILIKE protects you from bad SQL. ILIKE it like that.

One of the most common and impactful SQL anti patterns is the use of SELECT *. In this article we will explain what an SQL anti pattern is and how…

Uli Bethke August 16, 2023

Snowflake, Data Marketplace,

Netherlands Open Map Data

Netherlands administrative boundaries and road network The data is organised across two themes. Administrative: This data set contains the polygons for Netherlands administrative boundaries at different levels. It includes the…

Uli Bethke May 18, 2023

Snowflake, Data Marketplace,

Planet Earth Open Map Data

The data is based on OpenStreetMap and enriched with third party sources. It is organised across eleven themes. Each theme is organised by classes and subclasses. You can drill down…

Uli Bethke May 15, 2023

Snowflake, Data Marketplace,

UK Open Map Data

UK administrative boundaries and road network The data is organised across two themes. Administrative: This data set contains the polygons for UK administrative boundaries at different levels. It includes the…

Uli Bethke May 8, 2023