From the course: Data Platforms: Spark to Snowflake

Unlock this course with a free trial

Join today to access over 24,600 courses taught by industry experts.

Snowflake warehouses

Snowflake warehouses

From the course: Data Platforms: Spark to Snowflake

Start my 1-month free trial Buy for my team

Snowflake warehouses

“

- [Instructor] Now, when we go back to our worksheets, here we've created a new notebook. To run any SQL in a notebook, you need to be associated with the warehouse that will run this. Now, if we click here, we could normally set that, but we notice that our dev role doesn't have access to any warehouses. So, similar to what we did with the database and schema privileges, we need to give this role privileges to run a warehouse. Under the Admin section, we find warehouses. These are the two warehouses we have. We click on the warehouse, we can see the warehouse activity, details, and last, the privileges. So let's grant our dev role privileges to use this warehouse. Now, the privilege to modify warehouses may commonly be restricted. So now if we go back to our dev role, go to our worksheet, and we look under warehouses, we can see that that test warehouse is now available. Now we can select the warehouse in this interface, and we will use that warehouse for any Snowflake SQL we run in…

Contents