dbt for Cortex AI: Harvesting patterns as Snowflake Cortex Code Skills

A Snowflake engineer introduces 'dbt-cortex-pipeline', a Cortex Code skill that automates building unified dbt projects with integrated Cortex AI services (Semantic View, Cortex Search, Cortex Agent) on Snowflake. The skill supports three scenarios: net-new project creation, extending existing dbt projects with AI services, and migrating Dynamic Table pipelines to dbt. It promises 2x-3x acceleration over manual setup. The post also shares best practices for building custom Cortex Code skills, including modularization, lean markdown files, proper trigger words, negative guardrails, and iterative evaluation with eval datasets.