Thanks for reading out the earlier blog in the series. The earlier blog was focused on Designing Datawarehouse solutions and implementing ELT with Snowflake. This is the third blog in the series where you will learn more about designing data mesh solutions with Snowflake. If you haven’t read the earlier…

They often say history repeats itself. So fast forward (a full 13 years!) to the present day and I find myself back in charge of putting together another user group. While some things remain unchanged — such as pizzas and the help of the community — many things naturally change…

Window functions are not always easy to learn, but here I’ll introduce you to a convenient way to not only understand how offset functions work but to also build interactive queries in Snowflake without typing one line of SQL code. The Offset Functions The standard SQL window functions in Snowflake that return a…

In today’s digital landscape, the majority of applications heavily rely on data. However, creating effective data applications can be challenging, particularly when faced with a growing user base and increasingly vast and intricate datasets. …

Using the GENERATOR and LAST_VALUE functions This question comes up time and time again: How do I create missing records with SQL? For example, you may require exchange rates for each day within a time period, but some days are missing. This could be because the exchange rates weren’t received…

Businesses are embarking on an exhilarating journey, tapping into the power of Artificial Intelligence and the robustness of Snowflake’s data platform for customer sentiment analysis. Why customer sentiment analysis is crucial for businesses Let’s delve into why customer sentiment analysis is crucial for businesses. It’s not just about capturing customer feedback, it’s about decoding emotions and attitudes towards…

A more powerful and flexible pipeline for auto-loading data into Snowflake — Snowflake has (rather quietly!) released support for Snowpipe auto-ingest with Amazon EventBridge, in public preview. This option provides an alternative to existing approaches that require configuring a S3 Event Notification. This blog will dive deep into this new option help you decide whether this approach suits your current Snowflake +…

As mentioned in my previous blogs, Snowpark is a new developer experience that allows you to write Snowflake code in your preferred way and execute it directly within Snowflake. In simple terms, users can Code in a language that is natural to them and suits their project and their preference. Traditional Architecture …

As a Snowflake consultant, we often work with clients who have just taken their first step towards their Snowflake journey! We couldn’t be more excited! Everyone is ready, the stakes are high, and so is the visibility. …