BLOG
OTHER WORK
Blogs
Parsing URLs in Snowflake with parse_url()
3 min read.
Lesser-known Snowflake functions: parsing URLs.
Calculating Percentages in Snowflake with ratio_to_report()
3 min read.
Lesser-known Snowflake functions: calculating percentages.
Conditional Counting in Snowflake with count_if()
2 min read.
Lesser-known Snowflake functions: counting on a specific condition.
Working with JSON in Redshift
2 min read.
Redshift now supports JSON! Find out how to use it.
Repeating blocks in YAML
4 min read.
Make your YAML code more efficient by using anchors and aliases to repeat blocks.
Calculating Streaks in Pandas
29 min read.
Learn how to calculate streaks in Python using the pandas library and visualize them using Matplotlib.