Data Engineering SimplifiedIn this video, youβll learn why Task-Specific AI functions in Snowflake Cortex are important and how to use them correctly for real-world scenarios and certification exams.
We cover key functions like AI Classify, AI Extract, AI Summarize, and AI Translate, explaining their purpose, input parameters, limitations, and when to use each one. Youβll also see practical examples that help you avoid common mistakes in scenario-based questions.
This video is ideal for anyone preparing for the Snowflake GenAI Certification, data engineers, and AI learners who want a simple and clear understanding of Cortex AI functions.
π Watch till the end to boost your exam confidence and decision-making skills.
Task-Specific AI SQL You Must Know for the Exam | Pass the Snowflake GenAI Certification FasterData Engineering Simplified2026-01-29 | In this video, youβll learn why Task-Specific AI functions in Snowflake Cortex are important and how to use them correctly for real-world scenarios and certification exams.
We cover key functions like AI Classify, AI Extract, AI Summarize, and AI Translate, explaining their purpose, input parameters, limitations, and when to use each one. Youβll also see practical examples that help you avoid common mistakes in scenario-based questions.
This video is ideal for anyone preparing for the Snowflake GenAI Certification, data engineers, and AI learners who want a simple and clear understanding of Cortex AI functions.
π Watch till the end to boost your exam confidence and decision-making skills.
#Snowflake #SnowflakeCortex #SnowflakeAI #SnowflakeGenAICertification #dataengineering #IntelligentDocumentProcessingSnowflake Bring Your Own Model (BYOM) Explained | MCQs & Scenarios | Crack SnowPro GenAI GES-C01Data Engineering Simplified2026-02-12 | In this video, youβll learn how Bring Your Own Model (BYOM) works in Snowflake and how external models from Hugging Face can be deployed using Snowpark Container Services.
We break down: β’ How to import a Hugging Face model into Snowflake β’ What truly makes a model βdeployedβ β’ Where models are registered (Snowflake Model Registry) β’ What compute is actually required (Compute Pool with GPU support) β’ Common certification-style MCQs and tricky scenario-based questions
Youβll also clearly understand the difference between deployment, registration, and execution β because these are not the same thing, and confusing them is where most candidates lose marks.
If youβre preparing for the Snowflake GenAI Certification (GES-C01), this topic falls under Domain-1 (Principles & Architecture) and is frequently tested through awareness-level and scenario-based questions.
This is a complete hands-on walkthrough using Snowflake Cortex UI, model import from Hugging Face, and deployment via Snowpark Container Services β exactly within the scope of the certification exam.
If you want to confidently answer BYOM-related questions without memorizing documentation, this video is for you.
#Snowflake #SnowflakeCortex #SnowflakeAI #SnowflakeGenAICertification #dataengineering #IntelligentDocumentProcessingSnowflake Cortex Playground Explained | MCQs, Syntax & Scenarios | Crack SnowPro GenAI GES-C01 ExamData Engineering Simplified2026-02-10 | If youβre preparing for the Snowflake GenAI Certification, you cannot afford to ignore Snowflake Cortex Playground.
In this complete hands-on walkthrough, we explore:
β’ How Cortex Playground supports experimentation with enterprise data β’ Why it is important in the GenAI lifecycle β’ How to compare LLM models side-by-side β’ REST API vs SQL API access differences β’ How to use Connect Your Data β’ How Snowflake Cortex Complete works behind the UI β’ What SQL is generated when you submit a prompt β’ Fine-tuned vs foundation model testing β’ Exam-style questions and correct answers
#Snowflake #SnowflakeCortex #SnowflakeAI #SnowflakeGenAICertification #dataengineering #IntelligentDocumentProcessingEmbedding & Vector Function Deep Dive | MCQs, Syntax & Scenarios | Crack SnowPro GenAI GES-C01 ExamData Engineering Simplified2026-02-05 | In this video, youβll learn how embedding and vector similarity functions work in Snowflake Cloud Data Platform. We explore how text and images are converted into vector representations, how similarity is measured, and how these concepts apply to semantic search and RAG-based systems.
Youβll also understand how to choose the right embedding type and similarity function for different use cases β especially in certification-style scenarios.
If youβre preparing for the Snowflake GenAI Certification (GES-C01) and want to confidently handle scenario-based questions from Domain-1 & Domain-3, this video is exactly what you need.
#Snowflake #SnowflakeCortex #SnowflakeAI #SnowflakeGenAICertification #dataengineering #IntelligentDocumentProcessingAI-SQL HELPER FUNCTIONS Deep Dive | MCQs, Syntax & Scenarios | Crack SnowPro GenAI GES-C01 ExamData Engineering Simplified2026-02-03 | In this short and focused session, youβll learn how Snowflakeβs AI-SQL Helper functions β all explained visually with real examples (and exam tips) so you donβt have to memorize documentation.
This topic (AI SQL Functions in Snowflake) carries significant exam weightage and often appears in combined and tricky MCQs, where understanding behavior and purpose matters more than syntax. By watching this video, youβll clearly understand how these helper features fit into real-world workflows and how to quickly identify the correct choice during the exam.
If youβre preparing for the Snowflake GenAI Certification (GES-C01) and want to confidently handle scenario-based questions from Domain-2, this video is exactly what you need.
#Snowflake #SnowflakeCortex #SnowflakeAI #SnowflakeGenAICertification #dataengineering #IntelligentDocumentProcessingPARSE_DOCUMENT Deep Dive | MCQs, Syntax & Scenarios | Crack SnowPro GenAI GES-C01 ExamData Engineering Simplified2026-01-27 | In this video, youβll learn everything you need to know about the PARSE_DOCUMENT and AI_PARSE_DOCUMENT Cortex functions for the Snowflake GenAI Certification Exam (GES-C01) Domain-2.
This video covers how to extract text and layout from documents stored in Snowflake stages, understand the return data types, JSON output structure, and key fields like content, metadata, pages, and error information. Youβll also learn the difference between OCR mode and Layout mode, when to use each one in exam scenarios, and how to use important options such as page_split and page_filter.
This tutorial also covers: - Syntax differences between PARSE_DOCUMENT and AI_PARSE_DOCUMENT - How file paths and case sensitivity affect execution - Handling multi-page and complex documents - Common mistakes and exam-oriented MCQ tips
If you are preparing for the Snowflake GenAI (GES-C01) certification, this video will help you confidently answer scenario-based and syntax-based questions.
#Snowflake #SnowflakeCortex #SnowflakeAI #SnowflakeGenAICertification #dataengineering #IntelligentDocumentProcessingStructured Output & JSON Schema Traps | SnowPro GenAI Exam | Domain 2 (40%)Data Engineering Simplified2026-01-15 | Unlock deterministic responses in your AI pipelines with Cortex Structured Output. This tutorial is a deep dive into Domain 2 (GenAI & LLM Functions) of the Snowflake SnowPro Specialty: GenAI (GES-C01) certification exam, which carries a massive 40% weightage.
Learn how to force your Large Language Models (LLMs) to conform to a specific JSON schema, ensuring your downstream applications never fail due to inconsistent data. We compare the implementation across both COMPLETE and AI_COMPLETE and look at the real-world error messages you might face during development.
What you will learn in this video: 1. SQL Construct: How to use the response_format key within the options object. 2. JSON Schema Implementation: Defining properties, data types (string, object), and mandatory "required" fields. 3. The Error Trap: Why setting a low max_tokens (like 20) can trigger a JSON output validation error. 4. Accuracy vs. Complexity: Why Snowflake recommends explicit "Provide output in JSON" instructions in your prompt for complex tasks.
#Snowflake #SnowflakeCortex #CortexGuardrails #SnowflakeAI #SnowflakeCertification #DataEngineering #AIinData #SnowflakeSQL #Governance #CloudData #LLM #DataPlatformCOMPLETE Cortex Function + AI_COMPLETE() Deep Dive Tutorials | SnowPro GenAI Exam | Domain 2 (40%)Data Engineering Simplified2026-01-13 | Unlock the power of the Cortex COMPLETE and the new AI_COMPLETE functions in this deep-dive tutorial. This video is specifically designed for Domain 2 (GenAI & LLM Functions) of the Snowflake SnowPro Specialty: GenAI (GES-C01) exam.
We go beyond the basics to explain the differences between the legacy and modern versions, exploring exactly how model choice affects cost, speed, and accuracy.
#Snowflake #SnowflakeCortex #CortexGuardrails #SnowflakeAI #SnowflakeCertification #DataEngineering #AIinData #SnowflakeSQL #Governance #CloudData #LLM #DataPlatformSnowflake Cortex Guardrails | SnowPro GenAI Exam | Domain 2 & 3 (40% + 22%)Data Engineering Simplified2026-01-12 | Snowflake Cortex Guardrails looks simple, but there are important topic for Snowflake SnowPro GenAI Speciality exam as you need to understand before using it.
In this video, we walk through how Guardrails works when it comes to Snowflake Cortex functions, how it behaves in real queries, and what to watch out for β especially for certification preparation.
This is a very important topic from the Governance area (Domain 3), and you will almost certainly see one or two questions in the exam. It also connects to Domain 2 for general-purpose functions, so donβt skip this topic.
#Snowflake #SnowflakeCortex #CortexGuardrails #SnowflakeAI #SnowflakeCertification #DataEngineering #AIinData #SnowflakeSQL #Governance #CloudData #LLM #DataPlatformAI Sentiment, Entities & Syntax Traps | SnowPro GenAI Exam | Domain 2 (40%)Data Engineering Simplified2026-01-09 | This video is a comprehensive tutorial on the Cortex AI Sentiment function, a core part of Domain 2 (LLM Functions & AI SQL) for the Snowflake SnowPro Specialty: GenAI (GES-C01) exam.
While simple on the surface, the sentiment function has multiple distinct versions and several hidden limitations that Snowflake frequently tests. We move beyond the basic documentation to show you exactly how these functions behave in real-world scenarios and where candidates usually lose points.
What you will learn (that the docs don't emphasize): - The multiple variants of sentiment functions. - Hard Limits - Syntax Traps - Language Support
#snowflakecertification #genai #dataengineering #snowflake #cortexAI #snowflakegovernanceHow Cortex Analyst Charges: LLM vs. Virtual Warehouse | SnowPro GenAI Exam | Domain 3 (22%)Data Engineering Simplified2026-01-08 | This video provides a technical deep dive into Cortex Analyst Cost Monitoring, a critical sub-topic of Domain 3 (Governance) for the Snowflake SnowPro Specialty: GenAI (GES-C01) certification exam.
While the official syllabus provides general guidelines on tracking consumption, it doesn't explicitly detail the "dual-cost" nature of Cortex Analyst. In this video, we break down the conceptual and practical knowledge you need to handle tricky exam questions regarding service charges.
What you will learn in this tutorial: The Dual-Cost Component: Why Cortex Analyst charges for both the LLM "Text-to-SQL" conversion and the actual SQL execution via your Virtual Warehouse.
Disclaimer: All Snowflake-related learning materials and tutorial videos published on this channel reflect the personal opinions of the Data Engineering Simplified team and are neither authorized by nor associated with Snowflake, Inc.Monitoring Model Credits Using CORTEX_FUNCTIONS_USAGE | SnowPro GenAI Exam | Domain 3 (22%)Data Engineering Simplified2026-01-07 | This video is a critical continuation of our Domain 3 (Governance) series for the Snowflake SnowPro Specialty: GenAI (GES-C01) exam.
A common point of confusion for many students is why their Snowflake accounts show empty data for CORTEX_FUNCTIONS_USAGE_HISTORY & CORTEX_FUNCTIONS_QUERY_USAGE_HISTORY. In this deep dive, we compare the Legacy views found in many study materials against the New consolidated views you will see in your 2026 Snowflake instances.
We look at an older Snowflake instance to see what CORTEX_FUNCTIONS_USAGE_HISTORY actually tracks, including its 1-hour aggregation increments.
Disclaimer: All Snowflake-related learning materials and tutorial videos published on this channel reflect the personal opinions of the Data Engineering Simplified team and are neither authorized by nor associated with Snowflake, Inc.Tracking Cortex Usage & Cost Monitoring | SnowPro GenAI Exam | Domain 3 (22%)Data Engineering Simplified2026-01-06 | This video is a deep dive into the Usage and Consumption tracking part of Domain 3 (Governance) for the Snowflake SnowPro Specialty: GenAI (GES-C01) certification exam.
Domain 3 carries ~22% weightage. In this specific sub-topic, Snowflake tests your ability to monitor how much your AI models are actually costing you in terms of credits and tokens. While the syllabus mentions older views, the platform has recently consolidated everything into a single, high-performance view.
Many candidates struggle with this section because: The syllabus lists CORTEX_FUNCTION_USAGE_HISTORY and QUERY_USAGE_HISTORY, but these are no longer updated. Snowflake is moving towards the consolidated AI_SQL_USAGE_HISTORY view. One single query can generate multiple rows in the usage history (e.g., when using Guardrails).
Exam questions are moving toward conceptual usage tracking rather than just memorizing view names.
What youβll learn in this 10-minute deep dive: - How to find the consolidated AI SQL usage history in the account usage schema. - Understanding key columns: Query Tag, Warehouse ID, and Granular Token counts. - The difference in tracking for Purpose-built functions (Sentiment, Classify) vs. General functions (Complete).
Exam Trap: How a single query ID can appear multiple times for one LLM call.
Disclaimer: All Snowflake-related learning materials and tutorial videos published on this channel reflect the personal opinions of the Data Engineering Simplified team and are neither authorized by nor associated with Snowflake, Inc.Snowflake SnowPro GenAI Exam | Domain 4 (12%) β Document AI Setup, Privileges & Cost TrapsData Engineering Simplified2025-12-24 | This video is a focused deep dive into Domain 4 (Document AI) of the Snowflake SnowPro Speciality: GenAI (GES-C01) certification exam.
Although Domain-4 contributes only ~12% of the total exam weightage, it is one of the most predictable and scoring domains β if you understand how Snowflake enforces setup, privileges, and governance for Document AI.
Many candidates lose marks in Domain-4 not because the domain is hard, but because they assume Document AI works like other Snowflake features. This video is designed to eliminate those assumptions.
In this video, youβll learn: β’ How Snowflake Document AI differs from Cortex LLM & AI SQL features β’ Why Document AI is an opt-in capability and not enabled by default β’ Required roles and privileges for creating Document AI model builds β’ Common setup failure scenarios Snowflake loves to test in the exam β’ How to prepare documents for Document AI (formats, size, page limits) β’ Troubleshooting Document AI errors in exam-style scenarios β’ Sample-style exam questions and Domain-4 specific traps
This domain is small, practical, and extremely logical. If you perform one hands-on run, you wonβt need to memorize anything β youβll be able to eliminate wrong answers instantly during the exam.
Disclaimer: All Snowflake-related learning materials and tutorial videos published on this channel reflect the personal opinions of the Data Engineering Simplified team and are neither authorized by nor associated with Snowflake, Inc.Snowflake SnowPro GenAI | Domain 3 (22%) β What to Study & Exam QuestionsData Engineering Simplified2025-12-23 | This video is a complete deep dive into Domain 3 (Snowflake GenAI Governance) of the Snowflake SnowPro Speciality: GenAI (GES-C01) certification exam.
Domain-3 carries ~22% weightage, which translates to 8β12 questions in the real exam. These questions are not standalone β Snowflake intentionally mixes governance concepts with Domain-1 architecture and Domain-2 AI SQL functions, making this one of the most confusing and high-risk domains.
Many candidates fail Domain-3 not because the concepts are difficult, but because: β’ access control is tested at multiple layers β’ RBAC, account parameters, and application roles are mixed β’ cost and usage views look similar β’ observability questions are screenshot-based and theoretical
ππ Video Chapters ----------------------------------- 00:00 β Introduction 01:21 β What Youβll Learn in Domain-3 01:39 β What Domain-2 Is Really Testing 02:15 β Important Note 02:47 β How to Study Domain-3 03:07 β Section 3.1: Setup & Access Control 05:53 β Section 3.2: Guardrail & Unsafe Response 07:00 β Section 3.3: Monitoring & Cost 08:40 β Section: 3.4 AI Observability 09:36 β Smartest way to learn domain-3 10:16 β Sample Questions & Exam Traps 13:00 β Closing Notes 13:30 β Thank You
#snowflakecertification #genai #dataengineering
Disclaimer: All Snowflake-related learning materials and tutorial videos published on this channel reflect the personal opinions of the Data Engineering Simplified team and are neither authorized by nor associated with Snowflake, Inc.Snowflake SnowPro GenAI Exam | Domain 2 (40%) β Pass or Fail Zone (LLM & AI SQL)Data Engineering Simplified2025-12-22 | This video is a deep dive into Domain 2 (Snowflake GenAI & LLM Functions) of the Snowflake SnowPro Speciality: GenAI (GES-C01) certification exam, which contributes ~40% of the total exam weightage β making it the single most important scoring domain in the exam.
Domain-2 is where most candidates struggle, not because they donβt know the functions, but because they choose the wrong GenAI capability for a given scenario. This video is designed to help you avoid exactly those mistakes.
In this video, youβll learn: ---------------------------------------- β’ Why Domain-2 is critical for passing the Snowflake GenAI exam β’ How to study Domain-2 in the right sequence without getting confused β’ Where hands-on is mandatory vs where theory is sufficient β’ General-purpose vs task-specific Cortex LLM / AI SQL functions β’ COMPLETE vs TRY_COMPLETE and pipeline-safe design choices β’ Helper functions like PARSE_DOCUMENT, SPLIT_TEXT_RECURSIVE, AI_EMBED β’ Vector functions (cosine similarity, L1, L2) and how they appear in exam scenarios β’ Structured vs unstructured data analysis use cases β’ Building chat interfaces and using GenAI in data pipelines β’ Running third-party models using Snowpark Container Services β’ Sample-style exam questions and the most common Domain-2 traps
00:00 β Introduction 00:35 β What Youβll learn in domain-2 00:52 β What Domain-2 Is Really Testing 02:16 β Important note 02:42 β How to Study Domain-2 (Right Sequence) 03:20 β Section 2.1: LLM & AI SQL Functions 05:16 β Section 2.2: Data Analysis (Structured vs Unstructured) 06:33 β Section 2.3: Chat Interface & Conversation History 07:10 β Section 2.4: Cortex Data Pipeline 07:45 β Section 2.5: 3rd Party Model 08:29 β Sample Questions & Exam Traps 11:40 β Closing Notes & Next Steps 12:05 β Thank You
#snowflakecertification #genai #dataengineering
Disclaimer: All Snowflake-related learning materials and tutorial videos published on this channel reflect the personal opinions of the Data Engineering Simplified team and are neither authorized by nor associated with Snowflake, Inc.Snowflake SnowPro GenAI Exam | Domain 1 (26%) β Architectural & Conceptual TrapsData Engineering Simplified2025-12-16 | Snowflake SnowPro Speciality: GenAI β Domain 1 (Snowflake for GenAI Overview)
This video is a deep dive into Domain 1 (Snowflake For GenAI Overview) of the Snowflake SnowPro Speciality: GenAI (GES-C01) certification exam, which contributes ~26% of the total exam weightage.
In this video, youβll learn: β’ Why Domain 1 is critical for passing the GenAI exam β’ How Snowflake expects you to think as a GenAI engineer β’ How to study Domain 1 in the right sequence β’ How Snowflake maps structured vs unstructured GenAI use cases β’ Cortex LLM Functions vs Analyst vs Search vs Agents β’ Interfaces: SQL, Cortex Playground, REST APIs β’ Security concepts: RBAC, model allowlist, guardrails β’ Cross-region inference, opt-in/opt-out features β’ Sample-style exam questions and the most common traps candidates fall into
ππ Video Chapters 00:00 β Introduction 00:24 β What Will You Learn 01:13 β Why Domain-1 Matters 01:52 β How To Study Domain-1 02:33 β Cortex Feature Classification 03:02 β Snowflake Cortex LLM Function (General vs Purpose Build) 04:45 β Snowflake Cortex Analyst 05:23 β Snowflake Cortex Search 05:56 β Snowflake Cortex Agents 06:26 β Snowflake Interface for Cortex 06:55 β Snowflake Cortex Security & RBAC 07:30 β Cross Region Inferences 08:31 β Sample Questions & Exam Traps 13:03 β Closing Note 13:32 β Thank You
#snowflakecertification #genai #dataengineering
Disclaimer: All snowflake-related learning materials and tutorial videos published in this channel are the personal opinions of the data engineering simplified team and they're neither authorized by nor associated with Snowflake, Inc.Snowflake SnowPro GenAI Exam | 10-Day Prep Guide (What to Study & What to Skip)Data Engineering Simplified2025-11-27 | Preparing for the Snowflake SnowPro Speciality: GenAI (GES-C01) certification exam? This video explains how the exam is structured, what Snowflake actually tests across domains, and how to prepare using a focused 10-day study plan based on real exam patterns and common candidate mistakes.
β οΈ This is NOT a Snowflake basics tutorial. It is a certification-focused strategy guide covering only the GenAI topics that appear in the exam β including Cortex features, LLM & AISQL functions, vector search, Document AI, governance, and security concepts.
Disclaimer: All snowflake-related learning materials and tutorial videos published in this channel are the personal opinions of the data engineering simplified team and they're neither authorized by nor associated with Snowflake, Inc.Configuring SnowSQL On Windows Machine | Ch-03Data Engineering Simplified2025-05-13 | In Chapter 03 of the SnowSQL Master Class Playlist, learn how to locate the configuration file on a Windows machine and use it to define connection parameters for both default and named connections to Snowflake. This setup enables seamless access to multiple environmentsβdev, QA, and production. The hands-on session also covers best practices and the risks of storing passwords in plain text. A must-watch for all Data Engineers and Snowflake DBAs aiming for secure and efficient CLI usage.
Disclaimer: All snowflake-related learning materials and tutorial videos published in this channel are the personal opinions of the data engineering simplified team and they're neither authorized by nor associated with Snowflake, Inc.Install SnowSQL In Windows System | Complete Hands-on Guide | Ch-02Data Engineering Simplified2025-05-06 | Welcome to the SnowSQL Client Master Class, chapter-02, "Snowflake SnowSQL Installation On Windows OS". This video will walk you through everything you needβfrom downloading SnowSQL and verifying the installation, to connecting with command-line parameters. Weβll also cover how to troubleshoot common login and access errors, and how to check the login audit table in Snowflake for deeper insights. Whether youβre a beginner or need a quick refresher, this step-by-step guide will help you get up and running with SnowSQL confidently.
This youtube playlist is perfect for data engineers, snowflake-DBAs, and snowflake data professionals eager to make the most out of Snowflakeβs SnowSQL Client tools.
Disclaimer: All snowflake-related learning materials and tutorial videos published in this channel are the personal opinions of the data engineering simplified team and they're neither authorized by nor associated with Snowflake, Inc.Snowflake SnowSQL Full Course | Beginner to Expert Step-by-Step GuideData Engineering Simplified2025-05-01 | Welcome to the SnowSQL Client Master Class!
In this hands-on series (playlist), youβll explore everything about Snowflakeβs command-line client (so called SnowSQL Client)β from setting up your first connection to mastering all the configuration and automation for productivity.
Whether youβre a complete beginner or looking to strengthen your SnowSQL skills, this course offers step-by-step explanations, real-world automation scenario, and tips to become more efficient.
Youβll learn how to install, configure, query, manage data, and optimize repetitive task using SnowSQL with confidence.
This youtube playlist is perfect for data engineers, snowflake-DBAs, and snowflake data professionals eager to make the most out of Snowflakeβs SnowSQL Client tools.
Disclaimer: All snowflake-related learning materials and tutorial videos published in this channel are the personal opinions of the data engineering simplified team and they're neither authorized by nor associated with Snowflake, Inc.Snowflake Secrets: Import Excel Files Without CSV HasslesData Engineering Simplified2025-04-29 | Excel is everywhereβand if youβre struggling to load Excel files into Snowflake tables directly and spending hours doing it manually, youβre not alone.
In this video, Iβll show you exactly how to automate loading Excel data directly into a Snowflake table from your stage location, whether the file is small or large.
This simple approach can save you tons of data ingestion time and reduce data errors, making your workflows faster, cleaner, and much more reliable. Whether youβre working on small projects or enterprise-level pipelines, this tutorial will give you a solid foundation to level up your data engineering skills!
Disclaimer: All snowflake-related learning materials and tutorial videos published in this channel are the personal opinions of the data engineering simplified team and they're neither authorized by nor associated with Snowflake, Inc.Complete Guide On Snowflake Metrics - Observability Feature In SnowflakeData Engineering Simplified2025-01-14 | Discover everything you need to know about Metrics, a great observability feature, added into the Snowflake toolkit. This comprehensive hands on guide will teach you how to enable the metrics in snowflake for your functions and stored procedures.
This hands on tutorial covers metrics observability features, limitations, and practical applications, so youβll know exactly what works and what doesnβt.
Whether youβre new to Snowflake or an experienced user, this video is packed with insights to enhance your skills!
Disclaimer: All snowflake-related learning materials and tutorial videos published in this channel are the personal opinions of the data engineering simplified team and they're neither authorized by nor associated with Snowflake, Inc.Trace Events - Observability Feature In SnowflakeData Engineering Simplified2025-01-09 | Discover everything you need to know about Trace Events, a powerful observability feature, added into the Snowflake toolkit. This comprehensive 40-minute hands on guide will teach you how to create and use trace events with detailed examples, including stored procedures written in SQL and Python scripting language.
This hands on tutorial covers event table's key features, limitations, and practical applications, so youβll know exactly what works and what doesnβt.
Whether youβre new to Snowflake or an experienced user, this video is packed with insights to enhance your skills!
This "Trace Events - Observability Feature In Snowflake" video tutorial will explores π€ Where are trace events recorded in Snowflake? π€ How can trace events be enabled in Snowflake, and are there different levels available? π€ Can trace events be enabled for UDFs, UDTFs, and stored procedures across all supported languages? π€ Does Snowflake provide a UI to view traces, spans, and events? ... and many more...
Disclaimer: All snowflake-related learning materials and tutorial videos published in this channel are the personal opinions of the data engineering simplified team and they're neither authorized by nor associated with Snowflake, Inc.Snowflake Event Tables Complete Guide | Snowflake Observability & Logging FeatureData Engineering Simplified2025-01-02 | Discover everything you need to know about Event Tables in Snowflake in this comprehensive 50-minute hands on guide! Learn how to create and use event tables with detailed examples, including stored procedures written in SQL, Python, Java, Scala, and JavaScript.
This hands on tutorial covers event table's key features, limitations, and practical applications, so youβll know exactly what works and what doesnβt.
Whether youβre new to Snowflake or an experienced user, this video is packed with insights to enhance your skills!
This "Snowflake Observability & Logging Feature" video tutorial will explores π€ Does Snowflake automatically create a default event table for the account? π€ Can multiple event tables be created in Snowflake? π€ Is the event table feature available in all editions of Snowflake? π€ How can we view the logs captured in event tables? Does Snowflake provide a web UI for this? π€ Do event tables incur additional costs beyond storage? If so, where can I find this information? π€ Is logging limited to SQL script-based stored procedures, or does it also apply to Python, Java, Scala, and JavaScript? π€ What additional features do event tables offer apart from logging? ... and many more...
Disclaimer: All snowflake-related learning materials and tutorial videos published in this channel are the personal opinions of the data engineering simplified team and they're neither authorized by nor associated with Snowflake, Inc.SWIGGY Data Pipeline | End To End Data Engineering Project In SnowflakeData Engineering Simplified2024-12-12 | Discover π how food aggregators and quick-commerce platforms like Swiggy leverage the Snowflake to power their data pipelines! This hands-on π οΈ tutorial starts with a high-level food order process flow, explores the OLTP source ER diagram for data analysis, and explains the 3-layer data warehouse architecture. Watch as we transform data flow requirements into implementation, create fact and dimension tables, and build an interactive Streamlit dashboard. Perfect for beginners or those curious about executing end-to-end data projects in Snowflake, this real life end to end data project walkthrough will demystify the process πͺ step by step πͺ using snowflake cloud data platform.
ποΈ Design Considerations: Explore the critical decisions behind crafting the data model and structuring the overall project architecture tailored for a food aggregatorβs data pipeline.
π Data Flow: Follow the journey of data from loading and curation to transformation within Snowflake. Gain insights into the step-by-step process for ensuring data quality and integrity while leveraging Snowflake to maximize efficiency and streamline the pipeline.
Once you complete this end to end real life food aggregator based data engineering project (ETL or ELT) using snowflake, you would be able answer of following questions π€ How to load data using snowflake's snowsight data loading feature without any tool dependency π€ How to load delta data set and let is go through the data pipeline? π€ How to use $ notation to query stage file? π€ How to run copy command to load CSV files into tables? π€ How to design different layers & fact/dimension tables? π€ How to see the KPI and data insight using Streamlit?
Disclaimer: All snowflake-related learning materials and tutorial videos published in this channel are the personal opinions of the data engineering simplified team and they're neither authorized by nor associated with Snowflake, Inc.Data Lineage In Snowflake Using SnowsightData Engineering Simplified2024-11-28 | This video will cover Snowflake Data Lineage in Snowsight, a new feature that is released recently. This hands on video tutorial explores β‘οΈ Where to go and see the lineage detail in snowsight. β‘οΈ How to find downstream and upstream lineage. β‘οΈ How to check column level lineage β‘οΈ Limitation of the snowflake data lineage feature. and how this data lineage feature can be used perform impact analysis, monitoring, troubleshooting, and compliance related items.
Disclaimer: All snowflake-related learning materials and tutorial videos published in this channel are the personal opinions of the data engineering simplified team and they're neither authorized by nor associated with Snowflake, Inc.10 | Snowflake Virtual Warehouse Cost Management Monitoring | #costoptimizationData Engineering Simplified2024-11-23 | In this quick video, learn how to navigate the Virtual Warehouse Cost Management screen in Snowflake and easily check your virtual warehouse costs. π§Ύπ» Whether youβre tracking usage or optimizing expenses, this step-by-step guide will help you manage your Snowflake resources effectively. Perfect for admins and architects looking to stay on top of their Snowflake cost control!
Disclaimer: All snowflake-related learning materials and tutorial videos published in this channel are the personal opinions of the data engineering simplified team and they're neither authorized by nor associated with Snowflake, Inc.07 | Importance Of Resource Monitor On Snowflake Virtual Warehouse | #costoptimizationData Engineering Simplified2024-11-21 | Discover the importance of Resource Monitors in Snowflake Virtual Warehouses in this short and focused video! π― Learn how to effectively use resource monitors to track and control costs while maintaining performance. Whether youβre a Snowflake admin or a data architect, this video shows you why resource monitoring is a must-have tool for optimizing your Snowflake usage. Watch now to save costs and maximize efficiency! π‘
Disclaimer: All snowflake-related learning materials and tutorial videos published in this channel are the personal opinions of the data engineering simplified team and they're neither authorized by nor associated with Snowflake, Inc.08 | RBAC & Privileges - Snowflake Virtual Warehouse | #costoptimizationData Engineering Simplified2024-11-20 | Learn all about Snowflake Virtual Warehouses and the 5 key different privileges and Role Based Access Control (RBAC) settings in this hands-on video!
Discover how improper RBAC setting can lead to unexpected cost implications and see live demonstrations of both best practices and potential pitfalls. Perfect for anyone looking to optimize their Snowflake setup for performance and cost-efficiency. Donβt miss out on these essential tips for Snowflake architects and admins!
Disclaimer: All snowflake-related learning materials and tutorial videos published in this channel are the personal opinions of the data engineering simplified team and they're neither authorized by nor associated with Snowflake, Inc.06 | How Multicluster Virtual Warehouse Works in SnowflakeData Engineering Simplified2024-11-18 | Many of us are not sure how multicluster virtual warehouse works in snowflake cloud data warehouse. In this quick and short video, we will unlock the power of multi-cluster virtual warehouses in Snowflake and break down the key concepts of concurrency, scalability, and how Snowflake dynamically manages workloads to maintain peak performance.
Youβll learn: β’ What a multi-cluster virtual warehouse is and why itβs essential. β’ How Snowflake handles concurrent queries seamlessly without delays. β’ The difference between single and multi-cluster virtual warehouses. β’ Practical tips to optimize costs while maximizing performance.
Whether youβre a beginner or an experienced Snowflake user, this video will help you understand concurrency scaling and why itβs a game-changer for modern data warehouses.
Disclaimer: All snowflake-related learning materials and tutorial videos published in this channel are the personal opinions of the data engineering simplified team and they're neither authorized by nor associated with Snowflake, Inc.05 | Snowpark Optimized Virtual Warehouse In Snowflake | #costoptimizationData Engineering Simplified2024-11-15 | Are you a Snowflake developer or data enthusiast wondering when to optimize your virtual warehouse for Snowpark workloads? In this video, I dive into Snowpark Optimization for virtual warehouses, explaining: - What Snowpark optimization is and how it works - Key scenarios where itβs beneficial - Situations where it may not be the right fit
Whether youβre looking to improve performance or reduce costs, this video provides practical insights and examples to help you make informed decisions.
Disclaimer: All snowflake-related learning materials and tutorial videos published in this channel are the personal opinions of the data engineering simplified team and they're neither authorized by nor associated with Snowflake, Inc.04 | Snowflake Virtual Warehouse 60-Second Billing Cycle | #costoptimizationData Engineering Simplified2024-11-14 | Learn how Snowflakeβs unique billing model optimizes costs with an initial 60-second billing cycle. In this video, we break down how compute costs are calculated, why the first minute matters, and how understanding this concept can help you save on your Snowflake warehouse usage. Perfect for Snowflake beginners!
Disclaimer: All snowflake-related learning materials and tutorial videos published in this channel are the personal opinions of the data engineering simplified team and they're neither authorized by nor associated with Snowflake, Inc.03 | How Much Does Snowflake Virtual Warehouse Cost? | Credit Cost Vs Dollar CostData Engineering Simplified2024-11-13 | Curious about Snowflake Virtual Warehouse (compute) pricing? This vides tutorial breaks down how Snowflake compute (VWH) costs are calculated, focusing on virtual warehouse usage, pricing models, and tips to optimize costs effectively.
Disclaimer: All snowflake-related learning materials and tutorial videos published in this channel are the personal opinions of the data engineering simplified team and they're neither authorized by nor associated with Snowflake, Inc.02 | Snowflake Compute Auto-Resume & Auto-Suspend PropertiesData Engineering Simplified2024-11-12 | In this video, explore Snowflakeβs auto-resume and auto-suspend properties, essential features for managing compute costs effectively. Learn how auto-resume helps virtual warehouses restart automatically when queries are issued, and how auto-suspend reduces costs by pausing idle warehouses.
We dive into configuring these settings through Snowsight WebUI, showing how they impact performance and cost-efficiency in your Snowflake environment.
Disclaimer: All snowflake-related learning materials and tutorial videos published in this channel are the personal opinions of the data engineering simplified team and they're neither authorized by nor associated with Snowflake, Inc.01 | Type of Virtual Warehouses (Compute) In Snowflake | Snowflake Tutorial With ExamplesData Engineering Simplified2024-11-11 | This hands-on guide explores the different types of virtual warehouses (compute) in Snowflake, focusing on user-defined and serverless configurations. Using Snowflakeβs Snowsight WebUI, youβll learn how to configure and manage virtual warehouses, optimize performance, and understand the benefits of each type for your data processing needs.
Perfect for Snowflake users looking to deepen their understanding of compute environments.
Disclaimer: All snowflake-related learning materials and tutorial videos published in this channel are the personal opinions of the data engineering simplified team and they're neither authorized by nor associated with Snowflake, Inc.Recursive CTE in SQLData Engineering Simplified2024-10-22 | Are you curious about how SQL experts simplify complex queries? In this video, we dive into the power of recursive Common Table Expressions (CTEs) or so called recursive SQLs. Whether youβre preparing for a technical interview or working on a real-life data project, mastering recursive CTEs can significantly enhance your SQL writing, making it more efficient and readable.
Weβll explore how to use recursive CTEs start with simple example to scenario based examples and explain its construct in step-by-step manner, using Snowflake cloud data warehouse platform.
This tutorial is beginner-friendly and filled with practical examples you can apply in your daily SQL tasks.
Letβs unlock the magic of recursive CTEs together!
Disclaimer: All snowflake-related learning materials and tutorial videos published in this channel are the personal opinions of the data engineering simplified team and they're neither authorized by nor associated with Snowflake, Inc.Common Table Expression in SQLData Engineering Simplified2024-10-08 | Are you curious about how SQL experts simplify complex queries? In this video, we dive into the power of the βWITHβ clause, commonly known as Common Table Expressions (CTEs). Whether youβre preparing for a technical interview or working on a real-life data project, mastering CTEs can make your SQL writing more efficient and readable.
Weβll explore how to use CTEs with real sales order data, step-by-step, using Snowflake worksheets. This tutorial is beginner-friendly and packed with practical examples you can apply in your daily SQL tasks.
Disclaimer: All snowflake-related learning materials and tutorial videos published in this channel are the personal opinions of the data engineering simplified team and they're neither authorized by nor associated with Snowflake, Inc.Notebook SQL Cell Result Into A Dataframe | Snowflake Notebook TutorialData Engineering Simplified2024-09-17 | This is a quick tutorial covering how to refer a SQL cell result into a python panda's dataframe as well as snowflake snowpark dataframes.
Disclaimer: All snowflake-related learning materials and tutorial videos published in this channel are the personal opinions of the data engineering simplified team and they're neither authorized by nor associated with Snowflake, Inc.Getting Started With Git Snowflake Notebook IntegrationData Engineering Simplified2024-09-10 | Learn how to easily connect Snowflake Notebooks with Git/GitHub in this step-by-step video. Iβll show you how to set up a Git repository inside Snowflake, bring in notebooks from your repo, and perform basic Git tasks like pulling updates and pushing changes. Youβll also see the SQL commands gets executed via query history and if they are metadata operations or need compute cost.
This vitual and hands-on tutorial is a perfect for anyone looking to ehnance their work and keep everything in sync while working with snowflake notebooks.
Disclaimer: All snowflake-related learning materials and tutorial videos published in this channel are the personal opinions of the data engineering simplified team and they're neither authorized by nor associated with Snowflake, Inc.Snowflake NotebooksData Engineering Simplified2024-09-03 | This comprehensive video tutorial on Snowflake Notebooks provides a step-by-step guide on creating a notebook and how this new interactive development environment helps data engineers to write SQL/Python scripts, markdown and Snowpark/Streamlit code under one place and perform data exploration and data visualization activities.
Disclaimer: All snowflake-related learning materials and tutorial videos published in this channel are the personal opinions of the data engineering simplified team and they're neither authorized by nor associated with Snowflake, Inc.Snowflake GitLab Integration | Complete Hands-On Snowflake TutorialData Engineering Simplified2024-08-20 | This comprehensive video tutorial on Snowflake and GitLab integration provides a step-by-step guide on creating a GitLab/Git repository internal stage object within Snowflake. Whether you're working with private or public repositories, this tutorial will show you how to seamlessly access and manage database script files directly within Snowflake.
This Snowflake Git (GitLab) integration tutorial covers every SQL command applicable to a Git Repository Internal Stage object and demonstrates how to share access with other Snowflake roles using the RBAC feature. You'll also learn how to execute SQL scripts, create a Python-based stored procedure by referencing a GitHub `.py` file, and explore how to export a python/jupyter notebook within snowflake from GitLab repo.
Disclaimer: All snowflake-related learning materials and tutorial videos published in this channel are the personal opinions of the data engineering simplified team and they're neither authorized by nor associated with Snowflake, Inc.Snowflake BitBucket Integration | Complete Hands-On Snowflake TutorialData Engineering Simplified2024-08-13 | This hands-on, end-to-end Snowflake and BitBucket (Atlassian) integration tutorial demonstrates how to create a BitBucket/Git repository object within Snowflake for both private and public repositories, enabling seamless access to database script files within Snowflake.
In this Snowflake (Integration) tutorial, youβll learn about each SQL command that can be used on a Git Repository Stage object, as well as how to share access with other Snowflake roles using the RBAC feature. The video also covers executing SQL scripts, creating a Python-based stored procedure by referencing a GitHub .py file, and discusses the current limitations.
Disclaimer: All snowflake-related learning materials and tutorial videos published in this channel are the personal opinions of the data engineering simplified team and they're neither authorized by nor associated with Snowflake, Inc.Snowflake GitHub Integration | Complete Hands-On Snowflake TutorialData Engineering Simplified2024-08-06 | This hands-on, end-to-end Snowflake Git/GitHub integration demonstrates how to create a Git repository object within Snowflake for both private and public repositories, allowing seamless access to database script files within Snowflake.
This Snowflake tutorial explains each SQL command that can be used on a Git Repository Stage object and how to share access with other Snowflake roles using the RBAC feature. The video tutorial also covers executing SQL scripts and creating a Python-based stored procedure by referencing a GitHub .py file. It also discusses the current limitations.
Disclaimer: All snowflake-related learning materials and tutorial videos published in this channel are the personal opinions of the data engineering simplified team and they're neither authorized by nor associated with Snowflake, Inc.10 Tips To Reduce & Manage Snowflake Virtual Warehoue Cost EfficientlyData Engineering Simplified2024-08-01 | While working with Snowflake, virtual warehouses (compute resources) dominate overall snowflake platform cost. It is crucial to understand various warehouse-level parameters and additional objects (like Resource Monitor) to help your Snowflake platform team and projects manage its costs effectively. This video covers the most commonly ignored parameters and concepts, enabling you to design a very cost-efficient Snowflake environment and run your platform more effectively.
Disclaimer: All snowflake-related learning materials and tutorial videos published in this channel are the personal opinions of the data engineering simplified team and they're neither authorized by nor associated with Snowflake, Inc.Masking JSON Data Using Dynamic Data Masking Possible? | Part-05Data Engineering Simplified2024-07-09 | Securing and masking standard data types with dynamic data masking is straightforward using simple policy objects. However, applying masking policies to variant data types that contain JSON documents can be more complex. This video addresses these challenges and explains how to mask sensitive data within JSON documents. Youβll learn how to apply both single and multiple attribute masking to variant data types within a table.
This tutorial goes beyond SQL syntax and covers all important aspects of dynamic data masking for column-level security in Snowflake views.
Once you complete this visual guided tour, you would be able to understand and answer following questions 1. How to mask variant column JSON attributes using DDM? 2. How to mask multiple attributes within a variant data type usign DDM? 3. What are the limitation of data maskign when applying on variant data type?
ππ Chapters -------------------------- β₯ 00:00 Introduction β₯ 01:23 Welcome Note β₯ 01:57 Standard Data Masking Approach β₯ 03:38 Variant Data Type & Data Masking β₯ 08:57 Multiple Attribute Data Masking β₯ 11:10 Special Section β₯ 12:05 Thank You Note
Disclaimer: All snowflake-related learning materials and tutorial videos published in this channel are the personal opinions of the data engineering simplified team and they're neither authorized by nor associated with Snowflake, Inc.Snowflake Views & Column Level Security Applicability | Part-04Data Engineering Simplified2024-06-04 | Snowflake supports four types of views, and in this video, we'll find out if these views support column-level security (Dynamic Data Masking). We'll learn how to use dynamic masking for views and protect sensitive information in Snowflake.
This tutorial goes beyond SQL syntax and covers all important aspects of dynamic data masking for column-level security in Snowflake views.
Once you complete this visual guided tour, you would be able to understand and answer following questions 1. Do all kind of view support column level security? 2. How to set and un-set column level security in snowflake view? 3. How snowflake view behave when underlying table already has masked data.
Disclaimer: All snowflake-related learning materials and tutorial videos published in this channel are the personal opinions of the data engineering simplified team and they're neither authorized by nor associated with Snowflake, Inc.Tag Based Dynamic Data Masking In Snowflake | Part-03Data Engineering Simplified2024-05-07 | Tab Based Dynamic Data Masking is Snowflake's powerful feature to apply masking at scale and reduce the policy deployment cost. In this hands on guide, we will learn how to create tag objects and how to set the policy on multiple column by associating the masking policy to a tag including limitation of tag based masking policy.
This tutorial goes beyond SQL syntax and focuses all all the important aspects of tab based dynamic data masking concepts, facilitating column-level security in the Snowflake cloud data warehouse platform.
Once you complete this visual guided tour, you would be able to understand and answer following questions 1. How to create Tags objects in Snowflake? 2. How associate masking policy with Tag objects? 3. Limitations of tag based dynamic data masking?
Disclaimer: All snowflake-related learning materials and tutorial videos published in this channel are the personal opinions of the data engineering simplified team and they're neither authorized by nor associated with Snowflake, Inc.What Is Conditional Dynamic Data Masking In Snowflake | Part-02Data Engineering Simplified2024-04-30 | We're all familiar with the Dynamic Data Masking policy, but there's another crucial feature in Snowflake that enables the masking of sensitive table data based on certain conditions. Therefore, the focus of this chapter is on how to develop and implement conditional data masking, associating it with a table column. In this short tutorial, we'll cover everything about conditional data masking.
This tutorial goes beyond SQL syntax and focuses all all the important aspects of conditional dynamic data masking concepts, facilitating column-level security in the Snowflake cloud data warehouse platform.
Once you complete this visual guided tour, you would be able to understand and answer following questions 1. Difference between simple and conditional data dynamic masking? 2. How to build conditional data masking policy? 3. How to use the keyword USING to enable the conditional masking.
Disclaimer: All snowflake-related learning materials and tutorial videos published in this channel are the personal opinions of the data engineering simplified team and they're neither authorized by nor associated with Snowflake, Inc.Column Level Security In Snowflake | Dynamic Data Masking In SnowflakeData Engineering Simplified2024-04-16 | To safeguard PII (or PHI or Sensitive Information) column-data/fields, Snowflake has introduced a schema-level masking policy object. This object allows for column-level security and masking/obfuscation to protect sensitive data. This "Column Level Security (CLS) in Snowflake" video tutorial is a comprehensive guide to help snowflake data developers to understand how it can be achived using policy objects.
This tutorial delves beyond SQL syntax and examines all the significant aspects of dynamic data masking, facilitating column-level security in the Snowflake cloud data warehouse platform.
Once you complete this visual guided tour, you would be able to understand and answer following questions 1. Difference between static and dynamic masking? 2. How to apply column level masking in snowflake using masking policy? 3. How to re-use policy objects to mask one or more columns within and across the tables. 4. The data masking and impact on where clause? 5. Importance of context function when creating masking policies?
ππ Chapters -------------------------- β₯ 00:00 Introduction β₯ 01:29 Welcome Note β₯ 02:04 Use Case Explaination β₯ 03:20 Live Example β₯ 11:39 Masking Policy DDL β₯ 14:30 DDM - Information Schema β₯ 21:49 Alter Masking Policy β₯ 26:39 Data Type Mismatch β₯ 28:55 Where Clause Behaviour β₯ 31:00 Special Section β₯ 32:36 What Next
ππ Dynamic Data Masking Playlist ----------------------------------------------------------- Part-01 Dynamic Data Masking youtu.be/7YKQuKKcruo Part-02 Conditional Masking Policy youtu.be/l5zZPSsWTkQ Part-03 Tag Based Masking Policy youtu.be/80l8943gGk0
Disclaimer: All snowflake-related learning materials and tutorial videos published in this channel are the personal opinions of the data engineering simplified team and they're neither authorized by nor associated with Snowflake, Inc.