Teach

Purpose

Learn a reusable pattern from an example file. The user shows you a well-written artifact (model, query, config), and you extract the patterns worth following.

Workflow

1. Identify the file: The user provides a file reference (e.g., @models/staging/stg_orders.sql). Read the file.

2. Analyze patterns: Extract the structural patterns, NOT the specific content. Focus on:

   • File structure and organization (sections, ordering)
   • Naming conventions (prefixes, suffixes, casing)
   • SQL patterns (CTE vs subquery, join style, column ordering)
   • dbt conventions (materialization, tests, config blocks)
   • Common boilerplate (headers, comments, imports)
   • Data type choices
   • Error handling patterns