Johan – Medium

Johan

Pinned

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, 2024

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

Oct 9, 2024

Pinned

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, 2024

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

Sep 11, 2024

Loading data from a remote database into Snowflake ….. without ETL tools

Inspired by this article I decided this should be tested: -> a direct query from within Snowflake to a remote database.

Jan 5

Loading data from a remote database into Snowflake ….. without ETL tools

Jan 5

Using Snowflake with Python and Copilot

I like to play around with Snowflake. Also with Python. And then also combining the 2, for cases such as generating SQL using Python and/or…

Dec 6, 2024

Using Snowflake with Python and Copilot

Dec 6, 2024

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…

Nov 1, 2024

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

Nov 1, 2024

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, 2024

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

Sep 25, 2024

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, 2024

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

Sep 11, 2024

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, 2024

Snowflake — 120 day trial

Sep 10, 2024

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, 2024

Optimizing Snowflake (3) — Quick wins

Sep 9, 2024

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, 2024

Optimizing Snowflake (2) — investigating expensive queries

Sep 5, 2024

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