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
Month: October 2024
Enhancing Data Privacy in Snowflake
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…… Continue reading Enhancing Data Privacy in Snowflake
The Power of Memoizable Functions in Snowflake
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…… Continue reading The Power of Memoizable Functions in Snowflake