SnowPro Core Certification Tutorial (COF-C03)(Unofficial) : Snowflake object hierarchy and types

Disclaimer : This course is an independent study guide. It is not affiliated with, sponsored by, or endorsed by Snowflake Inc. All trademarks belong to their respective owners.

In this video, we break down Domain 1.3 of the Snowflake certification. We move from the "Bird's Eye View" of Organizations and Accounts down into the granular details of Database Objects and Session Context. This is a foundational lesson—master this, and the rest of Snowflake starts to make perfect sense.

🔍 What We Cover:
The Global Hierarchy: Understanding the relationship between Organizations, Accounts, and Users.

Database Objects Deep Dive: We define and differentiate every key object:

Storage & Structure: Schemas, Tables, Views, and Stages.

Automation & Logic: Pipes, Stored Procedures, UDFs, and Sequences.

Modern Snowflake: ML Models, Applications, and Shares.

Session & Context Variables: How to use CURRENT_ROLE(), CURRENT_WAREHOUSE(), and more.

The Parameter Hierarchy: A clear guide to Precedence—knowing which setting wins (Account vs. User vs. Session vs. Object).

📑 Timestamps:
0:00 - Introduction to Domain 1.3
0:08 - Snowflake object hierarchy and types Intro
2:43 - Organization and Account Objects
4:01 - Snowflake Accounts
7:25 - Database Objects - Intro
7:42 - Stages
8:54 - Schemas
15:22 - Tables
49:26 - Views
53:45 - User Defined Functions
56:08 - Stored Procedures
58:22 - Difference between UDF's and Stored Procedures
1:00:08 - File Formats
1:03:33 - Snowpipe
1:09:46 - Shares
1:12:54 - Sequences
1:14:55 - Snowflake ML
1:17:24 - Applications
1:18:21 - Parameter Hierarchy
1:22:36 - Parameter precedence
Resources:
Official Exam Guide: https://learn.snowflake.com/en/certifications/snowpro-core-c03/
TopMate: https://topmate.io/jassingh
LinkedIn: https://www.linkedin.com/in/jaswinder-singh-916973209/
#Snowflake #SnowProCore #DataEngineering #CloudComputing #COFC03 #DatabaseArchitecture #SQL #SnowflakeCertification #DataWarehouse #TechTutorial

Видео SnowPro Core Certification Tutorial (COF-C03)(Unofficial) : Snowflake object hierarchy and types канала Data-2-Dollars