Category: Snowflake

Last time, in Dashboard Dreams and Snowflake Schemes, we talked a little about showing how much Snowflake really costs in a dashboard internal to Snowflake itself instead of having to push it to PowerBi, Tableau, Looker, or a myriad of other tools. This time, let’s take it a step further: instead of sticking with the…

Normally, you’ll notice that I like to email myself items on a regular schedule so that I am aware of what’s going on in my Snowflake instance. But, that’s not the only way to get data… If you haven’t had a chance to mess around in Snowflake, there are internal dashboards that you can provide…

In today’s blog, I want to do something a little different. I want to walk through a request I had from a user and how it went from “Eh…” to “Bam!” The initial request from a user—yes, this user is in management—was to see the costs for Snowflake each day of the current month. Yes,…

Over the last few days, a task that only runs once per day has failed for unknown reasons. First, I’ve thought back on the regular responses to understand why it could have failed. Since this task runs multiple processes, and logging each query seems like overkill, there must be a better way. Well, my friends,…

Recently, I was asked to compare data from a table in Snowflake with the same table’s data from a few hours before. As always, no one had thought about copying the data into another table before they started working with it. They just remembered an approximate time they started working with the table — 10…

In our last post, we discussed what is known as “Zero-Copy Cloning” in Snowflake. We were able to copy a table without taking up any space and extremely quickly with one short command! Now, I know what you’re thinking… One table at a time. Now I know what you’re thinking “Copying some of my databases…

Most of us have run across the scenario where we have data in one table, but we need the exact same data in another table in another database. In SQL Server, I’d do it this way: Yes, pretty simple. Basically, we’re grabbing all of the data from TableA and inserting it into TableB. A few…

In our last post, we discussed the most basic of all ways how in Snowflake you can send out a basic email. It was pretty simple, straight text – nothing to really grab the attention of our readers – which we know is the way to craft an email, right? To do this, we’re going…

To send an email in SQL Server, all that’s required is a fairly simple call of a stored procedure created by Microsoft. Now, there are several more parameters you can use. Below are some of my favorites that I use often. For the many other parameters you can use with sp_sendmail, please refer to the…