Tag: 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…

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…

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…

The premise behind data masking is fairly simple – make it so that only certain people can see the data in a certain column. For example, social security numbers or credit card numbers probably shouldn’t be seen by everyone who has access to your database. I like to set it up as follows: (Obviously, this…

If you’ve been working with data for several years like I have – mostly using the SQL language – then I have a term for you that other languages, like JavaScript or Python, have had for a few years. The term is “memoizable” and it means, in a nutshell, to remember. A memoizable function caches…

When working with one of the many modern computer languages that use libraries, one of the many things to be aware of – as a developer – is the version of the libraries available for your usage. Since there are multiple languages in Snowflake that use libraries, let’s go over how to check out the…