From the course: Introduction to Modern Data Engineering with Snowflake

Unlock this course with a free trial

Join today to access over 24,400 courses taught by industry experts.

Data transformations with SQL

Data transformations with SQL - Snowflake Tutorial

From the course: Introduction to Modern Data Engineering with Snowflake

Start my 1-month free trial Buy for my team

Data transformations with SQL

“

We're going to be building a pipeline that tracks anomalous sales data and daily sales metrics for specific cities where Tasty Byte operates. You've already loaded all of the raw data into your Snowflake account necessary to do this. If you haven't, ensure you complete the corresponding reading in the previous module. With the raw data now in Snowflake, we can begin transforming it. In this video, you'll learn how to use SQL to perform those transformations. Before getting into the details, let's go over a couple of things. First, this isn't a SQL course, so I won't focus on teaching you SQL syntax, but you also don't need to be a SQL expert to follow along. What I'd like for you to focus on is how and where transformations might be performed. You can always look up SQL syntax independently. Second, this isn't a data modeling course. We won't cover the theory behind how to structure or model your data. The goal is simply for you to learn just enough to confidently perform…

Contents