Agent Skills by rj_poseidon
Showing 18 vetted skills indexed across 1 GitHub repositories.
semantic-view
Create, audit, debug, and evaluate Snowflake Cortex Analyst semantic views.
semantic-view-filters-and-metrics-suggestions
Generate metric, filter, and fact suggestions for Snowflake semantic views from query history.
semantic-view-modeling-patterns
Applies 14 cataloged modeling patterns to Snowflake Semantic View YAML definitions.
import_powerbi
Import Power BI .pbit and .pbix files into Snowflake Semantic Views.
semantic-view-vqr-suggestions
Generate verified query suggestions for Snowflake semantic views from Cortex Analyst and query history.
semantic-view-time-tracking
Track and report execution time for workflow steps and agent tasks.
semantic-view-patterns
Applies optimization patterns to Snowflake semantic view dimensions, metrics, filters, and relationships.
semantic-view-setup
Initializes session directories and routes Snowflake semantic view creation or optimization workflows.
semantic-view-creation
Generate Snowflake semantic views from SQL queries and table metadata using the FastGen system function.
evaluate-cortex-analyst
Runs Snowflake Analyst Evaluations to measure Cortex Analyst SQL generation accuracy against verified queries.
semantic-view-audit
Audit Snowflake semantic views via VQR testing, best practices checks, and custom criteria.
semantic-view-validation
Validate semantic model changes by comparing SQL execution results with exact match requirements.
semantic-view-upload
Uploads a semantic view YAML file to a Snowflake database schema.
import_tableau
Convert Tableau workbooks and datasources into Snowflake Semantic Views.
semantic-view-debug
Diagnoses and fixes SQL generation issues in Snowflake semantic views through iterative optimization.
custom-criteria-audit
Validates semantic view components against user-defined natural language criteria.
vqr-testing-audit
Tests verified queries against Snowflake semantic views without VQR hints to measure completeness.
best-practices-audit
Audits Snowflake semantic view YAML files for best practices, inconsistencies, duplicates, and missing relationships.
Frequently Asked Questions About rj_poseidon
FAQPage SchemaWhat tasks can I perform with rj_poseidon's semantic view skills?▼
You can create semantic views via the FastGen system function, import Tableau and Power BI files, generate VQR and metric/filter suggestions from query history, audit views against best practices, debug SQL generation failures, and run native sql_correctness evaluations on Cortex Analyst.
Who are these semantic view skills designed for?▼
They target analytics engineers, BI developers, and data modelers working in Snowflake who maintain semantic views for Cortex Analyst, migrate Tableau or Power BI assets, or need to measure and improve natural-language-to-SQL accuracy.
How do I start using the semantic view skill set?▼
Invoke the semantic-view entry skill first; it routes every request through semantic-view-setup, which creates the session directory structure and directs you to the creation, audit, debug, or evaluation path. Never attempt manual semantic view edits outside this flow.
What prerequisites and dependencies do these skills require?▼
A Snowflake account with Cortex Analyst access is required, since creation uses the FastGen system function, evaluation uses native Analyst Evaluations, and uploads target a Snowflake database.schema. Audit and debug flows additionally require the semantic-view-setup and validation sub-skills.
How is SQL generation accuracy measured and improved?▼
The evaluate-cortex-analyst skill runs Snowflake's native Analyst Evaluations using the sql_correctness metric against a view's own verified queries. Debug findings map to 14 modeling patterns and an optimization library covering dimensions, metrics, filters, relationships, and custom instructions.