Johan – Medium

Johan

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

FinOps X day Amsterdam

Over the last 2 years, optimizing Snowflake from a cost perspective has been top of my list. My next step is to further expand this topic…

Sep 23

FinOps X day Amsterdam

Sep 23

MCP — Model Context Protocol

Shared my first MCP experience on LI this week:

Apr 5

MCP — Model Context Protocol

Apr 5

Snowflake & DBT

Launching DBT from within Snowflake — Partner Connect:

Mar 30

Snowflake & DBT

Mar 30

Snowflake — key pair authentication

Once you have set up your Snowflake account for key pair authentication, you can use the script below to test this:

Mar 29

Snowflake — key pair authentication

Mar 29

AWS — Multi Session support

When you want to log in to the AWS Console, check someting in Dev and also look in Acc (in the same browser), for instance to debug stuff…

Mar 11

AWS — Multi Session support

Mar 11

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

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

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

Rules

Terms

Text to speech