Let’s find out the easiest way to get ARIMA predictions in Snowflake with a Python UDF — available right now in Public Preview. Also find here why December 2025 will be a significant date for Snowflake’s presence in Stack Overflow. — Let’s get straight to the point. The following is a Python UDF that receives an array of numbers, and returns an array of predictions — as forecasted by ARIMA provided in the package pmdarima:

Where Tal tells us why he chose to join Snowflake after Google, and what’s coming next. — It was exciting to see Tal Shaked joining Snowflake after more than 16 years at Google. Something that’s fascinating about Tal’s life is that, in 2004, in those days when the world was learning about MapReduce, he was already doing machine learning at Google. So I called…

Counting unique snowflakes is fun. Thanks to Google open sourcing ZetaSketch and Snowflake’s ability to run native Java UDFs, we can achieve sketch compatibility for approximate counts with other ecosystem players. — In 2019 Google open-sourced ZetaSketch, a “collection of libraries for single-pass, distributed, approximate aggregation and sketching algorithms”. This has allowed other projects to enable compatibility for approximate counts and partial results:

This pattern will allow you to create high-traffic apps available to the world, hosted by Streamlit Cloud. Play and prepare your data with Snowflake and Streamlit, and then serve the results in production out of static Parquet files. Snowflake acquired Streamlit for a good reason: Streamlit adds magic to the…

Summary This was my first data conference since 2019, and a lot has changed since (including my t-shirt stamps). Gone are my “Mr BigQuery” days, now I am a Snowflake “Data Cloud Advocate”. As such, these were my main observations from the ground: Snowflake is behind everything, everywhere, at all the…

Snowflake Scripting is a SQL extension to facilitate migrations and your development of stored procedures. Find here my notes and basic scripts to get you started. — 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.

Let’s take a real-time streaming source — all the RSVPs from Meetup.com — into Snowflake, with the help of Google Cloud Pub/Sub — 2022 Update Meetup stopped supporting the streaming API. This means we can’t keep streaming Meetup RSVPs, but the pattern is still useful with any other real life feed. 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 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 show off semi-structured data support in Snowflake, and its SQL recursive capabilities. — 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.

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…