Snowflake Object Hierarchy

Snowflake Architecture

Emily Melhuish

Technical Curriculum Developer, Snowflake

Understanding the Object Hierarchy

Understanding the Object Hierarchy

Understanding the Object Hierarchy

Understanding the Object Hierarchy

Understanding the Object Hierarchy

Account-level vs Database-level Objects

¹ https://docs.snowflake.com/en/user-guide/security-access-control-overview

Context

Role → Warehouse → Database → Schema

Set Session Context

• USE ROLE
• USE WAREHOUSE
• USE DATABASE
• USE SCHEMA

 

Check Session Context

• CURRENT_ROLE()
• CURRENT_WAREHOUSE()
• CURRENT_DATABASE()
• CURRENT_SCHEMA()

Session Variables

• Store and re-use values
• Create: SET min_users = 100
• Use: SELECT $min_users;

¹ https://docs.snowflake.com/en/sql-reference/sql/set

Parameter hierarchy: Account Parameters

¹ https://docs.snowflake.com/en/sql-reference/parameters

Session Parameters

Virtual Warehouse Parameters

Table Parameters

Let's practice!

Snowflake Architecture