semantic-view-patterns
OfficialMaster Snowflake SV patterns
System Documentation
What problem does it solve?
This Skill provides a curated catalog of Snowflake Semantic View (SV) patterns and best practices to help data engineers design robust, scalable SVs. It includes end-to-end examples such as range joins, ASOF joins, multi-fact views, role-playing dimensions, and governance patterns, along with ready-to-deploy DDL, seed data, and validation queries to accelerate learning and prototyping.
Core Features & Use Cases
- End-to-end SV pattern templates for common modeling scenarios (range joins, ASOF joins, multi-fact, role-playing dimensions, degenerate/shared dimensions, and governance patterns).
- Step-by-step guidance showing how to declare FACTS, DIMENSIONS, RELATIONSHIPS, and METRICS, with usage of USING and about fan traps, multi-path relationships, and security considerations.
- Quick-start recipes to deploy and validate patterns against Snowflake using the provided snippet files.
Quick Start
Deploy the semantic-view-patterns SV in your Snowflake account and run the provided SEMANTIC_VIEW() queries to explore the patterns.
Dependency Matrix
Required Modules
None requiredComponents
Standard package💻 Claude Code Installation
Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.
Please help me install this Skill: Name: semantic-view-patterns Download link: https://github.com/Snowflake-Labs/coco-skills/archive/main.zip#semantic-view-patterns Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
Agent Skills Search Helper
Install a tiny helper to your Agent, search and equip skill from 510,000+ vetted skills library on demand.