How does this skill handle BigQuery parameters?

It uses the @name syntax combined with special comment annotations like '-- @name (string)' to define parameter names, types, and default values for Windmill compatibility.

Does this skill help with deployment?

Yes, it provides the specific CLI commands, such as 'wmill sync push', needed to deploy your local SQL scripts directly to a Windmill instance.

What metadata is generated by this skill?

The skill guides the use of 'wmill script generate-metadata' to create the necessary .script.yaml and .lock files that Windmill uses to manage script execution.

Can I discover existing resource types with this skill?

Yes, it includes instructions for using 'wmill resource-type list --schema' to find and use available BigQuery connection resources within your workspace.

Is this skill limited to SQL queries?

While focused on SQL scripts for BigQuery, it specifically manages the lifecycle of those scripts within the Windmill ecosystem, including metadata and synchronization.

BigQuery Script Writer for Windmill

Name: BigQuery Script Writer for Windmill
Author: windmill-labs

bywindmill-labs

0•

Database Management

Streamlines the creation, parameterization, and deployment of Google BigQuery SQL scripts for the Windmill orchestration platform.

This skill provides specialized assistance for developers writing BigQuery queries within a Windmill environment. It enforces the correct use of parameter syntax and type annotations, ensures that metadata and lock files are generated correctly via the Windmill CLI, and facilitates the deployment of production-ready data scripts. By integrating BigQuery best practices with Windmill's specific requirements, it helps automate data workflows and ensures seamless synchronization between local development and cloud execution.

Key Features

01Provides discovery commands for BigQuery resource types and schemas

02Enforces @name parameter syntax with specific type-comment mapping

030 GitHub stars

04Ensures SQL script standardization for data orchestration tasks

05Automates generation of .script.yaml and .lock files via Windmill CLI

06Streamlines the 'wmill sync push' deployment workflow

Use Cases

01Building automated data transformation pipelines in BigQuery scheduled via Windmill

02Creating parameterized SQL reports with type-safe inputs for internal dashboards

03Developing complex cloud-native data workflows that require seamless GCP integration

What are Skills?·How to Install

Install with 🐟 Skill.Fish

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

For use in Claude.ai and ChatGPT

Download Skill