From the course: Intro to Snowflake for Devs, Data Scientists, Data Engineers
Join today to access over 24,600 courses taught by industry experts.
Wrap-up of Snowflake feature overview - Snowflake Tutorial
From the course: Intro to Snowflake for Devs, Data Scientists, Data Engineers
Wrap-up of Snowflake feature overview
- Okay. Wow, we just covered a lot of material. Pretty soon we'll be unstoppable Snowflake juggernauts. We learned about many Snowflake features as well as a few more Snowflake objects that we can add to the list of building blocks we picked up in the first module of the course. We learned about using time travel to return to our data in its past state, which is especially useful if you've made a mistake you want to undo. And we learned about how data retention is what makes this possible. We learned about the differences between permanent, temporary, and transient tables. Among other differences, permanent tables can have a retention period of up to 90 days if you're in the enterprise edition. Transient and temporary tables cannot. And temporary tables only persist as long as your session lasts. We learned about cloning tables, schemas, and databases. Specifically that cloning is zero copy and Snowflake tracks subsequent changes. We learned how to use resource monitors to put…
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.