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…… Continue reading Basic Analysis of Data with Snowflake
Scrutinizing the Data in All of our tables
Today, I was working with SQL Server to get row counts from several tables so I thought I’d be smart and work with some functions in SQL Server to make it smarter / easier. Now, if I am truly only getting “straight” row counts from these tables, I would be able to create a query…… Continue reading Scrutinizing the Data in All of our tables
Removing Objects Is Not So Simple
When you’re working between SQL Server and Snowflake, there can be a lot of crossover that may make you forget what system you’re working in. Sometimes it’s close, but not close enough. Today, let’s go over something that should be rather simple – removing old objects that we shouldn’t need any longer. In SQL Server,…… Continue reading Removing Objects Is Not So Simple
Walking Through Advent of Code Day 9 Part 2
Welcome back after a long, much-needed break! Hopefully, you’ve had time to reenergize and are now ready to start 2024 with a bang! Thankfully, the elves were semi-nice to us for part 2 and only slightly changed their requests and wanted us to find the first number in the solution instead of the last. If…… Continue reading Walking Through Advent of Code Day 9 Part 2
Walking Through Advent of Code Day 9
And so day 9 begins. Today, our elves are working hard on having us come up with the next number in a sequence. Thankfully, they do give us a few good examples to walk through on how they would like us to do it. And with that, it’s off to the races! As always, we…… Continue reading Walking Through Advent of Code Day 9
Walking Through Advent of Code Day 8 Part 2
With Day 8 part 1 being all about traversing tables, I’m sure our little friends the elves will find a new way to make this harder for us. First, we find out that we’re now starting with multiple positions – anything that ends with an A – and finishing anywhere that ends in a Z.…… Continue reading Walking Through Advent of Code Day 8 Part 2
Walking Through Advent Of Code Day 8
Day 8 is gonna be fun-filled and exciting I can tell it from here! To make life a little simpler for all of us, I used a variable that I just pasted my instructions into. In my case, I called it @FollowThis allowing it to be up to 300 characters in length. Hopefully, no one’s…… Continue reading Walking Through Advent Of Code Day 8
Walking Through Advent of Code Day 7 Part 2
So, we got tired of playing Camel Cards and decided to throw some Jokers into the mix. This time, our wonderful friends the elves have decided that they don’t like Jacks but they do like Jokers. So, there are a few changes to our code that will need to be made: with cte as (…… Continue reading Walking Through Advent of Code Day 7 Part 2
Walking Through Advent Of Code Day 7
No longer are we racing… Now, we’re playing cards. Not just any cards though. This time we’re playing Camel Cards – if you get the gist of poker, you can get Camel Cards fairly quickly. As always, have some fun trying different ways to push the data into your SQL Server. Why not try using…… Continue reading Walking Through Advent Of Code Day 7
Walking Through Advent of Code Day 6 Part 2
Yet again those little elves have been devilish and messed up our input format. This time, they put spaces in our data. https://youtu.be/JuCMJWSK6Bk?si=OOcOqn2JjWwpgnLb You put Chocolate in my Peanut Butter! Sadly, this does make our numbers rather large, so we’re back to using the big ole Tally table we created for Walking Through Advent of…… Continue reading Walking Through Advent of Code Day 6 Part 2