Johan – Medium

Johan

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…

1d ago

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

1d ago

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…

1d ago

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

1d ago

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:

1d ago

Snowflake — 120 day trial

1d ago

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…

2d ago

Optimizing Snowflake (3) — Quick wins

2d ago

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…

6d ago

Optimizing Snowflake (2) — investigating expensive queries

6d ago

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

Snowflake — Iceberg tables 101

TL;DR use this Snowflake Quickstart to explore Iceberg tables https://quickstarts.snowflake.com/guide/getting_started_iceberg_tables

Jul 12

Snowflake — Iceberg tables 101

Jul 12

Johan

Optimizing Snowflake (4): monitoring and debugging stored procedures using query tagging

Jun 4

Optimizing Snowflake (4): monitoring and debugging stored procedures using query tagging

Jun 4

Johan

Snowflake — CI/CD tooling

TL/DR; take a look at my Python CI/CD tool for Snowflake: SFexecute. Put the SQL you want to execute in a folder, run the script and all…

May 16

Snowflake — CI/CD tooling

May 16

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