How annabogo-hubs/snowflake-permissions works
Processing Layer
• Center the main script components (script.ipynb, query.py)
• As a process block or hexagon
• Configuration template (config.template.yaml) connected to this layer
Snowflake Integration Layer
• Three main aspects of Snowflake's access control:
• Users
• Roles
• Resource Access (Warehouses, Databases, Schemas)
[Configuration Files Layer]
• ↓
[Processing Layer]
• ↓
[Snowflake Platform Layer]
Specific relationships
• How users.yaml defines user-to-role mappings
• How roles.yaml defines role hierarchies and resource access
• Demonstrate the flow of permission updates to Snowflake
Additional Details
• A note about MFA configuration
• Parent_role relationship concept
• The declarative nature of the configuration (YAML files)
• The separation between configuration and execution
• The hierarchical role structure in Snowflake
• The three-level permission model (read, create, own)
Validation step where current permissions are checked against desired state
• Clear hierarchical layouts
• Nested components (especially for the Snowflake layer)
• Text annotations for important notes