From the course: Learning SnowflakeDB

Unlock the full course today

Join today to access over 23,200 courses taught by industry experts.

Scenario: Optimize SnowflakeDB compute

Scenario: Optimize SnowflakeDB compute - Snowflake Tutorial

From the course: Learning SnowflakeDB

Scenario: Optimize SnowflakeDB compute

- [Instructor] Because optimizing the virtual warehouse for Snowflake DB is such a deep topic, like really all the other topics, but particularly this one in my associated companion, GitHub repo, I'll be continuing to build the information out. Anything that I mention here will be linked, but I'm going to continue to build this up because it's a frankly a topic I'm working on with some of my customers. So first of all, some of the basic stuff, it's important that your queries are written in the most optimal way, and there are some considerations around data types that you're going to want to understand when working with Snowflake DB. So this is a great summary. You can also just go to the documentation of Snowflake DB but you do want to understand the performance impact of using particular data types. So that's kind of a basic. Now, when you move into working with the warehouse, there is some great documentation that…

Contents