Two queries you can use to track your free credits. For a trial account that is not yet converted to a paid account, a tile is shown in the left menu space. When converting the account (in my case, using CoCo I had to add a credit card) to paid,
Why Mistral ? It is EU based (French). Looks promising and they have collected some money for further expansion. ASML is one of the backers. I also use their chat extensively: https://chat.mistral.ai/chat. From https://mistral.ai/, go to Mistral Studio https://console.mistral.ai/home and have
You might have received an e-mail from Snowflake Support announcing some changes concerning worksheets & dashboards. In this article I will focus on dashboards and what to do. Legacy Dashboards are being retired, with migration paths to Streamlit apps or third-party BI tools Migrate dashboards before June 22,
Just published this post on Medium. https://bidutch.medium.com/european-alternatives-9dc41bd5bb80?source=friends_link&sk=56d3f41d196c776d9a883ed8f8ae162b
With some functions or keywords in Snowflake I can imagine what it is, but I have never used them and probably never will. But still, I…
Over the last 2 years, optimizing Snowflake from a cost perspective has been top of my list. My next step is to further expand this topic…
Shared my first MCP experience on LI this week:
Launching DBT from within Snowflake — Partner Connect:
Once you have set up your Snowflake account for key pair authentication, you can use the script below to test this:
When you want to log in to the AWS Console, check someting in Dev and also look in Acc (in the same browser), for instance to debug stuff…
Inspired by this article I decided this should be tested: -> a direct query from within Snowflake to a remote database.
I 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…
When using Snowflake’s UI Snowsight, code lives in the browser. I really like Snowsight, but the huge amount of tabs you end up with…
Yesterday I had the pleasure to present my topic ‘optimizing Snowflake from a cost and performance perspective’ at the Dutch User Group…
When you want to analyse the Snowflake credit usage using readymade apps, there are several apps, either native or streamlit, published by…
Query cost for hierarchical queries
Have been writing various articles about optimizing Snowflake from a cost/performance perspective. This article is a collection of all…
When executing queries, two things can happen that you want to avoid at all time. Why: because they will cause totally unpredictable…
We knew about the possibility to start a 30 day Snowflake trial. Just discovered a 120 day trial option. How to find it:
Execute these commands to set parameters for your warehouses plus additional settings on the account level. It will reduce credit usage…
After being able to identify the most expensive queries, the next step is to zoom in on individual cases. In the previous article, we…
When going to the website, it is quite easy to start a trial.
This is the first part of a new series of articles I will be posting here: how to optimize Snowflake for cost and performance.
TL;DR use this Snowflake Quickstart to explore Iceberg tables https://quickstarts.snowflake.com/guide/getting_started_iceberg_tables