跳转到主要内容
此内容尚未提供您的语言版本,正在以英文显示。

Snowflake Development

插件 已验证 活跃

Snowflake SQL, data pipelines (Dynamic Tables, Streams+Tasks), Cortex AI functions, Snowpark Python, and dbt integration. Includes query helper script, 3 reference guides, and troubleshooting.

1 个 Skill 0 个 MCP
目的

To empower developers working with Snowflake by providing specialized tools, best practices, and troubleshooting guidance for SQL, data pipelines, AI functions, Snowpark, and dbt.

功能

  • Snowflake SQL development assistance
  • Data pipeline creation (Dynamic Tables, Streams+Tasks)
  • Cortex AI function integration
  • Snowpark Python development support
  • dbt integration for Snowflake

使用场景

  • Writing complex Snowflake SQL queries with best practices
  • Building and managing near real-time data pipelines
  • Integrating AI capabilities into Snowflake workflows
  • Developing and deploying Python code within Snowflake
  • Configuring and optimizing dbt projects for Snowflake

非目标

  • Managing Snowflake infrastructure beyond code and pipeline definitions
  • Providing generic Python development tools outside of Snowpark context
  • General-purpose SQL dialect support for databases other than Snowflake

工作流

  1. Generate SQL templates (MERGE, Dynamic Tables, RBAC)
  2. Implement data pipelines using Dynamic Tables or Streams/Tasks
  3. Integrate Cortex AI functions for data enrichment
  4. Develop and deploy Snowpark Python code
  5. Configure dbt models for Snowflake

实践

  • SQL Best Practices
  • Data Pipeline Design
  • AI Integration
  • Secure Coding

先决条件

  • Python 3
  • Snowflake account access
  • dbt CLI (for dbt integration)

Code Execution

  • info:ValidationThe `snowflake_query_helper.py` script likely performs some validation on its inputs (table names, columns) for generating SQL, but a formal schema library (like Zod or Pydantic) is not explicitly evident from the provided files.

安装

/plugin install snowflake-development@alirezarezvani-claude-skills

质量评分

已验证
98 /100
1 day ago 分析

信任信号

最近提交1 day ago
星标14.6k
许可证MIT
状态
查看源代码