dbt-cortex-pipeline

What problem does it solve?

This Skill automates the construction of dbt pipelines on Snowflake that integrate data models with Cortex AI services, enabling users to perform advanced natural language querying, text2sql, document search, and conversational AI interactions.

Core Features & Use Cases

• End-to-End dbt Pipeline: Integrates data modeling with Cortex AI services (Semantic Views, Cortex Search, Cortex Agents) in a single deployable dbt project.
• Data Modeling: Supports bronze, silver, and gold layers with various capabilities like pass-through models, AI enrichment, and business-ready fact tables.
• Cortex AI Services: Offers Semantic Views for text-to-SQL, Cortex Search for vector search over unstructured text, and Cortex Agents for conversational AI.
• Use Case: For users looking to create a dbt project with AI capabilities for natural language querying, text2sql, document search, or conversational AI interactions, this Skill provides a streamlined process to design, build, and deploy such a project.

Quick Start

To build a dbt project with Cortex AI services, run the dbt-cortex-pipeline skill and follow the prompts to configure your project settings, data sources, and desired Cortex AI features.