100 Snowflake Cost Optimization Techniques

Focused View

Cristian Scutaru

13:46:34

6 View

1 - Introduction

1 - Course Structure and Content.mp4

07:29

2 - Best Ways to Benefit from this Course.mp4

03:11

2 - GitHub Repository with all the source code from this course.txt

2 - My Medium Blog.txt

2 - Signup for a free Snowflake trial account.txt

2 - Snowflake-Cost-Optimization-All-Slides.pdf

3 - Create a Free Trial Snowflake Account.mp4

03:54

3 - Signup for a free Snowflake trial account.txt

4 - Free HandsOn Project Setup.mp4

08:27

4 - My Free GitHub Repository for this Course.txt

2 - Virtual Warehouses

5 - Introduction to Virtual Warehouses.mp4

01:39

6 - Tip 1 Larger Virtual Warehouses May Actually Cost You Less.mp4

12:50

6 - Top 10 Strategies for Snowflake Cost Optimization.txt

7 - Tip 2 AutoSuspend Any Warehouse After One Minute.mp4

08:16

8 - How to Start 192 Nodes in Snowflake for just 10.txt

8 - Tip 3 Any Resumed Warehouse Will Cost You at Least One Minute.mp4

08:48

9 - Tip 4 Never AutoSuspend Any Warehouse After Less Than One Minute.mp4

02:13

10 - Tip 5 XSmall Warehouses Could Be Powerful Enough.mp4

03:27

11 - 12 Misconceptions about Virtual Warehouses in Snowflake.txt

11 - Tip 6 Resized Warehouses are for More Complex Queries.mp4

03:13

12 - Tip 7 MultiCluster Warehouses are for Multiple Users and Concurrency.mp4

03:54

13 - Tip 8 MultiCluster Warehouses Should Always Have Min Clusters 1.mp4

01:54

14 - Tip 9 Use Economy Scaling Policy To Save Money.mp4

17:43

15 - Tip 10 When to Use SnowparkOptimized Warehouses.mp4

03:10

3 - Compute Workloads

16 - Introduction to Compute Workloads.mp4

02:34

17 - Tip 11 Use Resource Monitors.mp4

17:27

18 - Tip 12 Use AccountLevel Budgets.mp4

10:45

19 - Tip 13 Prevent NeverEnding Queries.mp4

06:46

20 - Tip 14 Manually Kill Running Queries.mp4

05:45

21 - Tip 15 Reduce Warehouse Sizes.mp4

03:44

22 - Is your warehouse half empty.txt

22 - Tip 16 Consolidate All Warehouses.mp4

20:08

23 - Tip 17 Use Parallel Jobs for Batch Transformations.mp4

09:58

24 - Tip 18 Avoid Checking Too Much on Metadata.mp4

12:33

25 - The Snowflake Usage Insights app.txt

25 - Tip 19 Charts for Warehouse Monitoring.mp4

09:48

26 - Tip 20 Revisit the Main Traps with Warehouses.mp4

16:02

4 - Snowflake Accounts

27 - Introduction to Snowflake Accounts.mp4

01:48

28 - Tip 21 What to Choose for a Free Trial Account.mp4

06:40

29 - How to Avoid Hidden Cost Traps in a Snowflake Test Account.txt

29 - Tip 22 When to Use a Free Trial Account.mp4

05:42

30 - Snowflake Pricing.txt

30 - Tip 23 Understand Price Tables for Virtual Warehouse Compute Services.mp4

09:05

31 - Tip 24 Understand Price Tables for Cloud and Serverless Services.mp4

07:20

32 - Tip 25 Understand Price Tables for Storage and Data Transfer.mp4

05:46

33 - Better Manage and Optimize Your Snowflake Spend In One Place With the New Cost Management Interface.txt

33 - Tip 26 Use the Account Overview Interface in Snowsight.mp4

06:06

34 - Tip 27 Use Organization Accounts.mp4

06:30

35 - Tip 28 Limit Warehouse Changes with Access Control.mp4

07:12

36 - Tip 29 Adjust Default Values of AccountLevel Parameters.mp4

05:18

37 - Tip 30 Careful with Reader Accounts.mp4

04:52

5 - Snowflake Editions

38 - Introduction to Snowflake Editions.mp4

01:24

39 - Tip 31 When to Choose Enterprise over Standard Edition.mp4

10:21

40 - Tip 32 How to Avoid MultiCluster Warehouses.mp4

10:07

41 - Tip 33 When to Use Incremental Materializations.mp4

03:59

42 - Tip 34 How to Emulate Materialized Views.mp4

07:20

43 - How to Use Time Travel in Snowflake the Right Way.txt

43 - Tip 35 The Case for Extended Time Travel.mp4

15:59

44 - Tip 36 Use Standard Edition Account for Analytics.mp4

06:13

45 - Tip 37 Use Separate Standard Edition Account for Common Queries.mp4

02:36

46 - Tip 38 How to Reduce Costs to Zero for an Inactive Paid Account.mp4

07:19

47 - Tip 39 When to Choose the Business Critical Edition.mp4

03:48

48 - Tip 40 When to Choose the Virtual Private Snowflake VPS Edition.mp4

03:22

6 - Query Monitoring

49 - Introduction to Query Monitoring.mp4

02:03

50 - Tip 41 Monitor Longest Running Queries.mp4

11:35

51 - Tip 42 Interpret Query History.mp4

10:05

52 - Tip 43 More Charts for Query Monitoring.mp4

06:08

53 - How to Quickly Visualize the Snowflake Role Hierarchy.txt

53 - Tip 44 Use Query Tags.mp4

09:19

54 - Pattern High frequency simple queries.txt

54 - Tip 45 Reduce Frequency of Simple Queries.mp4

04:34

55 - Pattern High frequency INFORMATIONSCHEMA queries.txt

55 - Tip 46 Reduce Frequency of Metadata Queries.mp4

05:20

56 - How to Quickly Visualize the Snowflake Role Hierarchy.txt

56 - How to Reverse Engineer a Snowflake Database Schema.txt

56 - Pattern High frequency SHOW commands by data apps and thirdparty tools.txt

56 - Tip 47 Reduce Frequency of SHOW Commands.mp4

10:13

57 - Pattern High frequency DDL operations and cloning.txt

57 - Tip 48 Clone Less Frequently.mp4

03:15

58 - How top companies save millions in Snowflake costs.txt

58 - Tip 49 Change Query Schedules.mp4

10:56

59 - Tip 50 Parallel over Sequential Transfer and Processing.mp4

11:01

7 - Query Optimization

60 - Introduction to Query Optimization.mp4

02:40

61 - How to Make Your Own Snowflake Query Profile.txt

61 - Tip 51 Use the Query Profile.mp4

13:35

62 - Tip 52 Use the Explain Statement.mp4

09:57

62 - Understanding the Exploding Joins Problem in Snowflake.txt

63 - Tip 53 Use Data Caching.mp4

11:18

64 - Tip 54 Queries on Data Lakes.mp4

09:00

65 - Tip 55 Use Vectorized Python UDFs.mp4

06:25

66 - How To Resolve blocked queries.txt

66 - Pattern Blocked queries due to transaction locks.txt

66 - Tip 56 Use Batch Commands to Prevent Transaction Locks.mp4

04:43

67 - Pattern Complex SQL queries.txt

67 - Tip 57 Reduce Query Complexity and Compilation Time.mp4

08:02

68 - Tip 58 Check for Cross Joins and Exploding Joins.mp4

09:16

68 - Understanding the Exploding Joins Problem in Snowflake.txt

69 - Tip 59 Process Only New or Updated Data.mp4

04:14

70 - Snowflake Spilling to Storage in Plain English.txt

70 - Tip 60 Remote Spillage Optimization.mp4

14:13

8 - Serverless Features

71 - Introduction to Serverless Features.mp4

01:56

72 - Tip 61 Monitor the Cost of Automated Jobs.mp4

13:52

73 - How to Make Your Own Snowflake Task Graph Viewer.txt

73 - How to Visualize a Snowflake Task Graph Run.txt

73 - Tip 62 Estimate Cost of Scheduled Tasks.mp4

11:25

74 - Tip 63 When to Use Serverless Tasks.mp4

10:29

75 - Best Practices for Data Ingestion with Snowflake Part 3.txt

75 - Tip 64 Replace Snowpipe with Snowpipe Streaming.mp4

03:02

76 - Tip 65 Estimate Cost of Automatic Clustering on Tables.mp4

05:46

77 - How you can use the Snowflake QAS to balance price and performance.txt

77 - Tip 66 Estimate Cost of the Query Acceleration Service QAS.mp4

12:56

78 - Tip 67 Estimate Cost of the Search Optimization Service SOS.mp4

08:59

79 - Tip 68 Reduce Materialized Views Maintenance Cost.mp4

06:06

80 - Tip 69 Reduce Database Replication Cost.mp4

08:56

81 - All about the new Snowflake Hybrid Tables.txt

81 - Tip 70 Estimate Cost of Hybrid Tables.mp4

10:58

9 - Data Storage

82 - Introduction to Data Storage.mp4

01:57

83 - Tip 71 Use OnDemand Storage When You Dont Know Your Spending Pattern.mp4

06:42

84 - Tip 72 Copy and Keep Less Data.mp4

08:15

85 - How to Use Time Travel in Snowflake the Right Way.txt

85 - Tip 73 Lower Data Retention with No Time Travel.mp4

02:36

86 - Tip 74 Estimate Storage Cost of the FailSafe.mp4

03:57

87 - Tip 75 Use Transient or Temporary Tables.mp4

09:05

88 - Tip 76 Use ZeroCopy Cloning.mp4

07:46

88 - ZeroCopy Cloning in Snowflake and Other Database Systems.txt

89 - Pattern High frequency DDL operations and cloning.txt

89 - Tip 77 Clone Less Data.mp4

01:29

90 - Tip 78 Ensure Tables Are Clustered Correctly.mp4

17:47

91 - Identifying unused tables in Snowflake.txt

91 - Tip 79 Drop Unused Tables and Other Objects.mp4

18:19

92 - How to Avoid Hidden Cost Traps in a Snowflake Test Account.txt

92 - How to list how much storage is consumed by Snowflake stages.txt

92 - Tip 80 Remove Old Files from Stage Areas.mp4

05:16

10 - Data Transfer

93 - Introduction to Data Transfer.mp4

01:43

94 - Tip 81 Data In is Free Data Out is Expensive.mp4

19:27

95 - Tip 82 Choose the same Provider and Region Where Your Data Is.mp4

05:20

96 - Tip 83 External Access Integrations vs External Functions.mp4

05:08

97 - How to Load Terabytes Into Snowflake Speeds Feeds and Techniques.txt

97 - Tip 84 Use Data Compression.mp4

03:33

98 - Pattern Copy commands with poor selectivity.txt

98 - Tip 85 Use Batch Transfer with Path Partitioning.mp4

01:40

99 - Pattern Single row inserts and fragmented schemas by data apps.txt

99 - Tip 86 Use Bulk Loads instead of SingleRow Inserts.mp4

05:56

100 - Tip 87 Use Parallel Data Uploading.mp4

03:00

101 - Snowflake Cost Intelligence Optimization Part 1.txt

101 - Tip 88 Design CostEffective Data Pipelines.mp4

01:49

102 - Tip 89 Use External Tables in a Data Lake.mp4

05:01

103 - Difference Between Parquet and CSV.txt

103 - Tip 90 Query Parquet Files instead of CSV.mp4

03:09

11 - Snowflake Apps

104 - Introduction to Snowflake Apps.mp4

03:06

105 - Demystifying Data Sharing in Snowflake.txt

105 - Tip 91 Estimate Cost Impact of Data Sharing in Snowflake.mp4

10:42

106 - How to Generate Snowflake Stored Procs via Python Worksheets.txt

106 - Snowpark API The Object Model.txt

106 - Tip 92 Estimate Cost Impact of Client and Server Snowpark Applications.mp4

10:14

107 - Streamlit Hierarchical Data Viewer in Snowflake.txt

107 - Tip 93 Estimate Cost Impact of Streamlit in Snowflake and Native Applications.mp4

14:04

107 - Understanding the cost of running an APP on Streamlit In Snowflake.txt

108 - Tip 94 Estimate Cost Impact of Data Science Applications.mp4

03:18

109 - Tip 95 Check All Connected Applications.mp4

02:37

110 - Tip 96 ThirdParty Apps Saving Money Will Spend Money.mp4

01:34

111 - Tip 97 Free Marketplace Native Apps Will Cost Money.mp4

09:32

112 - Tip 98 Keep App Versions Updated.mp4

05:06

113 - Tip 99 Cache Data in ThirdParty Tools.mp4

02:11

114 - Tip 100 AutoAbort Running Queries from Disconnected Apps.mp4

07:19

12 - Wrapping Up

115 - Congratulations You Made It.mp4

01:14

116 - Bonus Lecture.html

Description

by World-Class Snowflake Expert, former Data Superhero and SnowPro Certification SME

What You'll 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 is this for?

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 Need to Know?

Basic knowledge of the Snowflake Data Cloud

Basic knowledge of SQL

Optional knowledge of some basic programming in Python

More details

Description
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!
Who this course is for:
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

User Reviews

Rating

average 0

Total votes0

Focused display

Certified Solutions Architect in AWS/Azure/Google Cloud (20 total exams). Former Snowflake “Data Superhero” and SnowPro Certification SME. Certified in many NoSQL stores: Cassandra/Redis/Couchbase/Neo4j/TigerGraph...Decades of practical experience in software design and implementation. Former Microsoft employee. Architect of the Data Xtractor Suite - with a visual SQL editor, data visualization charts, data modeling... Former assistant professor at the "Polytechnica" University of Bucharest.I live in beautiful Vancouver/Canada.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.