From the course: Intro to Snowflake for Devs, Data Scientists, Data Engineers
Join today to access over 25,000 courses taught by industry experts.
Views: Part 1 - Snowflake Tutorial
From the course: Intro to Snowflake for Devs, Data Scientists, Data Engineers
Views: Part 1
- Now we get to talk about views, and no, I don't mean political views or views of a cityscape. I'm talking about the very best kind of view, views in the land of data. Anyway, learning about Snowflake views is important, because one, they're useful, and two, they pop up all the time. So even if you're like, "Look, I'm a simple human with simple tastes, I don't need views in my life, basic tables suffice," you're still going to need to learn about them, because you'll run into them everywhere. In fact, if you've been looking closely, you might have already noticed them a few times in this course. There are two kinds of views: standard, non-materialized views, and materialized views. Going forward, when we're talking about a materialized view, we'll always specify that, so if we just say view, that means we're talking about a non-materialized view, and don't worry, we'll cover both. Okay, so let's first look at an example of a standard view. Let's open our SQL worksheet called Views…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.
