snowflake-semanticview by github/awesome-copilot
npx skills add https://github.com/github/awesome-copilot --skill snowflake-semanticviewsnow --help 以验证 Snowflake CLI 是否已安装。snow connection add 配置 Snowflake 连接。广告位招租
在这里展示您的产品或服务
触达数万 AI 开发者,精准高效
__tmp_validate),同时保持相同的数据库和模式。snow sql 通过配置的连接执行语句。snow sql --help 并使用其中显示的连接选项。SELECT * FROM SEMANTIC_VIEW(
my_semview_name
DIMENSIONS customer.customer_market_segment
METRICS orders.order_average_value
)
ORDER BY customer_market_segment;
11. 清理在验证过程中创建的任何临时语义视图。
使用语义视图语法定义同义词和注释:
WITH SYNONYMS [ = ] ( 'synonym' [ , ... ] ) COMMENT = 'comment_about_dim_fact_or_metric'
将同义词仅视为信息性内容;不要在其他地方使用它们来引用维度、事实或指标。
将 Snowflake 注释作为同义词和注释的首选和首要来源:
如果缺少 Snowflake 注释,询问是否可以创建它们,用户是否希望提供文本,或者是否应该起草建议以供批准。
未经用户批准,不得自行编造同义词或注释。
# 将占位符替换为实际值。
snow sql -q "<CREATE OR ALTER SEMANTIC VIEW ...>" --connection <connection_name>
如果您的 CLI 版本使用不同的连接标志,请运行:
snow sql --help
每周安装量
7.5K
代码仓库
GitHub 星标数
26.9K
首次出现
2026年1月20日
安全审计
安装于
codex7.3K
gemini-cli7.3K
opencode7.3K
github-copilot7.3K
cursor7.3K
claude-code7.3K
snow --help.snow connection add per https://docs.snowflake.com/en/developer-guide/snowflake-cli/connecting/configure-connections#add-a-connection.__tmp_validate) while keeping the same database and schema.snow sql to execute the statement with the configured connection.snow sql --help and use the connection option shown there.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.
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:
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.
# 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
Weekly Installs
7.5K
Repository
GitHub Stars
26.9K
First Seen
Jan 20, 2026
Security Audits
Gen Agent Trust HubPassSocketPassSnykPass
Installed on
codex7.3K
gemini-cli7.3K
opencode7.3K
github-copilot7.3K
cursor7.3K
claude-code7.3K
React 组合模式指南:Vercel 组件架构最佳实践,提升代码可维护性
102,200 周安装