Hive/Spark/Databricks to dbt Model Conversion

Purpose

Transform Hive/Spark/Databricks DDL (views, tables, UDFs) 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 Hive/Spark/Databricks views or tables to dbt models
• Migrating HiveQL UDFs to dbt
• Translating HiveQL syntax to Snowflake
• Generating schema.yml files with tests and documentation
• Handling Hive-specific syntax conversions (external tables, PARTITIONED BY, LATERAL VIEW, file formats)