From the course: Intro to Snowflake for Devs, Data Scientists, Data Engineers

Unlock this course with a free trial

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

Snowflake data engineering overview: Part 2

Snowflake data engineering overview: Part 2

- In continuing our discussion about Snowflake data engineering, we're now going to cover data transformation, orchestration and observability. First, let's talk about data transformation. We already did a video on Snowpark dataframes, so you should be at least somewhat familiar with that. Though I recognize we moved through that quickly, so no worries if you didn't retain much. We've also covered UDFs and UDTFs as well as stored procedures, which are useful tools as you try to convert your data from a raw state into a more usable final form. And of course, SQL is a powerful tool for data transformation. It is a ton of built-in functions, and I want to include it here just so we don't overlook one of the most critical tools of them all just because it's so familiar to us. The major item here that we haven't covered much yet is dynamic tables, though we touch on it very briefly in our video on views, since they are similar in many ways. In fact, I think the easiest way to think about…

Contents