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,800 courses taught by industry experts.

Virtual warehouses overview

Virtual warehouses overview - Snowflake Tutorial

From the course: Intro to Snowflake for Devs, Data Scientists, Data Engineers

Start my 1-month free trial Buy for my team

Virtual warehouses overview

“

- So far, we've done a few things. We've learned about the fictional Tasty Bytes dataset, hopped into Snowsight, loaded a worksheet, queried some data, and created a new worksheet. And now you've actually run a query in Snowflake on your own. Very fun. One thing we went through very quickly, and I said at the time that we'd returned to it in a future video is the use warehouse command. Well, I have good news. This is that future video and we're going to have a great time learning about virtual warehouses. So what is a virtual warehouse? The Snowflake docs define it as a cluster of compute resources in Snowflake. I like it when things are concrete. So when I spin up a virtual warehouse, I think about the cluster I'm accessing from the Snowflake pool from AWS, GCP or Azure. In my mind's eye, I can see the machine and say the AWS Oregon West region, and I'm now in command of some CPU memory and temporary storage resources. In this video, we'll talk about what Use Warehouse does. We'll…

Contents