From the course: Intro to Snowflake for Devs, Data Scientists, Data Engineers
Join today to access over 25,100 courses taught by industry experts.
Virtual warehouses scaling: Part 1 - Snowflake Tutorial
From the course: Intro to Snowflake for Devs, Data Scientists, Data Engineers
Virtual warehouses scaling: Part 1
- When I was younger, my older brother Dan told me that writing code is the closest thing we've got to modern day magic. You type out these incantations and run them, and voila, the world is different. This is definitely how I feel about scaling virtual warehouses. With a single line of code, you can scale up a virtual warehouse. This means you're temporarily laying claim to dramatically more compute resources from the Snowflake compute pool. Then with another line of code, you can scale back down all within a single workflow. Being able to scale up and down like this is really useful because this makes you much more efficient. You don't need to use vast compute resources for small jobs just because at one point in your workflow you'll require massive compute to, say, analyze a huge table. One concrete example, if we're working with a Tasty Bytes menu table, which is only a hundred rows, we don't need a large machine, but then we might need to query the orders table, which has more…
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.