In dit blog zullen we kort de stappen doorlopen om een JSON bestand in Snowflake te krijgen en hierbij de kracht van Snowflake’s Variant columns te gebruiken. De data...
The traditional data team consisted of data engineers and data analysts. Where data engineers were responsible for supplying the analysts with the data they required. This meant Extracting the...
Snowflake is a database. Like all databases, Snowflake stores your data and gives you the ability to retrieve that data. Until here nothing to write home about. What does...
In the previous articles, we’ve started manually loading data into Snowflake and created a script to automatically download the data from the web and upload it to an S3...
Last week, I wrote a blog about downloading data, uploading it to an S3 bucket, and importing it into Snowflake (which you can find here). Now it’s time to...
You’ve seen and heard us talk a lot about Snowflake with a lot of enthusiasm at The Information Lab but once you’re ready to get your hands dirty (or...
While working on some data and importing a few files from an s3 bucket, Snowflake encountered an error that took me too long to figure out: Field delimiter ‘,’...
In this blog post I will explain what a view is and how to create one, then I will discuss materialized views and secure views. While views and materialized...
Snowflake offers five default roles. It is important to understand the default Snowflake roles as they can help you managing access control to data within your organisation. These default...