Top Articles

SQL Challenge: Tackling the Island Problem in Time Series Data

Jump into our SQL Challenge! Today, we’re exploring customer loyalty trends. Are you prepared to show off your SQL skills? About the quiz In this SQL pop quiz, we’re challenging you to demonstrate your understanding of islands in a time series data set. Whoever submits the correct and most performant query will be featured in …

Uli Bethke November 7, 2023
XML, XML,

Converting HL7 CDA XML to Snowflake

Overview In this blog post we will automate the conversion process of CDA XML to a relational database format with Flexter . What is Flexter? Flexter converts any XML/JSON to…
Uli Bethke October 18, 2022

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

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

ROAD SAFETY DATA UK

Overview The strategic road network (SRN) is a vital national asset, supporting economic growth, regional development, and employment opportunities across England and the rest of the UK. It connects families,…
Uli Bethke June 7, 2022

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

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
spinner