It is possible to match strings with regular expression (also called REGEX) in Snowflake. I…
Kris Winnubstapril 28, 2023
In the previous chapters of this series, we have seen how to load through staging…
Mario Caliseapril 25, 2023
In this blog, we'll discuss practical tips and tricks to optimize SQL queries in Snowflake…
Sebastian Wiesnerapril 20, 2023
Snowflake is a cloud-based data warehousing solution that has become increasingly popular in recent years…
Sebastian Wiesnerapril 14, 2023
Last week I brought you a challenge on how to make derivatives in SQL. Evidently,…
Eloi Sanchezapril 14, 2023
We have already seen how nesting aggregated functions and SQL join types work in the…
Dimitris Lampriadisapril 8, 2023
MATCH_BY_COLUMN_NAME vs Variant data type I found myself having to insert files from my device…
Niccolo Racioppiapril 7, 2023
As an Analytics Engineer trainee, I recently took the Snowflake Snowpro Core Certification exam. Before…
Sebastian Wiesnerapril 7, 2023
I took the SnowPro Core Certification exam. SnowPro Core certification badge I will make some…
Niccolo Racioppiapril 7, 2023
