snowflake-semanticview
Build and validate Snowflake semantic views using Snowflake CLI
by githubFree
Description
snowflake-semanticview is an agent skill from the github/awesome-copilot collection for building and validating Snowflake semantic views with the Snowflake CLI. Semantic views define a business-friendly layer over tables, with the relationships, measures and descriptions that analysts need. The skill handles the whole lifecycle: drafting the DDL, populating synonyms and comments from the table metadata in Snowflake, validating the draft against Snowflake through the CLI, and then executing the final CREATE or ALTER statement. Its one-time setup verifies the CLI is installed, sends the user to Snowflake's installation guide if it is not, and configures a connection that every later step uses. It applies whenever a user asks to create, alter or troubleshoot a semantic view or a semantic layer. It is useful for data teams that want consistent definitions for their analysts and for tools that query Snowflake through a semantic layer. Executing DDL changes the database, so the validated statement should be read and the target schema confirmed before the final CREATE or ALTER runs, and the connection should use credentials with only the privileges the work needs. The skill is installed with the skills CLI from the github/awesome-copilot repository. Its skills.sh page showed about 9.0K installs and passing results from three security audits at the time of the scan.…
Highlights
- Drafts and validates semantic view DDL
- Populates synonyms and comments from table metadata
- Validates against Snowflake via the CLI
- One-time CLI and connection setup
- Installs with the skills CLI
Ratings & Reviews
No ratings yet
Be the first to rate snowflake-semanticview.
People also visit
postgresql-optimization
Expert guidance on PostgreSQL-specific features, optimization patterns
power-bi-model-design-review
Comprehensive Power BI data model design review framework
sql-code-review
Comprehensive SQL security, performance, and quality analysis across MySQL
snowflake-semanticview FAQ
What is a semantic view?
A business-friendly layer over tables with relationships, measures and descriptions for analysts.
What steps does it run?
Draft the DDL, populate synonyms and comments, validate through the Snowflake CLI, then execute the final CREATE or ALTER.
Should I check before it executes?
Yes. Read the validated statement and confirm the target schema before the change runs.
How do I install it?
Run npx skills add https://github.com/github/awesome-copilot --skill snowflake-semanticview.
What security audits does it have?
skills.sh lists three audits: Gen Agent Trust Hub Pass, Socket Pass and Snyk Pass.
What are the best snowflake-semanticview alternatives?
Popular alternatives to snowflake-semanticview include dbt-transformation-patterns, cosmosdb-datamodeling and postgresql-optimization. See all snowflake-semanticview alternatives