Sherpa of Data

Tag: Snowflake

  • When you have a really bad morning in Snowflake

    —

    by

    Kevin
    in

    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…

  • Getting New and Old Columns to a Table

    —

    by

    Kevin
    in ,

    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. This works great if…

  • How to Efficiently Change Data Types in Snowflake for Optimal Performance

    —

    by

    Kevin
    in

    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…

  • Even more Great Queries Using Query History

    —

    by

    Kevin
    in

    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…

  • Some Great Queries Using the Query History

    —

    by

    Kevin
    in

    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…

  • Even more Query History in Snowflake

    —

    by

    Kevin
    in

    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…

  • Querying History By Sessions in Snowflake

    Querying History By Sessions in Snowflake

    —

    by

    Kevin
    in

    Last time, we talked about a query using the Query_History_By_User table function in Snowflake. This time, I want to discuss a similar table function named Query_History_By_Session. Thankfully, it works in a very similar fashion to Query_History_By_User. Yes, it shows the same information as Query_History_By_User, so I am not displaying it here. By the table function…

  • Cool Items in Snowflake that Aren’t in SQL Server

    —

    by

    Kevin
    in

    Yes, I know. The name of today’s post is certainly clickbait. But it’s true! There are so many things you can do in Snowflake that may – or may not – be possible in SQL Server, at least not without several tricks and possibly low-level querying. So, let’s start shall we? What did I run?…

  • Common Table Expressions Can Be A Good Thing

    —

    by

    Kevin
    in ,

    Most of our coding these days has Common Table Expressions, also known as CTEs. If not, you’re either working on an older version of SQL Server or you haven’t been introduced to this piece of goodness. CTEs can make reading SQL queries a lot easier if the logic is convoluted. For example, let’s use the…

  • Basic Analysis of Data with Snowflake

    —

    by

    Kevin
    in

    Now and again, you’ll be asked to do some basic analysis of your data in Snowflake. Now by “basic analysis,” I mean for each column tell how many rows are populated, what’s the largest and smallest value in the column, etc… Some of you will want to review each and every column of every table…