skills.rest
randoneering
randoneeringCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

semantic-view-upload

Deploy semantic view YAML files to Snowflake databases with overwrite or rename options.

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

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Uploading semantic view YAML files to Snowflake databases to standardize and automate deployment of semantic views across schemas.

Core Features & Use Cases

  • Identify YAML: Locate and validate the semantic view YAML file to upload.
  • Determine Target: Resolve the target database and schema from the optimization context.
  • Upload Execution: Run the provided script to perform the upload with proper quoting and safety.
  • Overwrites vs Renaming: Offer options to overwrite existing views or create a new named view as needed.
  • Use Case: After semantic optimization, deploy consistent semantic views to ensure governance and discovery.

Quick Start

Place your semantic view YAML file and run the upload tool to deploy it to the target Snowflake database.

Frequently Asked Questions about semantic-view-upload

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

FAQPage Schema
How do I upload semantic view YAML files to Snowflake?▼

Uploading semantic view YAML files to Snowflake involves locating the YAML file, resolving the target database and schema, and executing an upload script with proper quoting and error reporting.

What is a semantic view in Snowflake and when do I need to deploy one?▼

A semantic view in Snowflake standardizes data definitions for governance and discovery. You deploy one after semantic optimization to ensure consistent, automated view deployment across schemas.

Can I overwrite an existing database schema view or do I need to rename it?▼

You can overwrite existing views or create a new named view. The upload execution offers overwrite and rename options to handle existing semantic views during the Snowflake database deployment.

How does the upload process determine the correct target database and schema?▼

The upload process determines the target database and schema by resolving the information from the optimization context. It validates the YAML file and identifies the correct target location before executing the upload.

What happens if my YAML file validation fails during the Snowflake upload?▼

If YAML file validation fails, the upload process includes proper error reporting to identify the issue. It validates the YAML before determining the target location and executing the upload script to ensure safe deployment.

Related Skills

Explore More Data & Analytics Skills→
ncksolncksol
1

snowflake-semanticview

Create, alter, and validate Snowflake semantic view DDL via Snowflake CLI.

Community
Advanced
randoneeringrandoneering

data-governance

Generate governance SQL queries against Snowflake ACCOUNT_USAGE views.

Community
Advanced
jamescha-earleyjamescha-earley

snowflake-best-practices

Review Snowflake schemas, queries, and pipelines against best-practice rules.

Community
Advanced
Snowflake-LabsSnowflake-Labs
1

convert

Convert SQL from multiple database platforms into Snowflake syntax.

Official
Intermediate