PostgreSQL/Greenplum/Netezza to dbt Model Conversion

Purpose

Transform PostgreSQL/Greenplum/Netezza DDL (views, tables, stored procedures) into production-quality dbt models compatible with Snowflake, maintaining the same business logic and data transformation steps while following dbt best practices.

When to Use This Skill

Activate this skill when users ask about:

• Converting PostgreSQL/Greenplum/Netezza views or tables to dbt models
• Migrating PostgreSQL stored procedures to dbt
• Translating PostgreSQL syntax to Snowflake
• Generating schema.yml files with tests and documentation
• Handling PostgreSQL-specific syntax conversions (array expressions, CHAR padding, psql commands)