100 Snowflake Cost Optimization Techniques

100 Snowflake Cost Optimization Techniques, available at $44.99, has an average rating of 4.7, with 121 lectures, 11 quizzes, based on 15 reviews, and has 2435 subscribers.

You will learn about Create and run cost-effective queries Consolidate underutilized warehouses Monitor and improve query performance How using a bigger warehouse could cost you less Watch over longest running and frequently executed queries Serverless features in detail: cost and how they work Avoid cost traps by setting different parameter values How to combine different Snowflake editions Save on costs with parallel data transfer and processing Design and architect applications with cost impact in mind This course is ideal for individuals who are Snowflake account owners who want to reduce their spending or Snowflake consultants who want to advise their clients on Snowflake spending or Anyone using Snowflake in their organization who wants to control their costs or Managers looking to cut their Snowflake spending by half or Technical persons who want to learn about all ways to cut spending on this data warehouse or Data Engineers and Architects looking to create cost-effective apps around Snowflake or Data Scientists who want to avoid spending traps when using Snowflake for Data Science apps It is particularly useful for Snowflake account owners who want to reduce their spending or Snowflake consultants who want to advise their clients on Snowflake spending or Anyone using Snowflake in their organization who wants to control their costs or Managers looking to cut their Snowflake spending by half or Technical persons who want to learn about all ways to cut spending on this data warehouse or Data Engineers and Architects looking to create cost-effective apps around Snowflake or Data Scientists who want to avoid spending traps when using Snowflake for Data Science apps.

Enroll now: 100 Snowflake Cost Optimization Techniques

Summary

Title: 100 Snowflake Cost Optimization Techniques

Price: $44.99

Average Rating: 4.7

Number of Lectures: 121

Number of Quizzes: 11

Number of Published Lectures: 121

Number of Published Quizzes: 11

Number of Curriculum Items: 132

Number of Published Curriculum Objects: 132

Number of Practice Tests: 1

Number of Published Practice Tests: 1

Original Price: $109.99

Quality Status: approved

Status: Live

What You Will Learn

Create and run cost-effective queries
Consolidate underutilized warehouses
Monitor and improve query performance
How using a bigger warehouse could cost you less
Watch over longest running and frequently executed queries
Serverless features in detail: cost and how they work
Avoid cost traps by setting different parameter values
How to combine different Snowflake editions
Save on costs with parallel data transfer and processing
Design and architect applications with cost impact in mind

Who Should Attend

Snowflake account owners who want to reduce their spending
Snowflake consultants who want to advise their clients on Snowflake spending
Anyone using Snowflake in their organization who wants to control their costs
Managers looking to cut their Snowflake spending by half
Technical persons who want to learn about all ways to cut spending on this data warehouse
Data Engineers and Architects looking to create cost-effective apps around Snowflake
Data Scientists who want to avoid spending traps when using Snowflake for Data Science apps

Target Audiences

Snowflake account owners who want to reduce their spending
Snowflake consultants who want to advise their clients on Snowflake spending
Anyone using Snowflake in their organization who wants to control their costs
Managers looking to cut their Snowflake spending by half
Technical persons who want to learn about all ways to cut spending on this data warehouse
Data Engineers and Architects looking to create cost-effective apps around Snowflake
Data Scientists who want to avoid spending traps when using Snowflake for Data Science apps

What You Will Learn About Spending

How to use even bigger virtual warehouses for less expensive queries.
How to avoid huge cost traps in Snowflake by changing different parameter values.
How to optimize queries, compute, storage and overall costs in Snowflake.
How to properly consolidate underutilized warehouses.
How each serverless feature in Snowflake works and how to estimate their cost.
How to use parallel data transfer and processing everywhere you can.
How to combine different Snowflake editions in your organization.
How to use better data visualizations to estimate spending.
How to reduce your spending on all your Snowflake accounts.
I also offer over 300 high-quality presentation slides with the summary on each tip or technique!

Where You May Use This Knowledge

Drastically reduce costs on your own Snowflake accounts.
Create more Snowflake accounts – with different editions – and use them efficiently.
Help your clients reduce spending on their Snowflake accounts.
Help your employer reduce costs on Snowflake in your own organization.
Learn to recognize the traps most people fall into when using Snowflake.
Create not just highly performant, but also cost-effective SQL queries.
Learn how to get cheaper queries with huge warehouses, using hundreds of nodes.
I also offer an open-source GitHub repository with dozens of hands-on exercises and experiments!

What You Will Learn About Snowflake

Learn all about the virtual warehouses.
Learn how to monitor and optimize queries.
Learn about resource monitors and budgets.
Learn query acceleration and search optimization
Estimate efficient automatic clustering and maintenance of materialized views.
Learn all that matters about time travel and zero-copy cloning.
Learn how to efficiently deploy and combine Snowflake with other applications.
I have many brief but focused hands-on presentations of different Snowflake features!

Who I Am

The only world-class expert from Canada selected for the Snowflake Data Superhero program in 2021.
SnowPro Certification SME (Subject Matter Expert) – many SnowPro exam questions have been created by me.
Passed four SnowPro certification exams to date (with no retakes): Core, Architect, Data Engineer, Data Analyst.
Specialized in Snowflake for the past few years: I worked for Snowflake Partner companies, I served dozens of clients in this capacity or as an independent consultant, today I share my knowledge with highly specialize courses on Snowflake.

This is truly “the” Bible on Snowflake spending!

No other course, book or documentation around will offer as much insights, hands-on experiments and knowledge transfer on optimizing the cost on Snowflake as my course here, guaranteed!

Enroll today, and keep this course forever!

Course Curriculum

Chapter 1: Introduction

Lecture 1: Course Structure and Content

Lecture 2: Best Ways to Benefit from this Course

Lecture 3: SnowPro Snowflake Certifications: Added Material!

Lecture 4: Create a Free Trial Snowflake Account

Lecture 5: Free Hands-On Project Setup

Chapter 2: Virtual Warehouses

Lecture 1: Introduction to Virtual Warehouses

Lecture 2: Tip #1: Larger Virtual Warehouses May Actually Cost You Less

Lecture 3: Tip #2: Auto-Suspend Any Warehouse After One Minute

Lecture 4: Tip #3: Any Resumed Warehouse Will Cost You at Least One Minute

Lecture 5: Tip #4: Never Auto-Suspend Any Warehouse After Less Than One Minute

Lecture 6: Tip #5: X-Small Warehouses Could Be Powerful Enough

Lecture 7: Tip #6: Resized Warehouses are for More Complex Queries

Lecture 8: Tip #7: Multi-Cluster Warehouses are for Multiple Users and Concurrency

Lecture 9: Tip #8: Multi-Cluster Warehouses Should Always Have Min Clusters 1

Lecture 10: Tip #9: Use Economy Scaling Policy To Save Money

Lecture 11: Tip #10: When to Use Snowpark-Optimized Warehouses

Chapter 3: Compute Workloads

Lecture 1: Introduction to Compute Workloads

Lecture 2: Tip #11: Use Resource Monitors

Lecture 3: Tip #12: Use Account-Level Budgets

Lecture 4: Tip #13: Prevent Never-Ending Queries

Lecture 5: Tip #14: Manually Kill Running Queries

Lecture 6: Tip #15: Reduce Warehouse Sizes

Lecture 7: Tip #16: Consolidate All Warehouses

Lecture 8: Tip #17: Use Parallel Jobs for Batch Transformations

Lecture 9: Tip #18: Avoid Checking Too Much on Metadata

Lecture 10: Tip #19: Charts for Warehouse Monitoring

Lecture 11: Tip #20: Revisit the Main Traps with Warehouses

Chapter 4: Snowflake Accounts

Lecture 1: Introduction to Snowflake Accounts

Lecture 2: Tip #21: What to Choose for a Free Trial Account

Lecture 3: Tip #22: When to Use a Free Trial Account

Lecture 4: Tip #23: Understand Price Tables for Virtual Warehouse Compute Services

Lecture 5: Tip #24: Understand Price Tables for Cloud and Serverless Services

Lecture 6: Tip #25: Understand Price Tables for Storage and Data Transfer

Lecture 7: Tip #26: Use the Account Overview Interface in Snowsight

Lecture 8: Tip #27: Use Organization Accounts

Lecture 9: Tip #28: Limit Warehouse Changes with Access Control

Lecture 10: Tip #29: Adjust Default Values of Account-Level Parameters

Lecture 11: Tip #30: Careful with Reader Accounts

Chapter 5: Snowflake Editions

Lecture 1: Introduction to Snowflake Editions

Lecture 2: Tip #31: When to Choose Enterprise over Standard Edition

Lecture 3: Tip #32: How to Avoid Multi-Cluster Warehouses

Lecture 4: Tip #33: When to Use Incremental Materializations

Lecture 5: Tip #34: How to Emulate Materialized Views

Lecture 6: Tip #35: The Case for Extended Time Travel

Lecture 7: Tip #36: Use Standard Edition Account for Analytics

Lecture 8: Tip #37: Use Separate Standard Edition Account for Common Queries

Lecture 9: Tip #38: How to Reduce Costs to Zero for an Inactive Paid Account

Lecture 10: Tip #39: When to Choose the Business Critical Edition

Lecture 11: Tip #40: When to Choose the Virtual Private Snowflake (VPS) Edition

Chapter 6: Query Monitoring

Lecture 1: Introduction to Query Monitoring

Lecture 2: Tip #41: Monitor Longest Running Queries

Lecture 3: Tip #42: Interpret Query History

Lecture 4: Tip #43: More Charts for Query Monitoring

Lecture 5: Tip #44: Use Query Tags

Lecture 6: Tip #45: Reduce Frequency of Simple Queries

Lecture 7: Tip #46: Reduce Frequency of Metadata Queries

Lecture 8: Tip #47: Reduce Frequency of SHOW Commands

Lecture 9: Tip #48: Clone Less Frequently

Lecture 10: Tip #49: Change Query Schedules

Lecture 11: Tip #50: Parallel over Sequential Transfer and Processing

Chapter 7: Query Optimization

Lecture 1: Introduction to Query Optimization

Lecture 2: Tip #51: Use the Query Profile

Lecture 3: Tip #52: Use the Explain Statement

Lecture 4: Tip #53: Use Data Caching

Lecture 5: Tip #54: Queries on Data Lakes

Lecture 6: Tip #55: Use Vectorized Python UDFs

Lecture 7: Tip #56: Use Batch Commands to Prevent Transaction Locks

Lecture 8: Tip #57: Reduce Query Complexity and Compilation Time

Lecture 9: Tip #58: Check for Cross Joins and Exploding Joins

Lecture 10: Tip #59: Process Only New or Updated Data

Lecture 11: Tip #60: Remote Spillage Optimization

Chapter 8: Serverless Features

Lecture 1: Introduction to Serverless Features

Lecture 2: Tip #61: Monitor the Cost of Automated Jobs

Lecture 3: Tip #62: Estimate Cost of Scheduled Tasks

Lecture 4: Tip #63: When to Use Serverless Tasks

Lecture 5: Tip #64: Replace Snowpipe with Snowpipe Streaming

Lecture 6: Tip #65: Estimate Cost of Automatic Clustering on Tables

Lecture 7: Tip #66: Estimate Cost of the Query Acceleration Service (QAS)

Lecture 8: Tip #67: Estimate Cost of the Search Optimization Service (SOS)

Lecture 9: Tip #68: Reduce Materialized Views Maintenance Cost

Lecture 10: Tip #69: Reduce Database Replication Cost

Lecture 11: Tip #70: Estimate Cost of Hybrid Tables

Chapter 9: Data Storage

Lecture 1: Introduction to Data Storage

Lecture 2: Tip #71: Use On-Demand Storage When You Don’t Know Your Spending Pattern

Instructors

Cristian Scutaru
Snowflake Guru, AWS/Azure/GCP Solutions Architect

Rating Distribution

1 stars: 0 votes
2 stars: 0 votes
3 stars: 1 votes
4 stars: 4 votes
5 stars: 10 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu