🎯Skills9
Transforms data using dbt's analytics engineering principles, building modular models, tests, and pipelines with software engineering best practices.
Retrieves and searches dbt documentation efficiently by converting URLs to markdown and using specialized search techniques.
Validates dbt model SQL logic by testing specific input scenarios and expected outputs before full model materialization.
Answers business data questions by intelligently querying dbt semantic layers, models, and project metadata to provide precise insights.
Diagnose and resolve dbt Cloud job failures by systematically investigating error types, logs, and potential root causes using MCP tools and CLI commands.
Guides users in creating and configuring dbt Semantic Layer components like semantic models, metrics, and dimensions using MetricFlow.
Configures dbt MCP server for AI development tools, enabling seamless connection to dbt's CLI, Semantic Layer, and APIs.
Guides users through migrating a dbt Core project to the Fusion engine, identifying and resolving compatibility issues automatically.
Executes dbt commands like run, test, and compile across project directories, handling dependencies and providing detailed command output and error tracking.