Today, we’re starting on Day 3 of the #AdventOfCode series. There’s a lot to cover here, so let’s get started, shall we? As always, we must load the data into our database. In my case, I’m loading it into a table called AOCDay3 – memorable and easy to type all in one. The first thing…… Continue reading Walking Through the Advent of Code Day 3
Author: Kevin
Walking Through the Advent of Code Day 2 Part 2
So many days of Advent! So many chances to practice SQL! Today, we’ll be working on the next in the series using the data and processes that we found yesterday in Day 2 Part 1 – found here. Thankfully, we were smart when we began working through the data and we have the data for…… Continue reading Walking Through the Advent of Code Day 2 Part 2
Walking Through the Advent of Code Day 2
Time to celebrate my friends! We’ve made it all the way to Day 2! On day 2, we are asked to gather data from a series of games and to see which of those are possible given a specific number of dice for a few colors. Fun times! As always, the first thing we have…… Continue reading Walking Through the Advent of Code Day 2
Walking Through the Advent of Code Day 1 Part 2
Hopefully, you’ve read Walking Through the Advent of Code Day 1 – otherwise, this post is going to be like walking into a 4″x4″ post – rather jolting. I also hope that you’re making progress on the #AdventOfCode series. I’m sure some of you are on the Overall Leaderboard. Be sure to check on the…… Continue reading Walking Through the Advent of Code Day 1 Part 2
Walking Through the Advent of Code Day 1
Sometimes you need to step back, walk through various coding adventures, and rebalance yourself. Thankfully, I have found one set that I like – and has been running for several years. And it’s all about our actual season – the Advent season. (If you’re reading this long after it’s published, you can also figure out…… Continue reading Walking Through the Advent of Code Day 1
Making Python work with Snowflake For Fun and Pleasure
As we did last week in our post on Creating a new function in Snowflake, I want to talk about some of the scripts and languages I use to make my life easier in Snowflake. As the site LearnPython says: “Today, Python is one of the most popular programming languages because of its beginner-friendly syntax, efficiency, and…… Continue reading Making Python work with Snowflake For Fun and Pleasure
Creating a new function in Snowflake
Sometimes, you’ll need to create functions that do a particular thing. They’re not always pretty. Some of them look like they should have been thrown out with the bathwater. Unlike SQL Server, user-defined functions in Snowflake can be done in several different languages. They can be done in Java, JavaScript, Python, Scala, or plain-old SQL.…… Continue reading Creating a new function in Snowflake
Different ways to get to the same thing
When you’re trying to complete a task for the business, the most important thing is to get the data right. Second most important task is to get the data quickly. One of the ways we can get better at speed is to attempt several slightly different ways that can get you (hopefully) the same data.…… Continue reading Different ways to get to the same thing
Check Out these URLs with Snowflake Functions
When we’re working with fields that have websites in them, one of the things that we should be doing with them is to double-check that they’re well-formed and usable. Thankfully, Snowflake has a function just for that. With the PARSE_URL function, we can check out if everything is properly formed – meaning that we have…… Continue reading Check Out these URLs with Snowflake Functions
In CASE You Want to Use Logic in Snowflake
Sometimes you need to check one field to see if you want to display another field. Sometimes you show one of two fields depending on the value in yet another field. Sometimes you just need to relax… https://www.youtube.com/watch?v=SxS_DvDiuRI Today, though, we’re going to go thru a myriad of functions that you can use in Snowflake…… Continue reading In CASE You Want to Use Logic in Snowflake