Does it support the specialized SEMANTIC_VIEW query syntax?

Absolutely. After creating a view, the skill provides example SQL queries using the correct Snowflake syntax for accessing dimensions and metrics within a semantic view.

Does this skill require the Snowflake CLI?

Yes, this skill utilizes the official Snowflake CLI (snow) to validate DDL statements and execute commands against your Snowflake instance for real-time verification.

Can it automatically document my semantic views?

Yes. It scans your existing Snowflake table and column comments to automatically suggest synonyms and descriptions, ensuring your semantic layer is well-documented.

How does the validation process work?

The skill creates a temporary validation view using a unique suffix, executes the DDL via the CLI, and only applies the final version once the syntax is confirmed successful.

Snowflake Semantic Views

Name: Snowflake Semantic Views
Author: MiguelElGallo

byMiguelElGallo

•

数据库管理

Automates the creation, validation, and optimization of Snowflake semantic views and data layers via the Snowflake CLI.

This skill enables Claude to manage the full lifecycle of Snowflake semantic layers, from initial DDL generation to live validation. It specializes in building star-schema-compliant views, extracting metadata for synonyms and comments, and ensuring syntax accuracy through a mandatory Snowflake CLI validation workflow. By automating the boilerplate of 'CREATE SEMANTIC VIEW' statements and testing them in temporary environments, it provides data engineers with a reliable way to deploy governed semantic models that follow Snowflake best practices.

主要功能

01Mandatory validation loop using Snowflake CLI to catch syntax errors before deployment

02Metadata extraction from existing table comments to populate synonyms and descriptions

03Support for star schema modeling including facts, dimensions, and metrics

04Automated DDL generation for Snowflake CREATE and ALTER SEMANTIC VIEW statements

05Generation of specialized sample queries using the SEMANTIC_VIEW function syntax

061 GitHub stars

使用场景

01Migrating existing relational views into the Snowflake semantic layer with enhanced metadata

02Troubleshooting and validating complex semantic DDL against live Snowflake environments

03Building a governed semantic layer for BI tools and data applications directly in Snowflake

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add miguelelgallo/snowflake-semantic-view-skill skills

For use in Claude.ai and ChatGPT

Download Skill