Data validation in Snowflake
As a follow up of my previous blog on SQL injection into Snowflake, I made a small demo about data validation in Snowflake. Data validation is the practice of checking...... Leer más.
What are Moving Averages?
If you have been in the data environment for some time you will have probably heard dozens of different metrics that can be used to extract information from data.... Leer más.
Optimizing SQL Queries in Snowflake
In this blog, we’ll discuss practical tips and tricks to optimize SQL queries in Snowflake for better performance. Best practices for query design, data structure... Leer más.
From JSON to XML: A Deep Dive into Snowflakes File Types
Snowflake is a cloud-based data warehousing solution that has become increasingly popular in recent years due to its scalability and ease of use. As more and more... Leer más.
Challenge: Integrals in SQL?
Last week I brought you a challenge on how to make derivatives in SQL. Evidently, this week we are looking into how to make integrals in SQL! The Challenge Let’s...... Leer más.
SQL Case Statements
We have already seen how nesting aggregated functions and SQL join types work in the previous articles for the basics of SQL. Following, we will understand how case... Leer más.
