How does this skill handle Vertica projections?

It identifies and removes projection specifications, as Snowflake automatically manages data storage and optimization without requiring manual projection definitions.

Can it convert Vertica stored procedures?

Yes, it breaks down complex procedural logic into modular, declarative dbt models using CTEs and appropriate materialization strategies.

Does it support Vertica flex tables?

It maps Vertica flex tables to Snowflake's VARIANT column type, allowing for seamless handling of semi-structured data.

Will it generate documentation for my models?

Absolutely; the skill automatically creates schema.yml files containing table descriptions, column metadata, and data quality tests.

Is the generated SQL optimized for Snowflake?

Yes, the skill uses Snowflake-specific syntax, suggests clustering keys when necessary, and applies explicit type casting for performance and clarity.

Vertica to dbt Snowflake Migration

Name: Vertica to dbt Snowflake Migration
Author: sfc-gh-dflippo

bysfc-gh-dflippo

•

Database Management

Automates the conversion of Vertica DDL into production-ready dbt models optimized for Snowflake Data Cloud.

This skill streamlines the migration process from Vertica to Snowflake by transforming legacy DDL, including views, tables, and stored procedures, into modular dbt code. It handles complex Vertica-specific syntax like projections and flex tables while ensuring data type compatibility and implementing dbt best practices such as automated testing and documentation generation. It is an essential tool for data engineers looking to modernize their data stack with minimal manual rewriting of SQL logic, providing clear explanations of architectural changes throughout the process.

Key Features

01Application of dbt best practices including materialization strategies and modular CTE patterns

02Generation of comprehensive schema.yml files with built-in tests and documentation

03Intelligent mapping of Vertica-specific data types and functions to Snowflake equivalents

0428 GitHub stars

05Transformation of procedural logic and flex tables into declarative SQL and VARIANT columns

06Automated conversion of Vertica views and tables to Snowflake-compatible dbt models

Use Cases

01Standardizing database DDL into a version-controlled dbt project with automated testing

02Migrating legacy Vertica data warehouses to the Snowflake Data Cloud using dbt

03Converting complex Vertica stored procedures into modular, maintainable dbt models

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add sfc-gh-dflippo/snowflake-dbt-demo dbt-migration-vertica

For use in Claude.ai and ChatGPT

Download Skill