Top Articles

Snowflake,

7 guardrails against common mistakes that inflate Snowflake credit usage 

Dodge costly pitfalls Snowflake has pioneered dozens of innovations in the data platform space. The long list includes separation of compute and storage, physical workload separation, data sharing, data app marketplace and many more. One innovation is the pay per use pricing model and instant scalability of compute resources. You can command hundreds or even …
Uli Bethke September 13, 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
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
Data Marketplace, Data Marketplace,

Planet Earth Open Map Data

The data is based on OpenStreetMap and enriched with third party sources. It is organised across eleven themes. Each theme is organised by classes and subclasses. You can drill down…
Uli Bethke May 15, 2023

Recent Articles

All Data Marketplace Flexter FlowHigh JSON Snowflake XML
Snowflake,

7 guardrails against common mistakes that inflate Snowflake credit usage 

Dodge costly pitfalls Snowflake has pioneered dozens of innovations in the data platform space. The long list includes separation of compute and storage, physical workload separation, data sharing, data app…
Uli Bethke September 13, 2023
FlowHigh,

Automatically detect bad SQL. Static and dynamic analysis of SQL code

Preventing Query Catastrophe with FlowHigh SQL Analyser Does the following sound familiar? As the wizard EsQuEl delved deep into the SQL code, he stumbled upon multiple instances where tables were…
Uli Bethke September 8, 2023
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