PinnedMy 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…Oct 9, 2024Oct 9, 2024
PinnedOptimizing 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 11, 2024Sep 11, 2024
Loading data from a remote database into Snowflake ….. without ETL toolsInspired by this article I decided this should be tested: -> a direct query from within Snowflake to a remote database.Jan 5Jan 5
Using Snowflake with Python and CopilotI like to play around with Snowflake. Also with Python. And then also combining the 2, for cases such as generating SQL using Python and/or…Dec 6, 2024Dec 6, 2024
Snowflake & GITWhen using Snowflake’s UI Snowsight, code lives in the browser. I really like Snowsight, but the huge amount of tabs you end up with…Nov 1, 20241Nov 1, 20241
Optimizing 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 25, 2024Sep 25, 2024
Optimizing 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 11, 2024Sep 11, 2024
Snowflake — 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 10, 2024Sep 10, 2024
Optimizing 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 9, 2024Sep 9, 2024
Optimizing 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 5, 2024Sep 5, 2024