Wrap-up of Snowflake’s Core Objects and Architecture
1. 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 are 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 services, and Snowgrid. So this is a good moment to check in. How are you feeling? It’s presumptuous to tell someone how they should be feeling, but I’ll just say this – In the middle of all of the other things you’re feeling, I think you should be feeling proud you’ve come this far! It sounds trite, but I’ve taken a bunch of online courses, and it can be challenging to stick with it. I think you’re doing great, and in my opinion, knowing what we’re about to cover, it’s only going to get more fun from here!2. Let's practice!
Create Your Free Account
or
By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.