Recent Articles

Snowflake, Data Marketplace,

Airport Codes

Overview Sonra has published a data set for airport codes on the Snowflake marketplace. Airport codes are used to distinguish airports around the world to ensure that there is no…

Uli Bethke December 22, 2022

Snowflake, FlowHigh,

Improving performance and reducing costs with Materialised Views on Snowflake

What are Materialised Views? Materialised Views are similar to Views. A View is a logical or virtual table representing the result of a query. Each time the View is queried…

Uli Bethke November 18, 2022

Snowflake, FlowHigh,

How to do full text search with Snowflake, Inverted Indexes and Snowpark

Inverted Index An Inverted Index is a data structure used to support full text search over a set of documents. An inverted index is very similar to an index at…

Uli Bethke September 19, 2022

Snowflake, Snowflake,

Best Practices for implementing a Data Lake on Snowflake

Data lakes. An introduction Data lakes are a common and useful design pattern in modern data architecture. Contrary to a widespread belief, data lakes have been around for a long…

Uli Bethke April 20, 2022

Snowflake, Snowflake,

Date Dimension with Global Holiday Calendar

Overview A date dimension is an essential table in a data model that allows to analyze performance more effectively across different time periods. It should be included in every dimensional…

Uli Bethke March 21, 2022

Snowflake, Snowflake,

Canada Postal Code on Snowflake Marketplace

Overview Canada’s postal codes are alphanumeric, like Dutch, Irish, and British postcodes. Canadian postal codes are in the format A1A 1A1, where A is a letter and 1 is a…

Uli Bethke January 25, 2022