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,600 courses taught by industry experts.
Wrap-up of Snowflake’s core objects and architecture - Snowflake Tutorial
From the course: Intro to Snowflake for Devs, Data Scientists, Data Engineers
Wrap-up of Snowflake’s core objects and architecture
- You know a fair amount about Snowflake at this point, which is awesome. Let's quickly recap. You've learned how to navigate Snowsight, the Snowflake UI. You've learned how to create and use SQL worksheets, which are just one way of interacting with Snowflake, but very useful, even for long-time users. You've learned about Virtual warehouses, including how to scale them up by increasing the warehouse size, and how to scale them horizontally by turning them into multi-cluster warehouses. You've learned about Databases, Schemas, and Tables. You know that Tables are contained in Schemas and Schemas are contained in Databases. You've learned about Views, both the standard kind, which are basically stored queries, and materialized views, which automatically run when the underlying table they're based on is updated. You've learned about Semi-structured data and how to work with it in Snowflake, and you've learned about Snowflake's architecture, the four layers, storage, compute, cloud…
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.