dbt-migration-oracle
Oracle to dbt Model Conversion
Purpose
Transform Oracle DDL (views, tables, stored procedures, packages) 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 Oracle views or tables to dbt models
- Migrating Oracle stored procedures or packages to dbt
- Translating Oracle PL/SQL syntax to Snowflake
- Generating schema.yml files with tests and documentation
- Handling Oracle-specific syntax conversions (ROWNUM/ROWID, CONNECT BY, DBMS_* packages, sequences)
More from sfc-gh-dflippo/snowflake-dbt-demo
dbt-migration-snowflake
Convert Snowflake DDL to dbt models. This skill should be used when converting views, tables, or
9task-master
AI-powered task management for structured, specification-driven development. Use this skill when
6dbt-core
Managing dbt-core locally - installation, configuration, project setup, package management,
4playwright-mcp
Browser testing, web scraping, and UI validation using Playwright MCP. Use this skill when you
3task-master-install
Install and initialize task-master for AI-powered task management and specification-driven
3snowflake-cli
Executing SQL, managing Snowflake objects, deploying applications, and orchestrating data
2