Wrap-up of Snowflake Feature Overview

1. 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 guardrails on our credit usage. We learned how to create user-defined functions – UDFs – and user-defined table functions – UDTFs – when we need a custom function. We learned about stored procedures, and how you can run commands like ALTER, CREATE, DROP, INSERT, and COPY INTO, with those, but you can’t with UDFs. We also learned that stored procedures aren’t required to return a value. But like UDFs, you can write their internals in multiple languages – like Python, Java, Javascript, Scala, or SQL. We learned about how simple it is to work with role-based access control in Snowflake. We learned how to download VS Code and connect to Snowflake through the Snowflake VS Code extension. We learned how to use Snowpark Dataframes for data manipulation. We learned that the Snowflake CLI enables us to do lots of Snowflake work through our command line – including a bunch of kinds of work we haven’t learned about yet. I think you should be proud! You’re getting to the end of the course, and at the very least, you’re becoming familiar with lots of critical Snowflake objects and features. And I’ll add that even though I don’t know you, I’m proud of you for coming this far! I probably shouldn’t say I’m like a proud father, because I’m only in my mid-30s and my guess is not too many of you are younger than, say, 10 or so. So what I’ll say is I’m like a proud uncle or nephew. A proud uncle nephew. Very proud.

2. Let's practice!

Create Your Free Account

By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.