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,…… Continue reading Unlocking Insights with Cost Data in Snowflake
Author: Kevin
Finding Out What’s Going On in your Database
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. Did something get published to Production that caused this new issue? (Thankfully, I’m the only one that pushes to Production in Snowflake…… Continue reading Finding Out What’s Going On in your Database
Consistency is the Key to Success
There is little worse than having to figure out which of several different ways to do something previous employees decided to do things. Over the last week, I began managing several SQL Servers as the DBA for a client. No worries there – it’s what I do. I began reviewing the first SQL Server. Backups…… Continue reading Consistency is the Key to Success
More Thoughts on Cloning in Snowflake
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…… Continue reading More Thoughts on Cloning in Snowflake
What more can we do with cloning?
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…… Continue reading What more can we do with cloning?
Pushing data into one table from another in Snowflake
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: INSERT INTO TableB (FirstName, LastName) SELECT FirstName, LastName FROM TableA; Yes, pretty simple. Basically, we’re grabbing all of the…… Continue reading Pushing data into one table from another in Snowflake
Now you want to see query results in email from Snowflake
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…… Continue reading Now you want to see query results in email from Snowflake
Sending out Emails from your database
To send an email in SQL Server, all that’s required is a fairly simple call of a stored procedure created by Microsoft. EXEC msdb.dbo.sp_send_dbmail @recipients = ‘sherpa@sherpaofdata.com’, @body = ‘The stored procedure finished successfully.’, @subject = ‘Automated Success Message’; Now, there are several more parameters you can use. Below are some of my favorites that…… Continue reading Sending out Emails from your database
Comparing Email Configuration in SQL Server and Snowflake
Today, I want to talk about all the effort that goes into setting up the ability to email in SQL Server and Snowflake. First is our old friend – SQL Server. I’ll leave this one to the experts at Microsoft. As has been the case over the last few years, they have some great documentation…… Continue reading Comparing Email Configuration in SQL Server and Snowflake
Simplifying Data Masking in Snowflake with Tags
In our last post, we discussed data masking and setting it up for specific columns. Now, I don’t know about y’all, but I deal with hundreds of tables with several columns in each on a daily basis that truly need data masking. If I have to go through and set up a masking policy one…… Continue reading Simplifying Data Masking in Snowflake with Tags