all publishers

snowflake-labs

@snowflake-labs source repo

305 published skills · page 3 of 4

  1. ▌
    Manage Zerocopy Sapbdc · snowflake-labs bundle
    Manage 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.
    54 repo stars
  2. ▌
    Ontology Stack Builder · snowflake-labs bundle
    Use 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).
    54 repo stars
  3. ▌
    Semantic View Patterns · snowflake-labs bundle
    Use 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.
    54 repo stars
  4. ▌
    Setup Openflow Privatelink · snowflake-labs bundle
    Use 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.
    54 repo stars
  5. ▌
    Snowpark API · snowflake-labs bundle
    Snowpark 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.
    54 repo stars
  6. ▌
    Deploy Notebook · snowflake-labs bundle
    Deploy 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.
    54 repo stars
  7. ▌
    Snowpark Connect · snowflake-labs bundle
    Snowpark 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
    54 repo stars
  8. ▌
    Deploy Code Bundle · snowflake-labs bundle
    Deploy 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.
    54 repo stars
  9. ▌
    Well Architected Framework Assessment · snowflake-labs bundle
    Use 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.
    54 repo stars
  10. ▌
    Snowflake Notebook Migration · snowflake-labs bundle
    Migrates 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.
    54 repo stars
  11. ▌
    Stage Conversion · snowflake-labs bundle
    Replace 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.
    54 repo stars
  12. ▌
    Dvp Ewi Fixer · snowflake-labs bundle
    Scan .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.
    54 repo stars
  13. ▌
    Dvp Test Runner · snowflake-labs
    Execute 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.
    54 repo stars
  14. ▌
    Dvp Code Adapter · snowflake-labs
    Adapt source and migrated workloads for testing: inject session parameters, add enableHiveSupport(), defer env vars, and record adapted_source in entrypoints.json. Status: design phase.
    54 repo stars
  15. ▌
    Dvp Orchestrator · snowflake-labs bundle
    ---
    54 repo stars
  16. ▌
    Dvp Asg Generation · snowflake-labs bundle
    Generate Abstract Semantic Graph (ASG) from source code (PySpark or Scala) — a structured representation of data flow consumed by downstream DVP skills.
    54 repo stars
  17. ▌
    Sma Dashboard Generator · snowflake-labs bundle
    Generate interactive SMA dashboard to track EWIs from conversion. Triggers: sma dashboard, ewi tracker, track EWIs, conversion issues.
    54 repo stars
  18. ▌
    Dvp Notebook To Script · snowflake-labs bundle
    Convert Jupyter notebooks to Python scripts for testing. Triggers: convert notebook, notebook to script, ipynb to py, databricks notebook.
    54 repo stars
  19. ▌
    Dvp Migrated Test Fixer · snowflake-labs
    Fix 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.
    54 repo stars
  20. ▌
    Assess Pyspark Workload · snowflake-labs
    Standalone 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.
    54 repo stars
  21. ▌
    Dvp Io Schema Identifier · snowflake-labs bundle
    Identify 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.
    54 repo stars
  22. ▌
    Dvp Test Setup Generator · snowflake-labs bundle
    Generate pytest files for source and migrated workloads based on entrypoints.json.
    54 repo stars
  23. ▌
    Dvp Entrypoint Identifier · snowflake-labs bundle
    Generate dvp/04-results/entrypoints.json from an ASG (Warp EntrypointDetector). Triggers: entrypoints, pipelines, entry point inventory.
    54 repo stars
  24. ▌
    Migrate Pyspark To Snowpark API · snowflake-labs
    Fresh 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`.
    54 repo stars
  25. ▌
    Dvp Synthetic Data Generator · snowflake-labs bundle
    Generate synthetic test data (CSV files) for all pipeline inputs based on data_io_schema.json and optionally the ASG for constraints and relationships.
    54 repo stars
  26. ▌
    Validate Pyspark To Snowpark API · snowflake-labs
    Post-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.
    54 repo stars
  27. ▌
    Migrate Pyspark To Snowpark Connect · snowflake-labs bundle
    Migrate 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.
    54 repo stars
  28. ▌
    Validate Pyspark To Snowpark Connect · snowflake-labs bundle
    Validate 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.
    54 repo stars
  29. ▌
    Migrate Spark Java To Snowpark Connect · snowflake-labs bundle
    Migrate 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.
    54 repo stars
  30. ▌
    Migrate Spark Scala To Snowpark Connect · snowflake-labs bundle
    Migrate 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.
    54 repo stars
  31. ▌
    Validate Spark Java To Snowpark Connect · snowflake-labs bundle
    Validate 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.
    54 repo stars
  32. ▌
    Validate Spark Scala To Snowpark Connect · snowflake-labs bundle
    Validate 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.
    54 repo stars
  33. ▌
    Migration · snowflake-labs bundle
    Database Migration to Snowflake
    54 repo stars
  34. ▌
    Sas · snowflake-labs bundle
    SAS → Snowflake (parallel track)
    54 repo stars
  35. ▌
    Setup · snowflake-labs bundle
    Set up a migration project — connect to source, initialize, extract objects, convert, and assess. Covers steps 1-5 of the migration lifecycle.
    54 repo stars
  36. ▌
    Convert · snowflake-labs
    Code Conversion
    54 repo stars
  37. ▌
    Assessment · snowflake-labs bundle
    Analyzes 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)
    54 repo stars
  38. ▌
    Tag Objects · snowflake-labs
    Tag objects
    54 repo stars
  39. ▌
    Migrate Objects · snowflake-labs bundle
    Migrate Objects
    54 repo stars
  40. ▌
    Validate Objects · snowflake-labs bundle
    Validate Objects
    54 repo stars
  41. ▌
    Powerbi Repointing · snowflake-labs
    Repoint 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.
    54 repo stars
  42. ▌
    Tableau Repointing · snowflake-labs
    Tableau Repointing (Oracle)
    54 repo stars
  43. ▌
    Data Infrastructure Setup · snowflake-labs bundle
    Shared infrastructure setup for data migration and data validation — prerequisites, compute pool, worker config, and source database/schema capture.
    54 repo stars
  44. ▌
    Register Code Units · snowflake-labs
    Register source code into the migration project — either by extracting from a live database or importing local SQL files.
    54 repo stars
  45. ▌
    Data Strategy · snowflake-labs
    Capture 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.
    54 repo stars
  46. ▌
    Code Conversion Only · snowflake-labs
    Convert 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.
    54 repo stars
  47. ▌
    Data Validation Setup · snowflake-labs bundle
    One-time infrastructure setup for cloud data validation — verify the orchestrator service is ready after the shared infrastructure step.
    54 repo stars
  48. ▌
    Discover Extras · snowflake-labs bundle
    Surface 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.
    54 repo stars
  49. ▌
    Anti Patterns · snowflake-labs
    Flags 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.
    54 repo stars
  50. ▌
    Powerbi Fixer · snowflake-labs bundle
    Complete 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.
    54 repo stars
  51. ▌
    Assess Sas Migration · snowflake-labs bundle
    Preview. 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.
    54 repo stars
  52. ▌
    Etl Assessment · snowflake-labs bundle
    Analyze SSIS packages from SnowConvert ETL.* outputs and source .dtsx files. Classifies packages, scores migration complexity, and produces JSON for the parent assessment multi-report.
    54 repo stars
  53. ▌
    Db2 Connection · snowflake-labs bundle
    DB2 Connection Skill
    54 repo stars
  54. ▌
    Effort Estimate · snowflake-labs
    Generates migration effort estimates by running `scai assessment effort-estimate`, which writes JSON for the assessment multi-report. Supports SQL Server and Redshift.
    54 repo stars
  55. ▌
    SQL Migration Waves Generator · snowflake-labs bundle
    Analyze SQL object dependencies and create deployment waves/partitions for database migrations. Use when working with SQL migration planning, SnowConvert outputs, or deployment wave creation.
    54 repo stars
  56. ▌
    Recommend Settings · snowflake-labs bundle
    Recommend Conversion Settings
    54 repo stars
  57. ▌
    Autonomous · snowflake-labs
    Migrate Objects — Autonomous
    54 repo stars
  58. ▌
    Migrate Etl · snowflake-labs
    Stabilize 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.
    54 repo stars
  59. ▌
    Rule Engine · snowflake-labs
    Rule Engine
    54 repo stars
  60. ▌
    Workload Insights · snowflake-labs bundle
    Builds SQL Server Discovery from Extended Events `.xel` files by running `scai assessment workload-insights --input <file>`. SQL Server only. Reads captures in place.
    54 repo stars
  61. ▌
    Oracle Connection · snowflake-labs bundle
    Oracle Connection Skill
    54 repo stars
  62. ▌
    Data Infrastructure Teardown · snowflake-labs
    Cost-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.
    54 repo stars
  63. ▌
    Convert Sas To Snowflake · snowflake-labs bundle
    Preview. 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.
    54 repo stars
  64. ▌
    Semantic Equivalence Checker · snowflake-labs bundle
    Semantic Equivalence Checker
    54 repo stars
  65. ▌
    Register Sas Source Units · snowflake-labs
    Preview. 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.
    54 repo stars
  66. ▌
    Bigquery Connection · snowflake-labs bundle
    BigQuery Connection Skill
    54 repo stars
  67. ▌
    Redshift Connection · snowflake-labs bundle
    Redshift Connection Skill
    54 repo stars
  68. ▌
    Teradata Connection · snowflake-labs bundle
    Teradata Connection Skill
    54 repo stars
  69. ▌
    Migrate Object · snowflake-labs bundle
    Core migration loop for a single stored procedure, function, or BTEQ script. Iterates deploy -> test -> diagnose -> fix until Snowflake output matches source.
    54 repo stars
  70. ▌
    Snowflake Connection · snowflake-labs
    Choose 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.
    54 repo stars
  71. ▌
    Worker Spcs · snowflake-labs
    Worker Setup — SPCS
    54 repo stars
  72. ▌
    Postgresql Connection · snowflake-labs bundle
    PostgreSQL Connection Skill
    54 repo stars
  73. ▌
    SQL Server Connection · snowflake-labs bundle
    SQL Server Connection Skill
    54 repo stars
  74. ▌
    Register Sas Converted Units · snowflake-labs
    Preview. 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.
    54 repo stars
  75. ▌
    Informatica Assessment · snowflake-labs bundle
    Analyze 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.
    54 repo stars
  76. ▌
    Apply · snowflake-labs bundle
    Rule Apply
    54 repo stars
  77. ▌
    Migrate Sas7bdat To Snowflake · snowflake-labs bundle
    Preview. 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.
    54 repo stars
  78. ▌
    Rule Engine Search · snowflake-labs
    Find applicable migration rules for a SQL file using Snowflake. Combines regex pattern matching (REGEXP_LIKE) with Cortex semantic search.
    54 repo stars
  79. ▌
    Add Code Units · snowflake-labs
    Add Local Source Code
    54 repo stars
  80. ▌
    Etl Aifirst · snowflake-labs bundle
    AI-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).
    54 repo stars
  81. ▌
    Extract · snowflake-labs
    Extract Rules
    54 repo stars
  82. ▌
    Etl Seed · snowflake-labs
    Seed 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.
    54 repo stars
  83. ▌
    Object Exclusion Detection · snowflake-labs bundle
    Identify database objects that can be excluded from migration (temporary/staging, deprecated/legacy, testing, duplicates, version conflicts) by running the SCAI assessment object-exclusion command.
    54 repo stars
  84. ▌
    Propagate · snowflake-labs
    Rule Propagation — Find Matching Code Units
    54 repo stars
  85. ▌
    Compute Pool Setup · snowflake-labs
    Guide the user through creating and configuring a Snowpark Container Services compute pool for the migration orchestrator.
    54 repo stars
  86. ▌
    Worker Local Setup · snowflake-labs
    Install and start the Data Exchange Worker on a user-managed machine (laptop, cloud VM, or on-prem server).
    54 repo stars
  87. ▌
    Data Migration Setup · snowflake-labs bundle
    Setup, run, and report on cloud data migration — workflow YAML, migrate_data run, background Monitor, and end-of-run summary for the user.
    54 repo stars
  88. ▌
    Extract Code Units · snowflake-labs
    Code Extraction
    54 repo stars
  89. ▌
    Worker K8S External · snowflake-labs
    Worker Kubernetes Setup — External Cluster
    54 repo stars
  90. ▌
    Etl Validate · snowflake-labs
    Run 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.
    54 repo stars
  91. ▌
    SQL Dynamic Pattern Analyzer · snowflake-labs bundle
    Analyzes 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.
    54 repo stars
  92. ▌
    Etl Stabilization · snowflake-labs bundle
    Phase-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.
    54 repo stars
  93. ▌
    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.
    54 repo stars
  94. ▌
    Worker Distributed Setup · snowflake-labs
    Run multiple Data Exchange Workers on separate VMs or servers, using affinity so each worker only processes the workflow it belongs to.
    54 repo stars
  95. ▌
    Seed Script · snowflake-labs
    Use when the migration state machine emits the `seedScript` task for a BTEQ script unit (`kind: "script"`, `source.format: "bteq"`), before baseline capture.
    54 repo stars
  96. ▌
    Synthetic Seeder · snowflake-labs bundle
    Generate 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.
    54 repo stars
  97. ▌
    Testbed Generator · snowflake-labs bundle
    Drive 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
    54 repo stars
  98. ▌
    Dbt Fixer · snowflake-labs
    Fix dbt models via iterative compile-fix loop. Scoped to dbt projects assigned to the current phase. Use when the stabilization skill invokes dbt fixing.
    54 repo stars
  99. ▌
    Proc Fixer · snowflake-labs bundle
    Repair 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.
    54 repo stars
  100. ▌
    Validate Sas Conversion · snowflake-labs
    Preview. 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.
    54 repo stars