Snowflake Development
Skill Verifiziert AktivUse when writing Snowflake SQL, building data pipelines with Dynamic Tables or Streams/Tasks, using Cortex AI functions, creating Cortex Agents, writing Snowpark Python, configuring dbt for Snowflake, or troubleshooting Snowflake errors.
To assist developers in writing efficient Snowflake SQL, building data pipelines, configuring dbt, utilizing Cortex AI, and troubleshooting common Snowflake errors.
Funktionen
- Generates MERGE (upsert) SQL statements
- Generates Dynamic Table DDL with best practices
- Generates RBAC grant statements for roles
- Provides guidance on Snowflake SQL patterns and anti-patterns
- Details usage of Cortex AI functions and agent specifications
- Offers troubleshooting steps for common Snowflake errors
Anwendungsfälle
- Writing complex SQL queries and data manipulation logic in Snowflake
- Automating the creation of data pipeline components like Dynamic Tables
- Configuring user and role-based access control in Snowflake
- Integrating AI capabilities into Snowflake workflows using Cortex AI
- Troubleshooting and resolving common Snowflake errors during development
Nicht-Ziele
- Directly executing SQL commands against a Snowflake instance
- Managing Snowflake infrastructure outside of generating configuration snippets
- Providing a full-fledged Snowflake client or IDE
Installation
/plugin install snowflake-development@alirezarezvani-claude-skillsQualitätspunktzahl
VerifiziertVertrauenssignale
Ähnliche Erweiterungen
Dbt Transformation Patterns
98Master dbt (data build tool) for analytics engineering with model organization, testing, documentation, and incremental strategies. Use when building data transformations, creating data models, or implementing analytics engineering best practices.
Data Engineer
94Build scalable data pipelines, modern data warehouses, and real-time streaming architectures. Implements Apache Spark, dbt, Airflow, and cloud-native data platforms.
Migrate Validate
100Validate pending migrations for foreign key consistency, rollback safety, and best practices
Sql Optimization
100Universal SQL performance optimization assistant for comprehensive query tuning, indexing strategies, and database performance analysis across all SQL databases (MySQL, PostgreSQL, SQL Server, Oracle). Provides execution plan analysis, pagination optimization, batch operations, and performance monitoring guidance.
DBHub Database Query Guide
100Anleitung zum Abfragen von Datenbanken über den DBHub MCP-Server. Verwenden Sie diese Fähigkeit immer dann, wenn Sie Datenbankschemata untersuchen, Tabellen inspizieren oder SQL-Abfragen über die MCP-Tools von DBHub ausführen müssen (search_objects, execute_sql). Aktiviert bei jeder Datenbankabfrageaufgabe, Schemadeckung, Datenabfrage oder SQL-Ausführung über MCP – auch wenn der Benutzer nur „Datenbank prüfen“ oder „mir Daten finden“ sagt. Diese Fähigkeit stellt sicher, dass Sie dem richtigen Workflow „zuerst erkunden“ folgen, anstatt Tabellenstrukturen zu erraten.
Dsql
100Build with Aurora DSQL — manage schemas, execute queries, handle migrations, diagnose query plans, and develop applications with a serverless, distributed SQL database. Covers IAM auth, multi-tenant patterns, MySQL-to-DSQL migration, DDL operations, query plan explainability, and SQL compatibility validation. Triggers on phrases like: DSQL, Aurora DSQL, create DSQL table, DSQL schema, migrate to DSQL, distributed SQL database, serverless PostgreSQL-compatible database, DSQL query plan, DSQL EXPLAIN ANALYZE, why is my DSQL query slow.