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...... Leggi tutto.
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.... Leggi tutto.
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... Leggi tutto.
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... Leggi tutto.
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...... Leggi tutto.
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... Leggi tutto.
Snowflake’s Security Measures against Cyber Threats
The Barrier Between Your Data and Cyber Threats Snowflake’s data platform has gained popularity for its advanced security measures. Data security is becoming... Leggi tutto.
