Recent Articles

All Data Marketplace Flexter FlowHigh JSON Snowflake XML
FlowHigh, FlowHigh,

SQL antipatterns:  SELECT DISTINCT

The DISTINCT operator The DISTINCT operator is used to eliminate duplicates in a resultset, e.g. we can use it to identify the unique number of customers who made a purchase.…
Uli Bethke August 9, 2022
FlowHigh, FlowHigh,

FlowHigh [Video]: Visualise, format, optimise and parse your SQL

https://youtu.be/eGRqW0S9nhw Contact us if you would like to be part of the private preview of the FlowHigh SQL revolution
Uli Bethke May 31, 2022
Data lake, 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, XML,

Converting Workday XML to Snowflake

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…
Uli Bethke March 30, 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