Until recently it was not possible to make network requests in a Snowflake user defined function (UDF) or stored procedure. However, there a many use cases which require access to the internet and therefore Snowflake developed a concept which allows to explicitly grant access to defined network locations. This blogpost…

Many organisations have implemented data lakes in the past with various outcomes. One of the challenges when using data lakes is security and governance. In this blogpost I will demonstrate how easy it is to share specific data from a data lake with Snowflake in a secure way. Securing a…

Introduction Recently I was asked whether it is possible to get data from Snowflake into Google Sheets. A quick search revealed that there are several tools available on the market for this. While these tools definitely provide additional value I was looking for something which is simple to set up and…

Every organisation shares data with suppliers, business partners, regulators, customers, or other business units. But traditional ways of sharing data are costly and painful. Different data formats, delivery methods, multiple copies, and the associated security aspects all contribute to increased cost and risk. Snowflake’s unique architecture powers the Secure Data…