“Most of the world will make decisions by either guessing or using their gut. They will be either lucky or wrong.” – Suhail Doshi, chief executive officer, Mixpanel. Data is a…
Header photo by Kaffeebart on Unsplash On May 31, 2024, Ticketmaster confirmed a data breach that resulted in the loss of personal information for numerous customers. Fingers pointing at…
Road to Snowflake Data Engineer: Storage and Data Protection Third blog of the Road to Snowflake Data Engineer series. If you missed the first two, I'll link them here Road…
Mastering data moving is the first step to becoming a Snowflake certified Data Engineer. DALL-E generated image. In this blog post, one of a five-part series, I dive into the…
Last night, I attended the 10th Analytics Engineering Meetup in Amsterdam. It was my first Analytics Engineering Meetup and the first time seeing the GitHub Copilot at work. Sam Morrow,…
Given the importance of data nowdays, the ability to efficiently manage and process it can significantly impact an organization's success. Snowflake, dbt (data build tool), and GitHub have emerged as…
Welcome back to Killing JSON, the series in which I channel my frustration with loading data into teaching you something. Last week, we covered the ins and outs of the…
Welcome to Killing JSON, a series in which I channel my frustration with loading data into teaching you something. Today, we're talking about the FLATTEN function in Snowflake. Flattening JSON,…
Hybrid Tables in Snowflake are a new type of table that can support transactional workloads. They store data in a row-oriented format, and allow fast single-row operations as well as…