Today I bring you a challenge! Just a fun little exercise to train your SQL skills. We are going to try to make derivatives in SQL. The Challenge Let's say…
If you are currently in the data field, or you are considering going into it, you will have probably heard about certifications. Today, I will give you my personal experience…
SQL Joins are a fundamental concept in SQL programming, used to combine data from two or more tables. Joins are essential when working with databases because they allow you to…
In writing previous blogs, I found myself having to search for old tables in which I had data to perform specific processing just to give examples and to make clear…
In the previous chapters of this series, we have seen how to load through staging data from foreign sources to your Snowflake account and how to do the reverse.Talking about…
Stored Procedures allow us to write functions inside our SQL code. In Snowflake you can use Scala in addition to usable UDF languages. The main difference between Stored Procedures and…
We have previously seen how to load data from foreign sources to your Snowflake account through staging.Particularly, we have focused on importing files from local client machines into internal stages…
User-Defined Functions allow us to write functions inside our SQL code. In Snowflake you can use SQL, Java, JavaScript and Python to write UDFs. While you are creating a UDF,…
As we have discussed in previous posts, Snowflake is a data-cloud platform that provides professionals with a variety of tools to work with data. One of its features is the…
Data storage is a critical component of any database system. When dealing with large amounts of data it is unthinkable to assume having to manually enter information - row by…