Snowflake语义视图助手：自动化创建与验证Snowflake语义视图的AI工具

snowflake-semanticview by github/awesome-copilot

7,500 周安装量

27,200 GitHub Stars

GitHub

安装命令

npx skills add https://github.com/github/awesome-copilot --skill snowflake-semanticview

开发云服务数据分析

🇨🇳中文介绍

Snowflake 语义视图

一次性设置

打开新的终端并运行 snow --help 以验证 Snowflake CLI 是否已安装。
如果缺少 Snowflake CLI 或用户无法安装，请引导他们访问 https://docs.snowflake.com/en/developer-guide/snowflake-cli/installation/installation。
根据 https://docs.snowflake.com/en/developer-guide/snowflake-cli/connecting/configure-connections#add-a-connection 的说明，使用 snow connection add 配置 Snowflake 连接。
在所有验证和执行步骤中使用配置好的连接。

每个语义视图请求的工作流程

确认目标数据库、模式、角色、仓库以及最终的语义视图名称。
确认模型遵循星型模式（事实表与一致性维度表）。
使用官方语法起草语义视图 DDL：
- https://docs.snowflake.com/en/sql-reference/sql/create-semantic-view
为每个维度、事实和指标填充同义词和注释：
- 首先读取 Snowflake 表/视图/列的注释（首选来源）：
  - https://docs.snowflake.com/en/sql-reference/sql/comment
- 如果缺少注释或同义词，询问是否可以创建它们，用户是否希望提供文本，或者是否应该起草建议以供批准。

广告位招租

在这里展示您的产品或服务

触达数万 AI 开发者，精准高效

联系我们

同义词和注释（必需）

使用语义视图语法定义同义词和注释：

WITH SYNONYMS [ = ] ( 'synonym' [ , ... ] ) COMMENT = 'comment_about_dim_fact_or_metric'
将同义词仅视为信息性内容；不要在其他地方使用它们来引用维度、事实或指标。
将 Snowflake 注释作为同义词和注释的首选和首要来源：
- https://docs.snowflake.com/en/sql-reference/sql/comment
如果缺少 Snowflake 注释，询问是否可以创建它们，用户是否希望提供文本，或者是否应该起草建议以供批准。
未经用户批准，不得自行编造同义词或注释。

验证模式（必需）

切勿跳过验证。在将 DDL 作为最终版本呈现之前，务必使用 Snowflake CLI 在 Snowflake 上执行它。
验证时优先使用临时名称，以避免覆盖真实的视图。

CLI 验证示例（模板）

# 将占位符替换为实际值。
snow sql -q "<CREATE OR ALTER SEMANTIC VIEW ...>" --connection <connection_name>

如果您的 CLI 版本使用不同的连接标志，请运行：

将安装和连接设置视为一次性步骤，但在首次验证前需确认它们已完成。
除了名称外，保持最终的语义视图定义与已验证的临时定义完全相同。
不要省略同义词或注释；即使它们在语法上是可选的，也应将其视为完整性所必需的。

🇺🇸English

Snowflake Semantic Views

One-Time Setup

Verify Snowflake CLI installation by opening a new terminal and running snow --help.
If Snowflake CLI is missing or the user cannot install it, direct them to https://docs.snowflake.com/en/developer-guide/snowflake-cli/installation/installation.
Configure a Snowflake connection with snow connection add per https://docs.snowflake.com/en/developer-guide/snowflake-cli/connecting/configure-connections#add-a-connection.
Use the configured connection for all validation and execution steps.

Workflow For Each Semantic View Request

Confirm the target database, schema, role, warehouse, and final semantic view name.
Confirm the model follows a star schema (facts with conformed dimensions).
Draft the semantic view DDL using the official syntax:
- https://docs.snowflake.com/en/sql-reference/sql/create-semantic-view
Populate synonyms and comments for each dimension, fact, and metric:
- Read Snowflake table/view/column comments first (preferred source):
  - https://docs.snowflake.com/en/sql-reference/sql/comment
- If comments or synonyms are missing, ask whether you can create them, whether the user wants to provide text, or whether you should draft suggestions for approval.
Use SELECT statements with DISTINCT and LIMIT (maximum 1000 rows) to discover relationships between fact and dimension tables, identify column data types, and create more meaningful comments and synonyms for columns.
Create a temporary validation name (for example, append __tmp_validate) while keeping the same database and schema.
Always validate by sending the DDL to Snowflake via Snowflake CLI before finalizing:
- Use snow sql to execute the statement with the configured connection.
- If flags differ by version, check snow sql --help and use the connection option shown there.
If validation fails, iterate on the DDL and re-run the validation step until it succeeds.
Apply the final DDL (create or alter) using the real semantic view name.
Run a sample query against the final semantic view to confirm it works as expected. It has a different SQL syntax as can be seen here: https://docs.snowflake.com/en/user-guide/views-semantic/querying#querying-a-semantic-view Example:

SELECT * FROM SEMANTIC_VIEW(

    my_semview_name
    DIMENSIONS customer.customer_market_segment
    METRICS orders.order_average_value
)
ORDER BY customer_market_segment;

11. Clean up any temporary semantic view created during validation.

Synonyms And Comments (Required)

Use the semantic view syntax for synonyms and comments:

WITH SYNONYMS [ = ] ( 'synonym' [ , ... ] ) COMMENT = 'comment_about_dim_fact_or_metric'
Treat synonyms as informational only; do not use them to reference dimensions, facts, or metrics elsewhere.
Use Snowflake comments as the preferred and first source for synonyms and comments:
- https://docs.snowflake.com/en/sql-reference/sql/comment
If Snowflake comments are missing, ask whether you can create them, whether the user wants to provide text, or whether you should draft suggestions for approval.
Do not invent synonyms or comments without user approval.

Validation Pattern (Required)

Never skip validation. Always execute the DDL against Snowflake with Snowflake CLI before presenting it as final.
Prefer a temporary name for validation to avoid clobbering the real view.

Example CLI Validation (Template)

# Replace placeholders with real values.
snow sql -q "<CREATE OR ALTER SEMANTIC VIEW ...>" --connection <connection_name>

If the CLI uses a different connection flag in your version, run:

snow sql --help

Notes

Treat installation and connection setup as one-time steps, but confirm they are done before the first validation.
Keep the final semantic view definition identical to the validated temporary definition except for the name.
Do not omit synonyms or comments; consider them required for completeness even if optional in syntax.

Weekly Installs

7.5K

Repository

github/awesome-copilot

GitHub Stars

26.9K

First Seen

Jan 20, 2026

Security Audits

Gen Agent Trust HubPass SocketPass SnykPass

Installed on

codex7.3K

gemini-cli7.3K

opencode7.3K

github-copilot7.3K

cursor7.3K

claude-code7.3K

React 组合模式指南：Vercel 组件架构最佳实践，提升代码可维护性

102,200 周安装