How does this skill handle Snowflake parameters?

The skill uses a specific syntax where parameters are named in comments above the SQL statement (e.g., -- ? name (text)) and referenced using '?' placeholders.

What Windmill CLI commands are supported?

It supports 'wmill script generate-metadata' for creating configuration files and 'wmill sync push' for deploying scripts to the platform.

Why is this skill necessary for Snowflake queries in Windmill?

Windmill requires specific metadata and parameter formatting to correctly parse and execute SQL scripts; this skill ensures your code meets those standards.

Can I use this to find Snowflake resource types?

Yes, it utilizes 'wmill resource-type list --schema' to help you discover and integrate available resources into your scripts.

Snowflake Scripting for Windmill

Name: Snowflake Scripting for Windmill
Author: windmill-labs

bywindmill-labs

0•

Database Management

Streamlines the creation, parameterization, and deployment of Snowflake SQL scripts within the Windmill automation platform.

This skill provides specialized guidance for writing Snowflake queries tailored for the Windmill ecosystem. it ensures that scripts adhere to specific formatting requirements, such as using comment-based parameter definitions and positional placeholders. Beyond writing SQL, the skill assists with essential Windmill CLI workflows, including metadata generation, resource discovery, and script synchronization. By implementing these domain-specific patterns, developers can reliably build and deploy data warehouse automations that integrate seamlessly with Windmill's infrastructure.

Key Features

01Resource type schema discovery for Snowflake integrations

02Snowflake-specific SQL parameterization using comment-based naming

03Seamless script synchronization and deployment to Windmill

04Support for positional placeholders in Snowflake SQL statements

050 GitHub stars

06Automated metadata and lock file generation via wmill CLI

Use Cases

01Developing automated Snowflake data pipelines within Windmill workflows

02Parameterizing complex Snowflake queries for dynamic data reporting

03Synchronizing local Snowflake SQL scripts with remote Windmill instances

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add windmill-labs/windmill-claude-plugin write-script-snowflake

For use in Claude.ai and ChatGPT

Download Skill