orchestration-test-gen

Generate validation and regression tests for SQL orchestration processes.

1|1|Updated Apr 15, 2026

Search Tags:#automation #testing #database #migration #sql #etl #snowflake

Ready to run

npx skills add https://github.com/Snowflake-Labs/cortex-code-migrations --skill orchestration-test-gen

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: orchestration-test-gen
Source: https://github.com/Snowflake-Labs/cortex-code-migrations/tree/main/plugin/skills/migration/migrate-objects/actions/migrate-etl-package/orchestration-test-gen
Command: npx skills add https://github.com/Snowflake-Labs/cortex-code-migrations --skill orchestration-test-gen

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill streamlines the creation and execution of functional tests for SQL orchestration components, ensuring reliable ETL workflows.

Core Features & Use Cases

Test Generation: Automatically produces setup, seed, act, and assertion scripts based on source definitions.
Execution & Validation: Runs tests directly against Snowflake, verifying behavior matches source logic before fixes.
Use Case: Enables database engineers to systematically test orchestration SQL graph components, detect regressions, and improve reliability during migration efforts.

Quick Start

Use the orchestration test generator to produce validation scripts for a set of ETL tasks in your project.

Frequently Asked Questions about orchestration-test-gen

High-intent search queries and answers about installing and using this skill.

FAQPage Schema

How do I automate validation and regression tests for SQL orchestration processes?▼

Automating SQL orchestration tests involves generating setup, seed, act, and assertion scripts based on source definitions to verify ETL behavior. This Skill produces those test artifacts and runs them directly against Snowflake to detect regressions during database migrations.

What is the best way to verify source logic fidelity across database migration workflows?▼

Verifying source logic fidelity during database migrations requires executing functional tests that compare output behavior against original definitions. This Skill generates and runs validation scripts against Snowflake, ensuring your ETL workflows maintain reliable behavior before applying fixes.

Do I need Python 3.11 and Snowflake connection privileges to run ETL pipeline verification tests?▼

Yes, running ETL pipeline verification tests requires Python 3.11 or higher and Snowflake connection privileges. These prerequisites allow the tool to automatically create, execute, and validate test artifacts directly within your Snowflake environment.

Can I test orchestration SQL graph components systematically during ETL pipeline automation?▼

Yes, you can test orchestration SQL graph components systematically by generating targeted validation scripts for each ETL task. This process validates behavior and detects regressions across your automation workflows, improving overall database migration reliability.

Why does database migration testing require generating separate setup, seed, act, and assertion scripts?▼

Database migration testing requires separate setup, seed, act, and assertion scripts to isolate test stages and validate specific ETL behavior accurately. This structured approach ensures source logic fidelity by systematically verifying each orchestration component against expected outcomes.

When should I not use automated test generation for database orchestration components?▼

Automated test generation for database orchestration components is not suitable when lacking the required Python 3.11 environment or Snowflake connection privileges. Without direct database access to create and execute test artifacts, the validation scripts cannot run or verify behavior.