Connecting a Zeppelin Notebook to Snowflake in under 5 minutes

Dorian Beganovic May 16, 2018

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 visualize the results using Zeppelin’s built-in tools. Notebooks are useful for exploratory data analysis, data discovery and data storytelling. As they are web based they ...

Read More

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

Dorian Beganovic May 14, 2018

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 Office of Ireland and use Snowflake to prepare the dataset for visualization in Tableau. As we have already loaded and pre-processed the Irish Census dataset ...

Read More

Loading data into Snowflake and performance of large joins

Dorian Beganovic March 16, 2018

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 we will load is hosted on Kaggle and contains Checkouts of Seattle library from 2006 until 2017. You can also download the data and see ...

Read More

Deep dive on caching in Snowflake

Dorian Beganovic March 5, 2018

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 is from the official research paper created by the Snowflake authors which explains the architecture of Snowflake in depth. Caching in virtual warehouses Snowflake strictly ...

Read More
1 2 3