John Summer PostgreSQL’s DISTINCT ON clause is a powerful tool for filtering result sets. However, the syntax is not available in Snowflake. Thankfully, there are several methods you can use to get the same results. This article walks you through three techniques that provide the equivalent of DISTINCT ON in Snowflake. Each method combines the ROW_NUMBER() windows … Read more
Tables in Snowflake are the primary structure for storing and organizing data within a database. As in other SQL-based systems, a table consists of rows and columns. You’ve probably worked with tables in other SQL systems, but Snowflake has specific benefits and limitations you need to understand. This article covers everything you need to know … Read more
In some database systems, you explicitly choose when to partition tables. In Snowflake, table partitioning happens automatically behind the scenes using a concept called micro-partitions. Although you don’t need an in-depth understanding of micro-partitions, you do need to understand how they allow you to cluster your tables for better performance. This article quickly explains the … Read more
Some of Snowflake’s competitors offer a free tier through restricted, community, or developer editions. Snowflake doesn’t do so for reasons I discuss later in this article. Snowflake offers a free trial for 30 days or until you use up $400 of free credits. It’s possible to use sequential free trials to continue working on the … Read more
While Databricks and Snowflake may seem similar at first glance, the two cloud-based platforms have distinct features, capabilities, and primary use cases that set them apart. Databricks provides an analytics platform designed for massive-scale data engineering and collaborative data science. Snowflake is a managed service that offers a cloud-based data warehousing platform built for easy … Read more
Snowflake was founded in 2012 by three data warehousing experts: Benoit Dageville, Thierry Cruanes, and Marcin Zukowski. Benoit Dageville and Thierry Cruanes both worked for Oracle for many years. Marcin Zukowski had co-founded a Dutch database company and worked for Actian before joining the two Frenchmen to form Snowflake. Benoit Dageville Benoit Dageville is a … Read more
I hadn’t heard of Stay22 as a hotel affiliate program until recently. It’s a relative newcomer in the travel affiliate world. My website had been turned down by Booking.com in 2022 (I’m not sure why). So, I decided to try out Stay22 as an alternative. You can use it if you already have an account … Read more
I used an Excel shape to make a nice-looking button that runs a macro on a protected worksheet. The shape frequently becomes invisible with repeated use of the worksheet and button. But the object hasn’t moved or been deleted from the sheet. I know this as I can still click the shape when I hover … Read more
This tutorial isn’t about how to make the best Google web stories. You’ll find plenty of videos for that. When I first watched those videos, I was completely confused. The steps they took didn’t seem to exist in the WordPress story editor. That’s because the interface has greatly changed. This article is to get you … Read more
There are three easy ways to find where your SQL Express database is located. Before we go through them step by step, I’ll quickly explain how your databases are stored. You may be surprised to learn that a database has more than one file. How SQL Express Stores Databases In Files Each SQL Express database … Read more