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
Author: Kevin
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
Checking Out The Snowflake Packages
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…… Continue reading Checking Out The Snowflake Packages
When you have a really bad morning in Snowflake
This week, I want to talk about something we’ve all done at least once – especially before our first cup of coffee in the morning. Yes, that’s right – dropping tables and databases. So we have our table from last time still existing in our database: We’re trying to get rid of a table from…… Continue reading When you have a really bad morning in Snowflake
Getting New and Old Columns to a Table
In my last post, we worked out how to change the data type of a field if it already existed and was found to need changing. This time, I want to add a fresh, new column to an existing table. In SQL Server, I would be doing something like the following. ALTER TABLE dbo.TestTable ADD…… Continue reading Getting New and Old Columns to a Table
How to Efficiently Change Data Types in Snowflake for Optimal Performance
When working with data, I usually have an idea of what type of data I will push into a field. Sometimes, for whatever reason, it is decided to change the type of data allowed in the field. Today, I want to show how that’s done in Snowflake. I will start out working with a simple…… Continue reading How to Efficiently Change Data Types in Snowflake for Optimal Performance
Odd things found when working with data
Sometimes, you’ll find all sorts of craziness when you’re working with data. Especially if you don’t expect there to be any craziness. Let me show you what I mean by a story of what I had happen just this week. In mapping some data from one database to another, I was asked to do the…… Continue reading Odd things found when working with data
Even more Great Queries Using Query History
In our last post, we talked about some of my favorite queries I use in Snowflake to see various items of interest – such as finding the worst-performing queries. For today’s post, though, I want to talk about performance tuning. Yes, you read that right. We’re going to use query history to do some fun…… Continue reading Even more Great Queries Using Query History
Some Great Queries Using the Query History
Now that we know so much about getting data from Snowflake using the query history, we should be able to get all kinds of data that will be helpful for us. In the next few queries, I want to provide some queries I use that should make your Snowflake usage a bit more useful. The…… Continue reading Some Great Queries Using the Query History
Even more Query History in Snowflake
In previous posts, we have discussed differing ways of getting at the query history. In those posts, we discussed getting that data by the session or by a specific user. Today, I want to examine another way of getting to that data. This new way – is by warehouse. I have tried to set up…… Continue reading Even more Query History in Snowflake