Programming in Snowflake Masterclass 2024 Hands-On!

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): i.e. many 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, and I served dozens of clients in this capacity or as an independent consultant.
• Today I continue to work with Snowflake, but I am no longer affiliated with their company in any capacity. I recently left their programs to keep my professional independence.

What You Will Learn

• How to access, expand and automate Snowflake through most if not ALL their existing APIs.
• How to build useful real-life tools and small apps with Snowflake APIs.
• How to ingest CSV and JSON data into Snowflake, through data pipelines and Snowpipe.
• How to write medium to complex data analytics queries for Snowflake.
• How to optimize queries, compute, storage and overall costs for Snowflake.
• How to process and render semi-structured and hierarchical data and metadata in Snowflake.
• I tried to cover almost EVERYTHING from Snowflake, only from a programming perspective.

What Snowflake APIs You Will Learn About

• SQL (DDL/DML/DCL) and Snowflake Scripting
• Stored Procedures, User-Defined Functions (UDFs), User-Defined Table Functions (UDTFs)
• Python Client, Snowpark for Python, Python Worksheets
• Streamlit Web Apps, Streamlit for Snowflake, Snowflake Native Apps Framework
• Secure Data Sharing and Data Clean Rooms
• Sharing with private Data Exchange or public Marketplace
• Snowflake SQL REST API and Snowpipe REST API
• Querying metadata from Account Usage and Information Schema
• I tried to cover indeed ALL possible APIs that Snowflake offers today!

What is NOT Included in This Course

• Data Science and Machine Learning APIs.
• Most external integrations, such as external functions, or Kafka and Spark connectors.
• Integrations with data transfer applications or other third-party partner apps.
• Client driver programming in Go, PHP, Java etc.
• Snowpark programming in Java or Scala.
• Main focus was on SQL and Python, with small extra snippets in JavaScript, C#, Java, Scala.

Real-Life Applications You Will Learn To Build

• CDC Data Pipelines with streams and tasks, or dynamic tables
• Generic hierarchical data viewer
• Hierarchical metadata viewer (for data lineage and object dependencies, role hierarchy, etc.)
• Enhanced query profile
• Script automation accessing the SQL REST API
• We’ll build all apps from scratch. We’ll use then Streamlit – for many of them – to create simple web apps, local or remote. We may deploy them into Snowflake, as Streamlit Apps. Or even share them with local partner accounts, as Native Apps.
• I sold tools similar to these to real-life clients and Snowflake partners!

No other course, book or documentation around – including those from Snowflake! – will offer as much insights, hands-on exercises and knowledge transfer as my course here, guaranteed!

Enroll today, to keep this course forever. And help me continue to update it with new APIs Snowflake comes frequently up with.