dbt Projects on Snowflake: Build & Deploy with Cortex Code

Cortex Code is Snowflake's AI coding agent built specifically for the Snowflake and dbt ecosystem. It enables data engineers to generate dbt models, update YAML documentation, write tests, and optimize SQL performance from a single prompt or CLI command. Key capabilities include context-aware model generation using dbt conventions (config and ref macros), simultaneous YAML and test updates when editing models, smart troubleshooting for Snowflake-specific SQL, and performance analysis via run_results.json. It supports dbt Core, dbt Platform, and native Snowflake dbt projects, accessible through both the Snowsight UI and a CLI tool.