Major Snowflake Pitfalls You Should Learn About

Traps you should be aware of and things you may struggle to understand properly when learning about Snowflake

What you'll learn

Confusing concepts about Snowflake

Why Snowflake implemented some features in a certain way

Traps you should learn to avoid when using Snowflake

Some difficult areas you may struggle to understand

Uncommon ways SQL itself evolved and Snowflake had to support it

Many other things nobody else will tell you about

Requirements

Optional basic knowledge of Snowflake

Basic SQL programming knowledge

Some basic Python or JavaScript programming skills

Description

If you already know Snowflake, you may not be aware of many traps I'll talk about in this original course. You cannot become an expert in Snowflake unless you learn about them. If you do not know Snowflake yet, here are some things you may struggle to properly understand.This course will focus mostly on pitfalls. For in-depth knowledge of Snowflake, I'll leave pointers and references to other better sources. Most lectures will not have the typical hands-on experiments you will encounter in my other specialized  courses. The minimal requirements are some basic SQL and Python programming skills.What will be very valuable here to you is that I'll share my years of experience with Snowflake, to make you aware of pitfalls nobody else may tell you about. I learned about them the hard way. Avoid doing the same.CredentialsThe only world-class expert from Canada selected for the Snowflake Data Superhero program in 2021.SnowPro Certification SME (Subject Matter Expert): i.e. dozens of exam questions have been created by me.I passed five SnowPro certification exams, all from the first attempt: Core, Architect, Engineer, Analyst, Scientist.Highly specialized in Snowflake for the past few years, as a Data and Solutions Architect in AWS, Azure and GCP.I served dozens of clients working for Snowflake Partner companies or as an independent consultant.Enroll today, to keep this course forever!

Overview

Section 1: Introduction

Lecture 1 Course Structure and Content

Lecture 2 How to Benefit Most from this Course

Lecture 3 Frequently Asked Questions

Section 2: Snowflake Accounts

Lecture 4 Introduction to Snowflake Accounts

Lecture 5 Getting Started

Lecture 6 Choosing the Right Edition

Lecture 7 How Snowflake Makes Money

Lecture 8 Shared Configurations

Lecture 9 From Simple to Complex

Section 3: Snowflake Compute

Lecture 10 Introduction to Snowflake Compute

Lecture 11 Idle Warehouses

Lecture 12 Suspending Warehouses

Lecture 13 Stuck Queries

Lecture 14 Larger Warehouses

Lecture 15 Multi-Cluster Warehouses

Lecture 16 Managed vs Serverless Tasks

Section 4: Snowflake Data

Lecture 17 Introduction to Snowflake Data

Lecture 18 Data Transfer

Lecture 19 Querying Table Data

Lecture 20 Querying Data Lake Files

Lecture 21 Time Travel & Fail-safe

Lecture 22 Cloning Data

Lecture 23 Sharing Data

Section 5: Snowflake Workloads

Lecture 24 Introduction to Snowflake Workloads

Lecture 25 Hybrid Tables

Lecture 26 Table Constraints

Lecture 27 Clustering Keys

Lecture 28 Data Lakes

Section 6: Snowflake Pipelines

Lecture 29 Introduction to Snowflake Pipelines

Lecture 30 Data Ingestion & Integration

Lecture 31 Batch vs Streaming

Lecture 32 Change Data Capture in Snowflake

Lecture 33 CI/CD Pipelines

Lecture 34 ML Pipelines

Section 7: Snowflake SQL

Lecture 35 Introduction to Snowflake SQL

Lecture 36 Legacy vs Modern SQL

Lecture 37 Snowflake Scripting

Lecture 38 Useless Error Messages

Lecture 39 TABLE Keyword

Lecture 40 LATERAL Keyword

Lecture 41 FLATTEN Function

Section 8: Snowflake APIs

Lecture 42 Introduction to Snowflake APIs

Lecture 43 Procedures and Functions

Lecture 44 REST APIs

Lecture 45 Pandas

Lecture 46 Snowpark

Lecture 47 Streamlit

Section 9: Snowflake Cortex

Lecture 48 Introduction to Snowflake Cortex

Lecture 49 Snowpark vs Snowpark ML

Lecture 50 Classes in SQL

Lecture 51 ML Time Series Functions

Lecture 52 LLM Functions & Integrations

Section 10: Snowflake Programs

Lecture 53 Introduction to Snowflake Programs

Lecture 54 SnowPro Certifications

Lecture 55 Too Many "Experts"

Lecture 56 Bad Customer Support

Lecture 57 Too Much Information

Section 11: Wrapping Up

Lecture 58 Congratulations, You Made It!

Lecture 59 Bonus Lecture

Those who already know Snowflake, but need to find more,Beginners in Snowflake, willing to be aware of hidden traps before learning more