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
Month: August 2024
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