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

semantic-view-upload

Uploads a semantic view YAML file to a Snowflake database schema.

Updated Jun 9, 2025
Search Tags:#yaml#database schema#deploy#upload#snowflake#semantic view#cortex analyst
One-click install
npx skills add https://github.com/RajaPoseidon/snippets_repo --skill semantic-view-upload-rajaposeidon
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: semantic-view-upload
Source: https://github.com/RajaPoseidon/snippets_repo/tree/main/snowflake/skills/upload
Command: npx skills add https://github.com/RajaPoseidon/snippets_repo --skill semantic-view-upload-rajaposeidon

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve? Deploying a semantic view YAML definition to Snowflake requires correct SQL syntax, identifier quoting, and connection handling, which is error-prone when done manually. ## Core Features & Use Cases - Guided Upload Workflow: Reads the YAML file, extracts the semantic view name, and determines the target database.schema from prior setup context. - Overwrite or Rename Options: Supports CREATE OR REPLACE for existing views or uploading under a new name. - Automated SQL Handling: A companion Python script manages SQL escaping, quoted identifiers, and connection selection. - Use Case: After optimizing a semantic view YAML locally, deploy it back to the original Snowflake database.schema with a single command. ## Quick Start Upload my optimized semantic view YAML file to the same Snowflake database and schema as the original view.

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 a semantic view YAML file to Snowflake?▼

Run the upload script with the YAML file path and target database.schema, for example: python upload_semantic_view_yaml.py ./semantic_model.yaml ENG_CORTEX_ANALYST.DEV. The script handles SQL escaping and outputs the deployed view location.

How do I overwrite an existing semantic view in Snowflake?▼

Choose the overwrite option when prompted, which uses CREATE OR REPLACE SEMANTIC VIEW semantics. This replaces the existing view in the same database.schema without changing its name.

Can I upload a semantic view with a different name?▼

Yes, select the create-with-new-name option during the upload prompt and provide the new name. The view is still deployed to the same database.schema derived from the YAML or setup context.

What privileges are needed to create a semantic view in Snowflake?▼

You need CREATE SEMANTIC VIEW privilege on the target schema and SELECT privilege on the underlying tables and views referenced by the semantic model. An active Snowflake connection must also be configured.

Does the upload handle database or schema names with spaces?▼

Yes, quoted identifiers are handled automatically by the upload script. Database or schema names containing spaces are quoted correctly without manual escaping.

Related Skills

Explore More Data & Analytics Skills→
exploreomniexploreomni
30

omni-to-snowflake-semantic-view

Convert Omni Analytics topics into Snowflake Semantic View YAML definitions.

Official
Advanced
QuilpieQuilpie
2

snowflake-amazon-quick-skills

Automate Snowflake Cortex AI and Amazon QuickSight integration for sales analytics pipelines.

Community
Advanced
thoughtspotthoughtspot
3

ts-convert-to-snowflake-sv

Convert ThoughtSpot TML worksheets into Snowflake Semantic View DDL.

Official
Advanced
DynatraceDynatrace
120

dt-app-notebooks

Create and validate Dynatrace notebooks with markdown and DQL sections.

Official
Advanced