Snowflake Scripting is a SQL extension to facilitate migrations and your development of stored procedures. Find here my notes and basic… — My goal in this post is to review some basic scripts to get you started. Note that this is the initial public preview release — test these scripts, check the docs, and share your feedback with us. And don’t forget to check the Snowflake Scripting docs. Why…

Let’s take a real-time streaming source — all the RSVPs from Meetup.com — into Snowflake, with the help of Google Cloud Pub/Sub. — Use case We want to move a stream of data with ~4k messages per hour to Snowflake, using Google Pub/Sub as temporary storage. This is a real use case, consisting of all worldwide RSVPs on meetup.com being published in real time. This data has been collected from Meetup through…

This is a quick demo to show how to export the Hacker News archive from BigQuery into Snowflake. It will be quick, easy, and a great way to… — From BigQuery to Snowflake in less than 1 minute Hacker News in BigQuery If you are a BigQuery user, you can find the Hacker News archive table on console.cloud.google.com/bigquery?p=bigquery-public-data&d=hacker_news&t=full&page=table. This table contains an updated copy of Hacker News, as seen on my previous posts (when I used to work with the BigQuery team). Right now it has more than 11GB…

How to export GA4 from BigQuery into Snowflake, and translate the cookbook sample queries. — Google Analytics 4 exports event data from individual user level for free into BigQuery. You might then be wondering “How do I move this data into Snowflake, to get all the benefits of the Data Cloud?” and “Is there a quick way to translate the sample BigQuery queries into Snowflake…

Building a decay function in SQL is not trivial, but fun. The best answer so far uses window functions, but can we do better with a JS UDTF… — Brittany Bennett and Claire Carroll snipped data-twitter with a fun SQL puzzle. Hours later Benn Eifert had a great solution with SQL window functions. Then TJ Murphy tested it in Snowflake and explained why window functions are better than joins. And now, it’s my turn to play…

The most popular language on Reddit (other than English) will surprise you. To build this chart I analyzed almost a million Reddit… — The most popular languages on Reddit, after analyzing 1M comments: English, German(!), Spanish, Portuguese, French, Italian, Romanian(!), Dutch(!)… Surprising results, compared to the # of native speakers: German is the second most popular language on Reddit — Which probably is a big reason for Reddit opening an office in Berlin…

Predicting the future starts with understanding the past and this is no different when working with weather data. Just think how much… — You can use Snowflake to find correlations between your past data and historical weather data, and also to find a source of weather predictions into the future. …

This example explores Snowflake’s geospatial capabilities, and how to enhance them using CARTO shared functions in the Snowflake Data… — The Data Cloud not only allows you to share data, but also logic. Let’s check out the power of this by playing with GIS UDFs shared by CARTO. Random points around a country Let’s start by plotting 1,000 random points around Italy:

I used to load reddit comments onto BigQuery, now it’s time to upgrade my pipelines to Snowflake. Let’s get started with 261GB of reddit… — Loading and analyzing reddit comments in Snowflake is fun, and a great way to show its powers. These are some of the Snowflake features that delighted me, that I didn’t get with BigQuery: Working with semi-structured data in Snowflake is fast, easy, and fun. Snowflake understands JSON objects on load…