MatillionPartnerEngineering

MatillionPartnerEngineering/Maiaupgrade-Public

Skill Claude CodeCodex

Detect and refactor hardcoded credentials (passwords, API keys, tokens, connection strings) embedded inside Python Script component bodies. Covers secrets extraction to DPC Secret Manager and code refactoring patterns.

MatillionPartnerEngineering/Maiaupgrade-Public

Skill Claude CodeCodex

Detect Python library compatibility issues in migrated scripts. Covers available vs unavailable packages in DPC Python Pushdown (Snowpark), legacy library upgrades (boto→boto3), and ODBC/driver limitations.

MatillionPartnerEngineering/Maiaupgrade-Public

Skill Claude CodeCodex

Python Script components migrate automatically via the Script Pushdown component on the Shared Script Runner; covers the exception cases (Python 2→3 / Jython cursor conversion), optional Python Pushdown, and DPC-specific Python gotchas (OOM, library persistence, grid payload limits) during Matillion ETL to DPC…

MatillionPartnerEngineering/Maiaupgrade-Public

Skill Claude CodeCodex

Detect and remediate structural validation errors in rds-query components migrated from Matillion ETL to DPC. Covers skipped component validation, credential conversion, and the validation-vs-runtime inconsistency.

MatillionPartnerEngineering/Maiaupgrade-Public

Skill Claude CodeCodex

Detect and guide remediation of S3-dependent components (S3 Load, Excel Query, SFTP) migrated from Matillion ETL that require AWS IAM credential configuration in DPC. Covers cloud credential setup, IAM role validation, and common access errors.

MatillionPartnerEngineering/Maiaupgrade-Public

Skill Claude CodeCodex

Salesforce Query and Salesforce Load component gotchas, authentication patterns, API selection, and migration guidance for Matillion ETL to DPC migration.

MatillionPartnerEngineering/Maiaupgrade-Public

Skill Claude CodeCodex

Identifies and fixes incorrectly formatted secret references in database-query components migrated from Matillion ETL (METL) to Data Productivity Cloud (DPC). Covers the secretReferenceNameId migration issue and the missing concurrencyMethod parameter.

MatillionPartnerEngineering/Maiaupgrade-Public

Skill Claude CodeCodex

Migrate Matillion ETL shared jobs to DPC shared pipelines, handling mappings, fan-in counts, and metlImplementationId references.

MatillionPartnerEngineering/Maiaupgrade-Public

Skill Claude CodeCodex

Detect and guide remediation of SNS Message components migrated from Matillion ETL that require AWS authentication configuration in DPC. Covers IAM role setup, topic ARN validation, and common failure patterns.

MatillionPartnerEngineering/Maiaupgrade-Public

Skill Claude CodeCodex

Customer-facing migration strategy and plan template — fill in per engagement with workload list, type-distribution, and timeline.

MatillionPartnerEngineering/Maiaupgrade-Public

Skill Claude CodeCodex

Phased test execution methodology for migrated workloads — entry point identification, execution order, failure classification, timeout handling, and result documentation.

MatillionPartnerEngineering/Maiaupgrade-Public

Skill Claude CodeCodex

Detect and convert unknown-orchestration components from Matillion ETL (METL) migration back to their proper DPC component types. Covers Excel Query conversion with a complete numeric-to-semantic parameter mapping, and provides an extensible framework for other component types.

MatillionPartnerEngineering/Maiaupgrade-Public

Skill Claude CodeCodex

Use when validating migrated pipelines, detecting refactor conditions, or running mass validation during Matillion ETL to DPC migration.

MatillionPartnerEngineering/Maiaupgrade-Public

Skill Claude CodeCodex

Use when refactoring variables, automatic variables, export variables, or system variables during Matillion ETL to DPC migration.

MatillionPartnerEngineering/Maiaupgrade-Public

Skill Claude CodeCodex

Weekly migration status update email template — populated by Maia for the FDE to send to the customer.

MatillionPartnerEngineering/Maiaupgrade-Public

Skill Claude CodeCodex

7-step sequence from dev validation through ETL decommission for production cutover. Use when planning or tracking the path from successful migration testing to live production deployment.

MatillionPartnerEngineering/Maiaupgrade-Public

Skill Claude CodeCodex

Three-phase secret management for migrations - Inventory, Create/Register, and Runtime Validate. Use when managing credentials during ETL-to-DPC migrations. A secret is not complete until a pipeline successfully authenticates with it.

MatillionPartnerEngineering/Maiaupgrade-Public

Skill Claude CodeCodex

The 6-layer cascade order for migration blockers - fixing one always reveals the next. Use when planning fix order or when a workload requires multiple sequential fixes to reach success.

MatillionPartnerEngineering/Maiaupgrade-Public

Skill Claude CodeCodex

Identify and fix weekend/legacy/v2 pipeline variants together to prevent re-discovering the same issues. Use when working on workloads that have scheduling variants or legacy copies.