I’ve used snowflake in my last two jobs. There are a lot of things I love about the product, but cost management has always been a black art (perhaps deliberately). It is very difficult to allocate a cost to a specific workload unless you have a dedicated virtual warehouse per workload but this can quickly become inefficient if you have a lot of activity.
Snowflake’s built in cost management tools are pretty poor and most customers end up having to build their own from my observation. Something they need to improve on.