snowflake-labs
- 305 skills
- 0 followers
- 54 repo stars
- 2 days ago last updated
- ▌ Manage Zerocopy Sapbdc · snowflake-labs bundleManage the end-to-end lifecycle of the Snowflake and SAP BDC Zero-Copy Integration and connector. Use when: consuming SAP data products in Snowflake, publishing Snowflake databases to SAP BDC with minimal CSN (v1.0, SDK-compatible), analyzing shared SAP data, or troubleshooting SAP BDC connector issues. This version uses MINIMAL CSN generation only (no options, no reviews, no validation loops). Triggers: SAP BDC, SAP connector, minimal CSN, SDK CSN, zerocopy connector, SAP data product, SAP BDC Connect, SAP publish, SAP share, SAP troubleshoot.
- ▌ Ontology Stack Builder · snowflake-labs bundleUse for ALL requests that mention: ontology, knowledge graph, semantic layer from schema, ontology-on-snowflake, abstract views, ontology metadata tables, KG_NODE, KG_EDGE, build ontology stack, generate ontology from tables, ontology layer generation, map tables to ontology, generate cortex agent config. Triggers: build ontology, create ontology stack, schema-to-ontology, OWL import, knowledge graph on snowflake, create semantic models from schema. Do NOT use for: simple semantic view creation (use semantic-view skill), standalone Cortex Agent creation (use cortex-agent skill).
- ▌ Semantic View Patterns · snowflake-labs bundleUse when learning Snowflake Semantic View patterns, teaching SV concepts, applying patterns to existing SVs, or building new SVs with best practices. Triggers: semantic view patterns, sv patterns, walk me through, time intelligence, range join, ASOF join, semi-additive, window metrics, derived metrics, role playing dimensions, accumulating snapshot, sv diagnostics, fan trap, USING clause, NON ADDITIVE BY.
- ▌ Setup Openflow Privatelink · snowflake-labs bundleUse when configuring private connectivity from Snowflake OpenFlow (running on SPCS) to AWS-hosted or on-premises data sources via AWS PrivateLink. Covers NLB + VPC Endpoint Service on AWS, then SYSTEM$PROVISION_PRIVATELINK_ENDPOINT, network rules, and External Access Integration on Snowflake. AWS only (Public Preview also exists on Azure but is out of scope here). Triggers: OpenFlow PrivateLink, SPCS private connectivity, NLB for OpenFlow, EAI for OpenFlow, SYSTEM$PROVISION_PRIVATELINK_ENDPOINT, OpenFlow RDS, OpenFlow MySQL, OpenFlow PostgreSQL, private ingestion OpenFlow, SPCS egress.
- ▌ Snowpark API · snowflake-labs bundleSnowpark Python API conversion path via the SMA CLI. Bundled sub-skill of `spark-migration`, invoked by the parent ONLY when the user explicitly asks for an SMA / Snowpark API rewrite (`snowflake.snowpark`, snake_case `with_column` / `group_by` / `session.create_dataframe`). Owns: SMA CLI detection, conversion, EWI dashboard, notebook migration, EWI fixer, stage conversion, DVP orchestration, and the API-side final summary. Use when: user explicitly asked for SMA / SMA CLI / Snowpark API / `snowflake.snowpark` rewrite, OR user wants to operate on an already-converted SMA output (open dashboard, fix EWIs, run stage conversion, resume DVP). Triggers: snowpark api, sma cli, sma conversion, run sma, snowflake.snowpark rewrite, snake_case snowpark, fix ewis, ewi fixer, sma dashboard, stage conversion, resume dvp, dvp orchestrator, already migrated sma.
- ▌ Deploy Notebook · snowflake-labs bundleDeploy a migrated Snowpark/SCOS project to Snowflake as a Notebook. Takes the .ipynb produced by the migration skill (plus its supporting project files), reminds the user to fix flagged code, uploads the whole project to a Snowflake stage, and creates the Notebook from the stage. Triggers: deploy notebook, deploy migrated notebook, create notebook from migration output, upload project to stage, deploy scos notebook, deploy snowpark notebook.
- ▌ Snowpark Connect · snowflake-labs bundleSnowpark Connect (SCOS) skills for migrating and validating PySpark, Spark Scala, and Spark Java workloads on Snowflake. Generates SMA-compatible reports (Issues.csv, InputFilesInventory.csv, ArtifactDependencyInventory.csv) using EWI codes (SPRKCNTPY* for Python, SPRKCNTSCL* for Scala/Java) for use with dvp-sma-dashboard-generator. Use when: migrating PySpark or Spark Scala/Java to Snowpark Connect, validating SCOS migrations, analyzing Spark compatibility, assessing a Spark workload before migration, producing a migration readiness report, or working with Snowpark Connect for Spark. Triggers: snowpark connect, scos, pyspark migration, spark connect, scala spark migration, java spark migration, spark java, validate migration, pyspark compatibility, scala compatibility, java compatibility, assess pyspark, assess spark, assess databricks, spark assessment, databricks assessment, migration readiness, spark workload assessment, pyspark readiness, spark compatibility report, analyze spark, analyze pyspark, analyz
- ▌ Deploy Code Bundle · snowflake-labs bundleDeploy a migrated Snowpark/SCOS project to Snowflake as a Code Bundle. Takes the migrated project (its .py entrypoint + supporting modules/config), reminds the user to fix flagged code, writes a code_bundle.yml spec, uploads the whole project to a Snowflake stage, and creates the Code Bundle from the stage — on a warehouse (default) or a compute pool. No .ipynb is involved. Triggers: deploy code bundle, deploy to code bundle, run as code bundle, create code bundle from migration output, execute code bundle, snow bundle.
- ▌ Well Architected Framework Assessment · snowflake-labs bundleUse when running a Snowflake Well-Architected Framework (WAF) assessment for a customer account. Three-tier scale: On Track / Needs Improvement / Needs Attention. Results displayed inline; optional HTML export. Triggers: WAF assessment, well-architected, architecture review, WAF review, security assessment, pillar assessment, security and governance, reliability, cost optimization, operational excellence, performance.
- ▌ Snowflake Notebook Migration · snowflake-labs bundleMigrates Databricks (DBX) notebooks to Snowflake Workspace notebooks. Preserves original code, only fixes incompatible patterns, flags unsupported features as migration notes. Use when: migrating Databricks notebooks, converting DBX notebooks to Snowflake, fixing Databricks-specific patterns. Triggers: migrate databricks, convert dbx, databricks to snowflake, dbx notebook, migrate notebook, databricks migration.
- ▌ Stage Conversion · snowflake-labs bundleReplace embedded file paths in SMA-converted Snowpark code. Use when: migrating Spark code via SMA, fixing file path references, updating storage locations, changing stage prefix. Triggers: replace embedded file paths, embedded file paths, file paths, SMA file paths, Snowpark paths, change stage prefix.
- ▌ Dvp Ewi Fixer · snowflake-labs bundleScan .py, .ipynb, and .scala files for SMA (Snowpark Migration Accelerator) EWI codes and resolve them. Triggers: fix EWIs, resolve SPRKPY, resolve SPRKSCL, resolve PNDSPY, SMA warnings, migration issues, Scala migration.
- ▌ Dvp Test Runner · snowflake-labsExecute generated pytest suites for source and migrated workloads. Fixes runability issues, ensures source tests pass, ensures migrated tests execute. Triggers: run tests, execute tests, validate migration, test runner.
- ▌ Dvp Code Adapter · snowflake-labsAdapt source and migrated workloads for testing: inject session parameters, add enableHiveSupport(), defer env vars, and record adapted_source in entrypoints.json. Status: design phase.
- ▌
- ▌ Dvp Asg Generation · snowflake-labs bundleGenerate Abstract Semantic Graph (ASG) from source code (PySpark or Scala) — a structured representation of data flow consumed by downstream DVP skills.
- ▌ Sma Dashboard Generator · snowflake-labs bundleGenerate interactive SMA dashboard to track EWIs from conversion. Triggers: sma dashboard, ewi tracker, track EWIs, conversion issues.
- ▌ Dvp Notebook To Script · snowflake-labs bundleConvert Jupyter notebooks to Python scripts for testing. Triggers: convert notebook, notebook to script, ipynb to py, databricks notebook.
- ▌ Dvp Migrated Test Fixer · snowflake-labsFix migrated Snowpark test code until all tests PASS (not just run). Uses git-based iteration to diagnose and resolve PySpark-to-Snowpark API incompatibilities. Triggers: fix migrated tests, make migrated tests pass, snowpark test errors, migration test failures.
- ▌ Assess Pyspark Workload · snowflake-labsStandalone assessment of PySpark and Databricks workloads for Snowflake SCOS compatibility. Produces a MigrationReadinessReport.html and AssessmentIR.json without committing to migration. Use when: analyzing Spark workload complexity, generating a migration readiness report, understanding migration effort before deciding, evaluating PySpark compatibility with SCOS, assessing a Databricks workload for Snowflake, or producing a pre-migration feasibility report.
- ▌ Dvp Io Schema Identifier · snowflake-labs bundleIdentify input and output data (files and tables) from source workloads and infer column schemas. Triggers: identify IO, find inputs outputs, map data flow, discover tables files, extract schema.
- ▌ Dvp Test Setup Generator · snowflake-labs bundleGenerate pytest files for source and migrated workloads based on entrypoints.json.
- ▌ Dvp Entrypoint Identifier · snowflake-labs bundleGenerate dvp/04-results/entrypoints.json from an ASG (Warp EntrypointDetector). Triggers: entrypoints, pipelines, entry point inventory.
- ▌ Migrate Pyspark To Snowpark API · snowflake-labsFresh PySpark → Snowpark API conversion via the SMA CLI. Bundled sub-skill of `snowpark-api`, loaded only after the parent has determined that the user wants a NEW SMA conversion (intent=migrate, language=Python). Owns SMA CLI detection, the SMA invocation itself, progress monitoring, and SMA output-layout resolution. Delegates the entire post-conversion tail to `validate-pyspark-to-snowpark-api`.
- ▌ Dvp Synthetic Data Generator · snowflake-labs bundleGenerate synthetic test data (CSV files) for all pipeline inputs based on data_io_schema.json and optionally the ASG for constraints and relationships.
- ▌ Validate Pyspark To Snowpark API · snowflake-labsPost-conversion pipeline owner for the Snowpark API path. Bundled sub-skill of `snowpark-api`. Loaded by `migrate-pyspark-to-snowpark-api` after a fresh SMA run, AND directly by `snowpark-api/SKILL.md` when the user wants to operate on an already-migrated SMA output. Owns: git init, EWI dashboard, notebook migration, EWI fixer, stage conversion, DVP orchestrator (steps 1–13), dashboard re-open, and the final summary. Also the entry point for individual API-side operations. Triggers (when invoked directly): already migrated, fix ewis, open sma dashboard, run stage conversion, resume dvp, dvp orchestrator, ewi fixer.
- ▌ Migrate Pyspark To Snowpark Connect · snowflake-labs bundleMigrate PySpark and Databricks workloads to Snowflake SCOS (Snowpark Connect for Spark). Use when: converting Spark code to run on Snowflake, analyzing PySpark compatibility, updating imports to Spark Connect equivalents, or migrating from Databricks. Generates SCOS-compatible reports (Issues.csv, InputFilesInventory.csv, ArtifactDependencyInventory.csv) for the dvp-scos-dashboard-generator using official SCOS EWI codes (SPRKCNTPY*). Triggers: migrate pyspark, convert spark, scos migration, spark connect, pyspark compatibility, snowpark connect.
- ▌ Validate Pyspark To Snowpark Connect · snowflake-labs bundleValidate a completed PySpark to Snowpark Connect migration across an entire workload. Surveys every entrypoint, weights each by table complexity, groups them into semantic sections, packs them into balanced batches, and runs a pool of dedicated SDK worker sessions (one per batch) that each validate one batch in an isolated git worktree (original on local PySpark + Delta vs migrated on real Snowpark Connect / SCOS). Consolidates the migration fixes onto the deliverable branch and produces a merged validation report. Use for SCOS validation, migration verification, entrypoint parity checks, and documenting remaining divergences or manual-review cases. Triggers: validate scos, verify migration, run scos test suite.
- ▌ Migrate Spark Java To Snowpark Connect · snowflake-labs bundleMigrate Spark Java workloads to Snowflake SCOS (Snowpark Connect for Spark). Use when: converting Java Spark code to run on Snowflake, analyzing Java Spark compatibility, updating imports to Spark Connect equivalents, or migrating from standalone Spark Java. Generates SMA-compatible reports (Issues.csv, InputFilesInventory.csv, ArtifactDependencyInventory.csv) for the dvp-sma-dashboard-generator using official SMA EWI codes (SPRKCNTSCL* — JVM family). Triggers: migrate java spark, convert java spark, scos java migration, spark connect java, java compatibility, snowpark connect java.
- ▌ Migrate Spark Scala To Snowpark Connect · snowflake-labs bundleMigrate Spark Scala workloads to Snowflake SCOS (Snowpark Connect for Spark). Use when: converting Scala Spark code to run on Snowflake, analyzing Scala Spark compatibility, updating imports to Spark Connect equivalents, or migrating from standalone Spark Scala. Generates SMA-compatible reports (Issues.csv, InputFilesInventory.csv, ArtifactDependencyInventory.csv) for the dvp-sma-dashboard-generator using official SMA EWI codes (SPRKCNTSCL*). Triggers: migrate scala spark, convert scala, scos scala migration, spark connect scala, scala compatibility, snowpark connect scala.
- ▌ Validate Spark Java To Snowpark Connect · snowflake-labs bundleValidate a completed Spark Java to Snowpark Connect (SCOS) migration by surveying the workload, asking the user to choose up to 10 entrypoints, synthesizing mock data, provisioning isolated test schemas, running the original workload on local Spark + Delta, running the migrated workload on real Snowpark Connect / SCOS, and comparing end-state snapshots. Use for SCOS validation, migration verification, entrypoint parity checks, and documenting remaining divergences or manual-review cases. Triggers: validate java scos, verify java migration, run java scos test suite, validate spark java, check java migration, test java migration correctness.
- ▌ Validate Spark Scala To Snowpark Connect · snowflake-labs bundleValidate a completed Spark Scala to Snowpark Connect (SCOS) migration across an entire workload. Surveys every entrypoint, weights each by table complexity, optionally scopes to a subset, packs balanced batches, synthesizes mock data, provisions isolated test schemas, runs the original workload on local Spark + Delta, runs the migrated workload on real Snowpark Connect / SCOS, and compares end-state snapshots. Use for SCOS validation, migration verification, entrypoint parity checks, and documenting remaining divergences or manual-review cases. Triggers: validate scala scos, verify scala migration, run scala scos test suite, validate spark scala, check scala migration, test scala migration correctness.
- ▌
- ▌
- ▌ Setup · snowflake-labs bundleSet up a migration project — connect to source, initialize, extract objects, convert, and assess. Covers steps 1-5 of the migration lifecycle.
- ▌
- ▌ Assessment · snowflake-labs bundleAnalyzes workloads to be migrated to Snowflake using SnowConvert assessment reports. Routes to specialized sub-skills for high-quality assessments. Use this skill when user wants to do an assessment of their code or ETL workload, waves generation, object exclusion, effort estimates, anti-patterns, discovery (SQL Server), sql dynamic and/or ETL analysis (SSIS)
- ▌
- ▌
- ▌
- ▌ Powerbi Repointing · snowflake-labsRepoint Power BI `.pbit` reports to Snowflake during conversion. Collects the `.pbit` folder path from the user and supplies the `--powerbi-repointing` flag for `scai code convert`. Load from `convert` or `code-conversion-only` only when the user confirms they have `.pbit` files.
- ▌
- ▌ Data Infrastructure Setup · snowflake-labs bundleShared infrastructure setup for data migration and data validation — prerequisites, compute pool, worker config, and source database/schema capture.
- ▌ Register Code Units · snowflake-labsRegister source code into the migration project — either by extracting from a live database or importing local SQL files.
- ▌ Data Strategy · snowflake-labsCapture the data migration + validation strategy (migration type, sync strategy, extraction strategy, target table type; validation type + sync strategy) by driving the data-migration-setup and data-validation-setup wizards to completion.
- ▌ Code Conversion Only · snowflake-labsConvert local source code to Snowflake SQL for code-conversion-only source systems such as Sybase IQ, Azure Synapse, Spark SQL, Databricks SQL, Greenplum, Netezza, Vertica, and Hive. Optionally repoints Power BI reports. Use when configure returns project_type code_conversion_only for these sources.
- ▌ Data Validation Setup · snowflake-labs bundleOne-time infrastructure setup for cloud data validation — verify the orchestrator service is ready after the shared infrastructure step.
- ▌ Discover Extras · snowflake-labs bundleSurface assets the conversion engine doesn't generate (FiveTran, dbt, Airflow, SSAS cubes, Oracle PL/SQL packages, custom shell scripts, etc.) and register them as code units with `kind=custom` and a free-form `customKind` discriminator (any string outside the reserved Kind enum) so the orchestration layer (next_object + state machine) tracks them alongside built-in units. Triggers from the setup state machine as its last step; can also be re-entered any time the user identifies more custom assets.
- ▌ Anti Patterns · snowflake-labsFlags migration anti-patterns (performance, architecture/security, behavior) by running `scai assessment anti-patterns`, which buckets SnowConvert's recorded issue codes and writes JSON for the assessment multi-report. Supports SQL Server and Redshift.
- ▌ Powerbi Fixer · snowflake-labs bundleComplete SnowConvert Power BI repointing by fixing unsupported queries using LLM-based translation. Triggers: finish repointing, complete pbit migration, fix unsupported queries, power bi snowflake migration.
- ▌ Assess Sas Migration · snowflake-labs bundlePreview. Assess SAS migration complexity and volume for Snowflake. Produces portfolio analysis with tier distribution, complexity heatmap, dependency DAG, a migration wave plan, and (on request) a separate effort/staffing plan. Triggers: assess SAS, SAS assessment, migration complexity, SAS analysis, SAS dependency diagram, migration waves, migration phases, migration sizing, LOE estimate SAS, SAS volume analysis, SAS migration readiness.
- ▌ Etl Assessment · snowflake-labs bundleAnalyze SSIS packages from SnowConvert ETL.* outputs and source .dtsx files. Classifies packages, scores migration complexity, and produces JSON for the parent assessment multi-report.
- ▌
- ▌ Effort Estimate · snowflake-labsGenerates migration effort estimates by running `scai assessment effort-estimate`, which writes JSON for the assessment multi-report. Supports SQL Server and Redshift.
- ▌ SQL Migration Waves Generator · snowflake-labs bundleAnalyze SQL object dependencies and create deployment waves/partitions for database migrations. Use when working with SQL migration planning, SnowConvert outputs, or deployment wave creation.
- ▌
- ▌
- ▌ Migrate Etl · snowflake-labsStabilize an ETL code unit (SSIS, Informatica, or other platforms) by handing the converted artifacts off to etl-stabilization and recording the result on the registry entry.
- ▌
- ▌ Workload Insights · snowflake-labs bundleBuilds SQL Server Discovery from Extended Events `.xel` files by running `scai assessment workload-insights --input <file>`. SQL Server only. Reads captures in place.
- ▌
- ▌ Data Infrastructure Teardown · snowflake-labsCost-saving teardown for shared data infrastructure — verify no in-flight workflows, then call data_infrastructure(mode="down") to stop/suspend orchestrator and worker (SPCS or local, as configured). The compute pool auto-suspends. Invoked after every migrate_data() / validate_data() cycle and at end-of-migration.
- ▌ Convert Sas To Snowflake · snowflake-labs bundlePreview. Convert SAS code to Snowflake SQL and stored procedures. Use for: DATA steps, PROC SQL, macros, PROC steps, EGP projects (extracted .sas files only). Triggers: convert SAS, migrate SAS, SAS to Snowflake, translate SAS code, SAS migration, SAS analysis, SAS dependency diagram, validate SAS conversion. Note: For .egp files, extract the embedded .sas code first using SAS Enterprise Guide export.
- ▌
- ▌ Register Sas Source Units · snowflake-labsPreview. Populate the Code Unit Registry (CUR) from SAS source files so the scai test harness can see them. Writes one registry/<id>.json per SAS file (source-side) into the conversion output_dir, skill-side JSON only — no SnowConvert dialect, no .NET registry engine. Triggers: register SAS units, populate CUR from SAS, add SAS to code unit registry, make SAS testable, scai test SAS, register SAS source.
- ▌
- ▌
- ▌
- ▌ Migrate Object · snowflake-labs bundleCore migration loop for a single stored procedure, function, or BTEQ script. Iterates deploy -> test -> diagnose -> fix until Snowflake output matches source.
- ▌ Snowflake Connection · snowflake-labsChoose and configure a Snowflake target authenticator. Use when creating or repairing a Snowflake connection, especially Microsoft Entra ID / Azure AD / OIDC SSO, or when `externalbrowser` fails against an OIDC IdP.
- ▌
- ▌
- ▌
- ▌ Register Sas Converted Units · snowflake-labsPreview. Attach converted Snowflake SQL to existing SAS Code Unit Registry entries so scai test can validate them. Reads conversion_state.json, sets files.converted + confirms objectType from the generated SQL, stamps codeStatus.conversion. Skill-side JSON only — no SnowConvert dialect, no .NET registry engine. Triggers: attach converted SAS SQL, register converted SAS, complete SAS CUR, make converted SAS testable, scai test SAS validate.
- ▌ Informatica Assessment · snowflake-labs bundleAnalyze Informatica Power Center workflows/mappings from SnowConvert ETL.* outputs and source XML files. Classifies workflows, scores migration complexity, and produces JSON for the parent assessment multi-report.
- ▌
- ▌ Migrate Sas7bdat To Snowflake · snowflake-labs bundlePreview. Bulk-load .sas7bdat files from a Snowflake stage into tables, entirely server-side. Use whenever the user wants to ingest, load, or migrate SAS datasets (.sas7bdat) sitting in cloud storage / a stage into Snowflake, whether a one-time load or an ongoing scheduled pipeline. Triggers: load sas7bdat, bulk load sas, ingest sas files from stage, sas7bdat to snowflake, migrate sas datasets, schedule sas load, sas directory table.
- ▌ Rule Engine Search · snowflake-labsFind applicable migration rules for a SQL file using Snowflake. Combines regex pattern matching (REGEXP_LIKE) with Cortex semantic search.
- ▌
- ▌ Etl Aifirst · snowflake-labs bundleAI-First convert path for ETL platforms SnowConvert does not natively support. Identifies elements, hydrates IR, runs verification gates, and emits dbt output with honest degradation exit codes. Use when convert routes unsupported ETL to the AI-first migrator. Sibling of etl-stabilization (post-convert repair).
- ▌
- ▌ Etl Seed · snowflake-labsSeed the per-unit ETL test YAML for a deployed ETL code unit by running `scai test seed` (which fills pipeline + validation.tables from the CUR), then fill index_columns and have the user confirm before the live comparison runs.
- ▌ Object Exclusion Detection · snowflake-labs bundleIdentify database objects that can be excluded from migration (temporary/staging, deprecated/legacy, testing, duplicates, version conflicts) by running the SCAI assessment object-exclusion command.
- ▌
- ▌ Compute Pool Setup · snowflake-labsGuide the user through creating and configuring a Snowpark Container Services compute pool for the migration orchestrator.
- ▌ Worker Local Setup · snowflake-labsInstall and start the Data Exchange Worker on a user-managed machine (laptop, cloud VM, or on-prem server).
- ▌ Data Migration Setup · snowflake-labs bundleSetup, run, and report on cloud data migration — workflow YAML, migrate_data run, background Monitor, and end-of-run summary for the user.
- ▌
- ▌
- ▌ Etl Validate · snowflake-labsRun scai test etl-validate to compare live ETL pipeline output (SSIS/Informatica natively, any platform via an external_command opt-in) against the converted Snowflake output. The CLI stamps codeStatus.etlValidate — do not invent advance outcomes.
- ▌ SQL Dynamic Pattern Analyzer · snowflake-labs bundleAnalyzes Dynamic SQL occurrences from SnowConvert issues, classifies patterns, scores complexity, and records migration considerations. Use for SQL Server, Redshift, Oracle, or Teradata to Snowflake migrations. Driven entirely by `scai assessment sql-dynamic`; no custom scripts.
- ▌ Etl Stabilization · snowflake-labs bundlePhase-based orchestrator for fixing SnowConvert ETL conversion gaps in ETL-to-Snowflake migrations (SSIS, Informatica, and other platforms). Analyzes units holistically, creates a ROADMAP with test strategies, and executes fixes through phased TDD with cross-phase learning. Use when user says "fix ETL unit", "fix SSIS conversion", "fix Informatica conversion", "resume ETL fixing", "run next phase", or when processing a converted ETL unit folder containing orchestration SQL, optional dbt sub-projects, and the original source definition file (e.g., DTSX for SSIS, XML for Informatica). Do NOT use for non-ETL migrations or greenfield dbt projects.
- ▌ Resolving Ewis · snowflake-labs bundle**[REQUIRED]** Invoke this skill FIRST before resolving ANY SnowConvert EWI (Errors, Warnings, Issues) codes. DO NOT attempt to fix EWIs manually - always invoke this skill first. Triggers: SSC-EWI, SSC-FDM, EWI code, resolve EWI, fix EWI, SnowConvert error.
- ▌ Worker Distributed Setup · snowflake-labsRun multiple Data Exchange Workers on separate VMs or servers, using affinity so each worker only processes the workflow it belongs to.
- ▌ Seed Script · snowflake-labsUse when the migration state machine emits the `seedScript` task for a BTEQ script unit (`kind: "script"`, `source.format: "bteq"`), before baseline capture.
- ▌ Synthetic Seeder · snowflake-labs bundleGenerate two-sided synthetic data tests (source + Snowflake) for migrated stored procedures and functions. Derives test scenarios from source SQL branch analysis, writes step-based validation YAML artifacts, and enriches them with isolation metadata. Use when generating or refreshing test cases for a migrated object. Delegates object repair to migrate-object. Triggers: generate tests, create tests, write test YAML, test generation, synthetic tests.
- ▌ Testbed Generator · snowflake-labs bundleDrive the workload-scoped Synthetic Testbed Generator through its MINE → VALIDATE → ENRICH → COMPILE → GENERATE phases for a migration. Sequences `scai testbed init` → `list-unsolved` (mine) and surfaces the categorized unsolved-constraint view; `scai testbed validate` and surfaces the readiness view (fk gaps / type conflicts / unsatisfied constraints); `scai testbed compile` and surfaces the cluster summary; runs the two-pass ENRICH reasoning (structural then value prompts) that turns unsolved constraints into enrichment JSON; `scai testbed generate` (readiness-gated) and surfaces the row counts + CSV/manifest deliverable. Resumes each phase after a kill by recomputing from on-disk state. Reads machine-readable JSON views; mutates state only through scai testbed subcommands, never the opaque state.bin. Triggers: generate testbed, mine testbed, validate testbed, compile testbed, enrich testbed, run testbed phases, resume testbed, inspect unsolved constraints, testbed data source. Runs the two-pass ENRICH phas
- ▌ Dbt Fixer · snowflake-labsFix dbt models via iterative compile-fix loop. Scoped to dbt projects assigned to the current phase. Use when the stabilization skill invokes dbt fixing.
- ▌ Proc Fixer · snowflake-labs bundleRepair the defective blocks of ONE converted Informatica-to-Snowflake-Scripting mapping procedure by reconstructing each block's SQL from the source transformation node, block-scoped and minimal-change, then deploy+CALL and grade against the source-derived assertions until the procedure creates clean and passes. Use when the stabilization skill invokes fixing for a scripting-flavor mapping procedure.
- ▌ Validate Sas Conversion · snowflake-labsPreview. Validate a completed SAS to Snowflake conversion by comparing expected SAS output against actual converted SQL output using synthetic test data. Performs dual-execution comparison: LLM traces original SAS logic to produce baseline, then runs converted SQL on Snowflake and compares outputs cell-by-cell. Triggers: validate conversion, verify sas migration, test conversion, compare sas output.