skills.rest
pkoka888
pkoka888COMMUNITY
Explore all skills by this author →
GitHub

using-dbt-for-analytics-engineering

Build and validate dbt models and SQL transformations using dbt CLI.

1|Updated Apr 6, 2026
Search Tags:#analytics#discovery#dbt#sql#data-transformation#dbt-cli#data-testing
One-click install
npx skills add https://github.com/pkoka888/server-infra-templates --skill using-dbt-for-analytics-engineering-pkoka888
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: using-dbt-for-analytics-engineering
Source: https://github.com/pkoka888/server-infra-templates/tree/main/.kilo/skills/marketplace/dbt/skills/using-dbt-for-analytics-engineering
Command: npx skills add https://github.com/pkoka888/server-infra-templates --skill using-dbt-for-analytics-engineering-pkoka888

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) components.

What problem does it solve?

Enables analytics engineers to reliably build, modify, and validate dbt models while minimizing data mistakes, costly full-project runs, and downstream breakages by enforcing discovery, testing, and safe CLI practices.

Core Features & Use Cases

  • Model Design & Refactoring: Guidance for planning models, mocking final outputs, and refactoring with DRY principles and ref()/source() usage.
  • Discovery & Validation: Uses dbt show and discovery checklists to inspect sample data, profile columns, and document findings before coding.
  • Debugging & Impact Analysis: Steps to diagnose parsing, compilation, and data errors plus workflows to enumerate downstream dependencies and recommend scoped dbt build selectors.
  • Testing & Package Management: Advice on high-value tests, package vetting, and cost-conscious testing strategies for large tables.
  • Use Case Example: Add a staging model for a new source, validate its grain with dbt show, add not_null/unique tests, and run a scoped build to confirm downstream stability.

Quick Start

Add a new model that computes daily active users, identify required sources, write SQL using ref() and source(), add appropriate tests, and run dbt show to validate the results.

Frequently Asked Questions about using-dbt-for-analytics-engineering

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I validate dbt models and inspect sample data before running a full build?▼

Use dbt show to validate dbt models and inspect sample data before executing a full build. This allows you to profile columns and document findings early, minimizing data mistakes and avoiding costly full-project runs.

What is the best way to debug dbt compilation and runtime errors in SQL transformations?▼

Debug dbt compilation and runtime errors by following structured diagnostic steps to identify parsing and data issues. Enumerate downstream dependencies and apply scoped dbt build selectors to isolate failures without running the entire project.

How do I add a new staging model for a source and test it in dbt?▼

Add a new staging model by identifying required sources, writing SQL with source(), and validating the grain using dbt show. Add not_null and unique tests, then execute a scoped build to confirm downstream stability.

How can I perform cost-conscious testing and manage packages for large dbt tables?▼

Perform cost-conscious testing on large dbt tables by applying high-value tests and using scoped CLI selectors like --select and --limit. Vet external packages carefully to ensure they fit your analytics engineering workflow without excessive compute costs.

Why should I use ref() and source() functions when writing dbt models?▼

Use ref() and source() when writing dbt models to enforce proper dependency management and lineage tracking. This ensures reliable compilation, enables downstream impact analysis, and supports DRY principles during model refactoring.

Related Skills

Explore More Data & Analytics Skills→
AltimateAIAltimateAI

altimate-code

Delegate data engineering tasks to the Altimate-code CLI agent.

Official
Advanced
borgheiborghei
467

analytics-engineer

Model data and build dbt pipelines from staging to marts.

Community
Advanced
timequitytimequity
6

dbt-expert

Generates compliant YAML docs and maintains standards for dbt projects.

Official
Advanced
lightdashlightdash
6.0k

developing-in-lightdash

Automate Lightdash project setup, configuration, and deployment via CLI.

Official
Intermediate