Best Practices for implementing a Data Lake on Snowflake

Uli Bethke April 20, 2022

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 time. The designs by Ralph Kimball and Bill Inmon included the design pattern of a staging and landing area. These are the parents of the ...

Read More

Converting Workday XML to Snowflake

Uli Bethke March 30, 2022

Overview In this post we will show you how you can easily convert Workday XML or any other XML to a Snowflake database. We will use Sonra’s Paranoid to mask the XML data and Flexter to convert Workday XML automatically without any manual coding. What is Flexter? Flexter converts any XML/JSON to a readable format ...

Read More

Date Dimension with Global Holiday Calendar

Uli Bethke March 21, 2022

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 model that contains a date or requires date intelligence as part of the analysis. The date dimension plays an important role in the data warehouse ...

Read More

 Canada Postal Code on Snowflake Marketplace

Uli Bethke January 25, 2022

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 digit, with a space separating the third and fourth characters. Although postal codes are usually assigned to geographical areas, special codes are sometimes assigned to ...

Read More
1 2 3 11