skills.rest
kumewata
kumewataCOMMUNITY
Explore all skills by this author →
GitHub

dbt

Configures profiles and validates connections for dbt development.

Updated Jan 16, 2026
Search Tags:#testing#analytics#dbt#sql#data-modeling#data-warehouse#databricks
One-click install
npx skills add https://github.com/kumewata/dotfiles --skill dbt-kumewata
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: dbt
Source: https://github.com/kumewata/dotfiles/tree/main/config/agents/skills/dbt
Command: npx skills add https://github.com/kumewata/dotfiles --skill dbt-kumewata

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

dbt development often suffers from environment drift, inconsistent profiles, and unclear workflows across teams. This skill provides structured guidance to configure profiles, verify connections, and streamline model development with standard commands.

Core Features & Use Cases

  • Profile management and connection validation: set up and verify profiles for consistent dbt runs, including Databricks dialect considerations.
  • Command orchestration: guidance on dbt debug, compile, run, and test workflows with best practices and guardrails.
  • Issue-focused targets: procedures for adding issue-specific targets in profiles.yml to isolate work.

Quick Start

Set up a new dbt project, configure ~/.dbt profiles, and run a quick debug and compile sequence to validate the setup.

Frequently Asked Questions about dbt

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

FAQPage Schema
How do I configure dbt profiles for Databricks SQL dialects?▼

To configure dbt profiles for Databricks, set up your ~/.dbt profiles.yml with the correct connection parameters and specify the Databricks SQL dialect. This isolates work and ensures consistent dbt runs across development environments.

What is the best way to validate dbt connections before running models?▼

The best way to validate dbt connections is executing dbt debug with the --profiles-dir ~/.dbt --no-use-colors flags. This verifies your environment setup and confirms profile configurations are correct before running data pipelines.

How do I add issue-specific targets in dbt profiles.yml?▼

To add issue-specific targets in dbt profiles.yml, define custom target configurations within your profile block. This isolates development work and prevents environment drift when executing dbt run or dbt test for specific issues.

Can I use dbt compile and dbt show for ad-hoc queries?▼

Yes, you can use dbt compile to generate compiled SQL files and dbt show to execute ad-hoc queries. These commands validate model logic and inspect data without full pipeline execution, using standard profiles-dir configurations.

Why does my dbt development suffer from environment drift across teams?▼

dbt environment drift occurs when teams use inconsistent profiles and unverified connection settings. Structured guidance for dbt debug validation, standard command flags, and isolated issue-specific targets resolves workflow inconsistencies and ensures reliable data pipelines.

Related Skills

Explore More Data & Analytics Skills→
rbutinarrbutinar

databricks-query

Execute SQL queries on a Databricks SQL Warehouse.

Community
Intermediate
nrakownrakow
1

data-lineage

Trace data lineage across dbt sources, transformations, and reports.

Community
Advanced
borgheiborghei
467

analytics-engineer

Model data and build dbt pipelines from staging to marts.

Community
Advanced
nrakownrakow
1

warehouse-udf-strategy

Automate UDF versus dbt macro decisions for SQL transformations.

Community
Advanced