PinnedJohanMy presentation & code snippets from the Snowflake Dutch User Group MeetingYesterday I had the pleasure to present my topic ‘optimizing Snowflake from a cost and performance perspective’ at the Dutch User Group…1d ago1d ago
PinnedJohanOptimizing Snowflake — Your Complete Series for Peak Performance at Low CostHave been writing various articles about optimizing Snowflake from a cost/performance perspective. This article is a collection of all…Sep 11Sep 11
JohanOptimizing Snowflake (6) — Cost Optimization using 3rd party servicesWhen you want to analyse the Snowflake credit usage using readymade apps, there are several apps, either native or streamlit, published by…Sep 25Sep 25
JohanOptimizing Snowflake (5) — Queuing and spilling, your worst enemiesWhen executing queries, two things can happen that you want to avoid at all time. Why: because they will cause totally unpredictable…Sep 11Sep 11
JohanSnowflake — 120 day trialWe knew about the possibility to start a 30 day Snowflake trial. Just discovered a 120 day trial option. How to find it:Sep 10Sep 10
JohanOptimizing Snowflake (3) — Quick winsExecute these commands to set parameters for your warehouses plus additional settings on the account level. It will reduce credit usage…Sep 9Sep 9
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…Sep 5Sep 5
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