skills.rest
Gabeujin
GabeujinCOMMUNITY
Explore all skills by this author →
GitHub

snowflake-semanticview

Create, alter, and validate Snowflake semantic views using the CLI.

1|Updated Feb 23, 2026
Search Tags:#cli#data modeling#sql#snowflake#ddl#semantic view
One-click install
npx skills add https://github.com/Gabeujin/workspace-init-mcp --skill snowflake-semanticview-gabeujin
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: snowflake-semanticview
Source: https://github.com/Gabeujin/workspace-init-mcp/tree/main/awesome/skills/snowflake-semanticview
Command: npx skills add https://github.com/Gabeujin/workspace-init-mcp --skill snowflake-semanticview-gabeujin

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill streamlines the creation, modification, and validation of Snowflake semantic views, ensuring data models are correctly defined and functional within the Snowflake environment.

Core Features & Use Cases

  • DDL Generation: Drafts CREATE or ALTER SEMANTIC VIEW statements based on Snowflake's official syntax.
  • Data Discovery: Uses SELECT statements to analyze table relationships, data types, and populate synonyms/comments.
  • Validation: Leverages the Snowflake CLI (snow) to validate DDL against the Snowflake database before final deployment.
  • Use Case: When asked to build a new semantic view for customer analytics, this Skill will guide you through defining dimensions, facts, metrics, and ensuring the DDL is valid before execution.

Quick Start

Use the snowflake-semanticview skill to create a new semantic view named 'customer_sales_summary' in the 'analytics' schema of the 'prod' database.

Frequently Asked Questions about snowflake-semanticview

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I create a semantic view in Snowflake?▼

To create a Snowflake semantic view, you draft a DDL statement defining dimensions, facts, and metrics. This Skill guides you through populating synonyms and comments, then validates the DDL using the Snowflake CLI before deployment.

What is the best way to validate semantic view DDL before deploying to Snowflake?▼

Validating semantic view DDL before deployment requires the Snowflake CLI (`snow`), which checks your creation or alteration statements against the Snowflake database to ensure the data model is correctly defined.

Do I need the Snowflake CLI installed to manage semantic views?▼

Yes, you need the Snowflake CLI installed and a configured connection to use this Skill. It leverages the CLI to validate DDL against the Snowflake database before final execution.

Can I alter an existing semantic view and add new metrics in Snowflake?▼

Yes, you can alter an existing semantic view by drafting an `ALTER SEMANTIC VIEW` statement. This Skill helps define new metrics, analyze table relationships using SELECT statements, and validate the changes before execution.

How does data discovery work when defining dimensions and facts for a semantic view?▼

Data discovery for semantic views uses SELECT statements to analyze underlying table relationships and data types. This process helps accurately populate synonyms and comments for your dimensions and facts before generating the final DDL.

Related Skills

Explore More Software Engineering Skills→
alexandereiseghohialexandereiseghohi

snowflake-semanticview

Create, alter and validate Snowflake semantic views using the CLI.

Community
Advanced
randoneeringrandoneering

semantic-view-creation

Create semantic views from SQL queries and Snowflake metadata via FastGen API.

Community
Advanced
DbxstudioDbxstudio
82

data-exploration-tool

Profile database tables by reading schemas and gathering statistical insights.

Official
Intermediate
webmaxruwebmaxru

snowflake-semanticview

Create, alter, and validate Snowflake semantic views via Snowflake CLI.

Community
Advanced