semantic-view-creation

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

Updated Mar 7, 2026
One-click install
npx skills add https://github.com/randoneering/nix-flake-mirror --skill semantic-view-creation
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: semantic-view-creation
Source: https://github.com/randoneering/nix-flake-mirror/tree/main/home/programs/opencode/skills/snowflake/semantic-view-optimization/creation
Command: npx skills add https://github.com/randoneering/nix-flake-mirror --skill semantic-view-creation

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Automate end-to-end semantic view creation by orchestrating FastGen-based generation from SQL queries and Snowflake metadata, reducing manual modeling time and errors.

Core Features & Use Cases

  • FastGen-driven semantic model creation from SQL and metadata
  • Automatic generation of tables, relationships, primary keys, metrics, and VQRs
  • Fallback to manual creation workflow when FastGen cannot proceed
  • Phase-based workflow with validation and upgrade options for enhancements

Quick Start

Provide a semantic view name and your SQL and business context to start the FastGen-based creation workflow.

Frequently Asked Questions about semantic-view-creation

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

FAQPage Schema
How do I automate semantic view creation from SQL queries in Snowflake?

Automate semantic view creation by using the FastGen API to generate validated models from SQL queries and Snowflake metadata. This workflow automatically generates tables, relationships, primary keys, metrics, and VQRs to reduce manual modeling time and errors.

What is FastGen's role in building Snowflake semantic models?

FastGen drives semantic model creation by processing SQL and business context to automatically produce tables, relationships, primary keys, and metrics. It orchestrates a phase-based workflow that validates the generated semantic views against your Snowflake metadata.

Do I need specific scripts to generate primary keys and relationships for semantic views?

Yes, supporting scripts such as infer_primary_keys and semantic_view_set are required to enable enhancements. These scripts work with the FastGen workflow to automatically infer primary keys, establish relationships, and generate VQRs for your models.

What happens when FastGen cannot proceed with semantic view generation?

When FastGen cannot proceed with semantic view generation, the workflow falls back to a manual creation process. This manual fallback ensures you can still complete your semantic modeling tasks even when automated generation encounters limitations.

What do I need to start generating semantic views with FastGen?

You need Snowflake access, a FastGen-enabled workflow, and supporting scripts like infer_primary_keys. To start, provide a semantic view name alongside your SQL queries and business context to initiate the automated creation workflow.

Can I upgrade or enhance my semantic views after the initial FastGen creation?

Yes, the phase-based workflow includes validation and upgrade options for enhancements. After the initial semantic view creation, you can apply supporting scripts to further refine primary keys, relationships, metrics, and VQRs.