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…
Kristijan Berta May 29, 2023

Improving performance and reducing costs with Materialised Views on Snowflake

What are Materialised Views? Materialised Views are similar to Views. A View is a logical or virtual table representing the result of a query. Each time the View is queried…
Kristijan Berta November 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…
Kristijan Berta 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.…
Kristijan Berta August 9, 2022

FlowHigh [Video]: Visualise, format, optimise and parse your SQL Contact us if you would like to be part of the private preview of the FlowHigh SQL revolution
Kristijan Berta May 31, 2022

SQL Parser deep dive. Use cases, features, practical examples, and tools for SQL parsing

In this blog post we will cover all aspects of SQL parsing. First we will explain what we mean by SQL parsing and look at the inner workings and mechanics…
Kristijan Berta October 22, 2021