Recent Articles

All Data Marketplace Flexter FlowHigh JSON Snowflake XML
FlowHigh,

Parsing SQL queries in MS SQL Server

This is the third article in our series on parsing SQL in different database technologies and SQL dialects. We explored SQL parsing on Snowflake and then Oracle in our earlier…
Uli Bethke September 4, 2023
FlowHigh,

Bad SQL. SQL anti patterns in OUTER joins

You often need to find both matched and unmatched rows between two or more tables. As we all know we use OUTER joins in SQL to achieve this. However, there…
Uli Bethke August 29, 2023
Data Marketplace,

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
FlowHigh,

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
FlowHigh, FlowHigh,

From Code to Clarity: Visualizing SQL code for Documentation and Debugging

In this post we will show you how you can create a visual diagram of your SQL code. We will use the FlowHigh SQL visualiser to achieve this. FlowHigh is…
Uli Bethke May 29, 2023
Data Marketplace, 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