skills.rest
RajaPoseidon
RajaPoseidonCOMMUNITY
Explore all skills by this author →
GitHub

semantic-view-setup

Initializes session directories and routes Snowflake semantic view creation or optimization workflows.

Updated Jun 9, 2025
Search Tags:#uv#session management#yaml#setup#snowflake#workflow routing#semantic view
One-click install
npx skills add https://github.com/RajaPoseidon/snippets_repo --skill semantic-view-setup-rajaposeidon
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: semantic-view-setup
Source: https://github.com/RajaPoseidon/snippets_repo/tree/main/snowflake/skills/setup
Command: npx skills add https://github.com/RajaPoseidon/snippets_repo --skill semantic-view-setup-rajaposeidon

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires snowflake-connector, pyyaml, requests, and includes scripts (resource) and references (resource) components.

What problem does it solve? Setting up a Snowflake semantic view workflow requires consistent environment checks, isolated session directories, and correct routing between creation and optimization paths, which is error-prone when done manually. ## Core Features & Use Cases - Environment Validation: Verifies uv installation, required Python packages (snowflake-connector, yaml, requests), and Snowflake CLI credentials before any workflow begins. - Session Directory Management: Creates timestamped, isolated working directories via a cross-platform Python helper so files from different runs never conflict. - Workflow Routing: Directs users to the creation sub-skill for new semantic views or downloads the existing semantic model YAML for optimization workflows. - Use Case: A data engineer wants to optimize an existing semantic view; this Skill validates the environment, creates a session folder, downloads the semantic model YAML, and hands off to audit or debug mode. ## Quick Start Ask the assistant to set up a semantic view workflow for your Snowflake environment and specify whether you are creating a new view or optimizing an existing one.

Frequently Asked Questions about semantic-view-setup

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

FAQPage Schema
How do I set up a Snowflake semantic view workflow?▼

Run the setup skill, which verifies uv and Python packages, checks Snowflake CLI credentials, creates a timestamped session directory, and routes you to either the creation or optimization workflow based on your goal.

How do I download an existing Snowflake semantic view as YAML?▼

Use the download_semantic_view_yaml.py script with your fully qualified semantic view name and a configured Snowflake connection. The script saves the semantic model YAML into the optimization subdirectory of your session folder.

What prerequisites are required for Snowflake semantic view tools?▼

You need uv installed, Python packages including snowflake-connector, PyYAML, and requests managed via uv sync, plus a Snowflake CLI configuration file at ~/.snowflake/config.toml or connections.toml.

Does the semantic view setup work on Windows?▼

Yes, all setup steps use cross-platform Python scripts and uv commands that work identically on macOS, Linux, and Windows. The init_session.py helper resolves home directories via Path.home() instead of shell-specific syntax.

Why does the setup fail with a uv not found error?▼

The uv package manager is not installed on your system. Install it using the official Astral installer script for your operating system, restart your shell, and rerun the setup; pip-based workarounds are not supported.

Related Skills

Explore More Data & Analytics Skills→
edjan11edjan11

snowflake-semanticview

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

Community
Advanced
randoneeringrandoneering

semantic-view-optimization-setup

Download semantic model YAML and create a timestamped optimization directory.

Community
Intermediate
alexandereiseghohialexandereiseghohi

snowflake-semanticview

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

Community
Advanced
UnicornUnicorn

query-optimization-agent

Analyze SQL queries and produce rewritten SQL, index recommendations, and execution plan comparisons.

Official
Intermediate