Johan – Medium

Johan

Pinned

Johan

My presentation & code snippets from the Snowflake Dutch User Group Meeting

Yesterday I had the pleasure to present my topic ‘optimizing Snowflake from a cost and performance perspective’ at the Dutch User Group…

Oct 9

My presentation & code snippets from the Snowflake Dutch User Group Meeting

Oct 9

Pinned

Johan

Optimizing Snowflake — Your Complete Series for Peak Performance at Low Cost

Have been writing various articles about optimizing Snowflake from a cost/performance perspective. This article is a collection of all…

Sep 11

Optimizing Snowflake — Your Complete Series for Peak Performance at Low Cost

Sep 11

Johan

Snowflake & GIT

When using Snowflake’s UI Snowsight, code lives in the browser. I really like Snowsight, but the huge amount of tabs you end up with…

5d ago

don’t know why this picture showed up on Unsplash, since my search term was Git. The picture shows Groot and Octocat reading a newspaper

5d ago

Johan

Optimizing Snowflake (6) — Cost Optimization using 3rd party services

When you want to analyse the Snowflake credit usage using readymade apps, there are several apps, either native or streamlit, published by…

Sep 25

Optimizing Snowflake (6) — Cost Optimization using 3rd party services

Sep 25

Johan

Optimizing Snowflake (5) — Queuing and spilling, your worst enemies

When executing queries, two things can happen that you want to avoid at all time. Why: because they will cause totally unpredictable…

Sep 11

Optimizing Snowflake (5) — Queuing and spilling, your worst enemies

Sep 11

Johan

Snowflake — 120 day trial

We knew about the possibility to start a 30 day Snowflake trial. Just discovered a 120 day trial option. How to find it:

Sep 10

Snowflake — 120 day trial

Sep 10

Johan

Optimizing Snowflake (3) — Quick wins

Execute these commands to set parameters for your warehouses plus additional settings on the account level. It will reduce credit usage…

Sep 9

Optimizing Snowflake (3) — Quick wins

Sep 9

Johan

Optimizing Snowflake (2) — investigating expensive queries

After being able to identify the most expensive queries, the next step is to zoom in on individual cases. In the previous article, we…

Sep 5

Optimizing Snowflake (2) — investigating expensive queries

Sep 5

Johan

Databricks — trial/community edition (CE)

When going to the website, it is quite easy to start a trial.

Jul 19

Databricks — trial/community edition (CE)

Jul 19

Johan

Optimizing Snowflake (1)— overview & strategy

This is the first part of a new series of articles I will be posting here: how to optimize Snowflake for cost and performance.

Jul 15

Optimizing Snowflake (1)— overview & strategy

Jul 15

Johan

Johan

I am a freelance data engineer. My main focus is Snowflake, but I am always eager to learn new things. Python and AWS are my main side interests

Following

Help
Status
About
Careers
Press
Blog
Privacy
Terms
Text to speech
Teams