Skip to content

Sherpa of Data

Helping people to understand data in all of it's forms

  • Home
  • Blog
  • Tools
  • Presentations
  • Presentation Exercises
  • About
  • Contact

Month: August 2024

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

Published August 27, 2024
Categorized as SQLBasics Tagged SQL, T-SQL

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

Published August 20, 2024
Categorized as Snowflake Tagged Snowflake

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

Published August 13, 2024
Categorized as Snowflake Tagged Snowflake

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

Published August 6, 2024
Categorized as Snowflake Tagged Snowflake

Recent Posts

  • Dashboard Dreams and Snowflake Schemes
  • Unlocking Insights with Cost Data in Snowflake
  • Finding Out What’s Going On in your Database
  • Consistency is the Key to Success
  • More Thoughts on Cloning in Snowflake

Archives

  • April 2025
  • February 2025
  • January 2025
  • December 2024
  • November 2024
  • October 2024
  • September 2024
  • August 2024
  • July 2024
  • May 2024
  • April 2024
  • March 2024
  • January 2024
  • December 2023
  • September 2023
  • August 2023
  • July 2023
  • June 2023
  • May 2023
  • April 2023
  • March 2023
  • February 2023
  • January 2023
  • December 2022
  • November 2022
  • September 2022
  • May 2022
  • April 2022
  • March 2022
  • February 2022
  • January 2022
  • December 2021
  • November 2021
  • October 2021
  • September 2021
  • August 2021
  • July 2021
  • June 2021
  • May 2021
  • April 2021
  • March 2021
  • February 2021
  • October 2020
  • September 2020
  • August 2020
  • July 2020
  • October 2019
  • September 2019
  • August 2019
  • June 2019
  • April 2019
  • March 2019
  • February 2019
  • January 2019
  • November 2018
  • August 2018
  • April 2018
  • March 2018
  • October 2017
  • September 2017
  • August 2017
  • July 2017
  • June 2017
  • May 2017
  • April 2017
Sherpa of Data
Privacy Policy
Proudly powered by WordPress.