Connecting a Zeppelin Notebook to Snowflake in under 5 minutes

About Notebooks In this blog post we will show you how easy it is to connect Zeppelin notebooks to Snowflake Cloud Data Warehouse. We will also execute some queries and…
Dorian Beganovic May 16, 2018

Exploding polygons in Snowflake. KaBooom! Visualising Dublin property data in Tableau.

Introduction In this blog post we will show the power of Snowflake UDFs to prepare data for visualisation in Tableau. We take the Irish Census Data from the Central Statistics…
Dorian Beganovic May 14, 2018

Loading data into Snowflake and performance of large joins

Introduction In this blog post we will load a large dataset into Snowflake and then evaluate the performance of joins in Snowflake. Loading large data into Snowflake Dataset The dataset…
Dorian Beganovic March 16, 2018

Deep dive on caching in Snowflake

In this post we will explain the clever caching strategies Snowflake uses for performance optimization. In the process we will also cover related internals of Snowflake. A lot of information…
Dorian Beganovic March 5, 2018

The top 10+1 things we love about Snowflake

Introduction I have been familiarising myself with Snowflake over the last couple of months and these are my impressions on the top 10+1 features that really make Snowflake stand out…
Dorian Beganovic February 14, 2018

Rocketship Performance for Snowflake with Clustering Keys

Introduction Snowflake stores tables by dividing their rows across multiple micro-partitions (horizontal partitioning). Each micro-partition automatically gathers metadata about all rows stored in it such as the range of values…
Dorian Beganovic February 8, 2018
spinner