MatillionPartnerEngineering/Maiaupgrade-Public
Skill Claude CodeCodex
Decision tree for classifying migration blockers as configuration (15 min fix) vs code refactor (2-3 hrs). Use when diagnosing pipeline execution failures to determine the fastest resolution path. 73% of ETL-to-DPC blockers are configuration, not code.
MatillionPartnerEngineering/Maiaupgrade-Public
Skill Claude CodeCodex
How to identify and prioritize framework-level blockers that unblock 5-30 workloads with a single fix. Use when multiple workloads share the same error pattern or when planning fix order for maximum ROI.
MatillionPartnerEngineering/Maiaupgrade-Public
Skill Claude CodeCodex
Use when refactoring API Extract or API Query components during Matillion ETL to DPC migration.
MatillionPartnerEngineering/Maiaupgrade-Public
Skill Claude CodeCodex
Use when driving an imported area through the migration lifecycle — validate (PLAN), test (ACT + four-gate verdict), optimise, and sign-off — against the METL baseline.
MatillionPartnerEngineering/Maiaupgrade-Public
Skill Claude CodeCodex
Map Matillion ETL automatic variables to DPC system variables (jobid, projectid, environment) during migration.
MatillionPartnerEngineering/Maiaupgrade-Public
Skill Claude CodeCodex
Detect and convert Bash Script sleep/wait commands to Snowflake SYSTEM$WAIT() or DPC-compatible alternatives. Covers retry patterns, timed delays, and polling loops.
MatillionPartnerEngineering/Maiaupgrade-Public
Skill Claude CodeCodex
Use when migrating Bash Script components to DPC. Bash scripts migrate automatically via the Script Pushdown component on the Shared Script Runner; manual refactoring (or bring-your-own-VM Bash Pushdown) is the exception.
MatillionPartnerEngineering/Maiaupgrade-Public
Skill Claude CodeCodex
Escalation decision tree and blocker categorization for migration failures. Classifies blockers by priority, assigns ownership, and provides resolution playbooks for each category.
MatillionPartnerEngineering/Maiaupgrade-Public
Skill Claude CodeCodex
Use when refactoring Database Query, JDBC, dbt, or other connector components during Matillion ETL to DPC migration.
MatillionPartnerEngineering/Maiaupgrade-Public
Skill Claude CodeCodex
Detect and remediate partial grid variable definitions in Create Table components during Matillion ETL to DPC migration. Expands partial column-definition grids to full schema.
MatillionPartnerEngineering/Maiaupgrade-Public
Skill Claude CodeCodex
Pre-execution audit of all hardcoded credentials, passwords, and secret references across migrated pipelines. Produces a structured inventory and migration plan for DPC Secret Manager.
MatillionPartnerEngineering/Maiaupgrade-Public
Skill Claude CodeCodex
Template and methodology for creating, tracking, and resolving customer action items during migration. Includes priority framework, ownership assignment, and status tracking.
MatillionPartnerEngineering/Maiaupgrade-Public
Skill Claude CodeCodex
Migrate Database Query components to DPC, including JDBC driver setup, manifest configuration, and connection migration.
MatillionPartnerEngineering/Maiaupgrade-Public
Skill Claude CodeCodex
Use when refactoring Databricks-specific components like Extract Nested Data, Filter quoting issues, or Text Output during Matillion ETL to DPC migration.
MatillionPartnerEngineering/Maiaupgrade-Public
Skill Claude CodeCodex
Migrate dbt Core and Sync File Source components from METL to DPC, configuring repositories and dbt version compatibility.
MatillionPartnerEngineering/Maiaupgrade-Public
Skill Claude CodeCodex
Reference documentation for Matillion ETL to DPC migration — feature differences, upgrade notes, and component-by-component guide.
MatillionPartnerEngineering/Maiaupgrade-Public
Skill Claude CodeCodex
Component behaviour differences between METL and DPC — iterator ordering, Join/CALC drift, agent stability, Git integration, SQS gaps, and other known limitations.
MatillionPartnerEngineering/Maiaupgrade-Public
Skill Claude CodeCodex
DPC architecture dispatch tax, component execution overhead, and optimisation strategies for METL to DPC migration. Covers the systemic performance gap, IF component slowness, CIS message limits, and data sampling timeouts.
MatillionPartnerEngineering/Maiaupgrade-Public
Skill Claude CodeCodex
Detect and remediate hardcoded environment references (PRODUCTION database names, S3 paths, SNS topics) in migrated pipelines. Replace with parameterized variables or Environment Defaults.
MatillionPartnerEngineering/Maiaupgrade-Public
Skill Claude CodeCodex
Detect and remediate hardcoded credentials (passwords, usernames, connection strings) in migrated Matillion ETL pipelines. Identifies plaintext secrets that should be converted to DPC secret references or environment variables.
MatillionPartnerEngineering/Maiaupgrade-Public
Skill Claude CodeCodex
Pre-execution checklist for infrastructure dependencies — Snowflake schemas, control tables, network connectivity, IAM permissions, and external system access required before pipeline testing.
MatillionPartnerEngineering/Maiaupgrade-Public
Skill Claude CodeCodex
NetSuite connector gotchas, authentication patterns, driver management, and performance tuning for Database Query (SuiteAnalytics JDBC), NetSuite Query, and NetSuite SuiteAnalytics components during Matillion ETL to DPC migration.
MatillionPartnerEngineering/Maiaupgrade-Public
Skill Claude CodeCodex
Oracle-specific gotchas, performance tuning, and migration patterns for Database Query components during Matillion ETL to DPC migration. Covers fetch size, large table handling, data integrity, authentication, and the strategic shift toward native Oracle components.
MatillionPartnerEngineering/Maiaupgrade-Public
Skill Claude CodeCodex
PostgreSQL connector gotchas, driver behaviour, JSONB handling, case-sensitivity, and METL internal DB upgrade guidance during Matillion ETL to DPC migration.