| name | semantic-view-upload |
| description | Upload a semantic view YAML file to Snowflake database.schema |
| parent_skill | semantic-view-optimization |
Upload Semantic View
When to Load
User wants to upload/deploy a semantic view YAML file to a Snowflake database.schema.
Prerequisites
- Semantic view YAML file (local file path)
- Snowflake connection configured
- Target database and schema
- Appropriate privileges (CREATE SEMANTIC VIEW on schema, SELECT on tables/views)
Process
Step 1: Identify Semantic View YAML File
If the user hasn't specified which semantic view YAML file to upload, ask them to specify the file path.
Guideline for determining if context is clear:
- If user says "upload the semantic view" or "upload it" in the context of a recent optimization session, use the most recent optimized YAML file
- If user provides explicit file path, use that
- Otherwise, ask for clarification
Step 2: Read the YAML File and Determine Target Location
Read the semantic view YAML file to extract:
- The semantic view name (from
name: field)
- Validation check: Ensure the YAML is well-formed
Determining database.schema:
- Check if the optimization session has setup information (from setup/SKILL.md step)
- If setup was run, use the original semantic view's fully qualified name (DATABASE.SCHEMA.SEMANTIC_VIEW) as the target location
- Extract database and schema from that fully qualified name
- This ensures the semantic view is uploaded to the same location as the original semantic view being optimized
