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
JohanFree training resourcesIn one of my Notion notebooks, I am maintaining a link of free training resources, for those rainy Sunday afternoons. Why not open it up…Apr 1Apr 1