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

MCP — Model Context Protocol

Shared my first MCP experience on LI this week:

12h ago

MCP — Model Context Protocol

12h ago

Snowflake & DBT

Launching DBT from within Snowflake — Partner Connect:

6d ago

Snowflake & DBT

6d ago

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

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

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