Johan – Medium

Johan

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…

3d ago

Optimizing Snowflake (2) — investigating expensive queries

3d 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

Snowflake: monitoring and debugging stored procedures using query tagging

When you run Snowflake stored procedures, debugging is not the easiest thing. This is my example stored procedure, dynamically dropping…

Jun 4

Snowflake: 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

Snowflake — LISTAGG (&Copilot)

We have a requirement where we want to see the top customers with the largest orders. This could lead to a query like this:

May 14

Snowflake — LISTAGG (&Copilot)

May 14

Johan

Snowflake Copilot

One of the public preview features that was recently launched: Snowflake Copilot. Introduced in April 2024, so Snowflake is a bit late to…

Apr 30

Snowflake Copilot

Apr 30

Johan

Snowflake scripting

This is really nice. Build blocks of code that can be used in stored procedures or tasks but also in the console.

Apr 24

Apr 24

Johan

Snowflake: 30 day trial

How to set this up, it is super easy:

Apr 24

Snowflake: 30 day trial

Apr 24

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