JohanOptimizing Snowflake (2) — investigating expensive queriesAfter being able to identify the most expensive queries, the next step is to zoom in on individual cases. In the previous article, we…2d ago2d ago
JohanDatabricks — trial/community edition (CE)When going to the website, it is quite easy to start a trial.Jul 19Jul 19
JohanOptimizing Snowflake (1)— overview & strategyThis is the first part of a new series of articles I will be posting here: how to optimize Snowflake for cost and performance.Jul 15Jul 15
JohanSnowflake — Iceberg tables 101TL;DR use this Snowflake Quickstart to explore Iceberg tables https://quickstarts.snowflake.com/guide/getting_started_iceberg_tablesJul 121Jul 121
JohanSnowflake: monitoring and debugging stored procedures using query taggingWhen you run Snowflake stored procedures, debugging is not the easiest thing. This is my example stored procedure, dynamically dropping…Jun 41Jun 41
JohanSnowflake — CI/CD toolingTL/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 16May 16
JohanSnowflake — 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 14May 14
JohanSnowflake CopilotOne of the public preview features that was recently launched: Snowflake Copilot. Introduced in April 2024, so Snowflake is a bit late to…Apr 30Apr 30
JohanSnowflake scriptingThis is really nice. Build blocks of code that can be used in stored procedures or tasks but also in the console.Apr 24Apr 24