using-dbt-for-analytics-engineering - dbt Analytics Engineering
Builds and modifies dbt models, writes SQL transformations, creates tests, and validates results.
Tags
Updated: 2026-03-22Capabilities
Typical Inputs
Typical Outputs
What this skill does
- Build dbt models
- Modify dbt models
- Write SQL transformations
- Use ref() and source()
- Create data tests
- Validate results
- Debug dbt errors
- Explore data sources
- Evaluate model changes
- Refactor dbt projects
- Write documentation
- Manage dbt packages
- Preview input data
- Preview model results
- Run data profiling
Inputs
- Warehouse data
- Project structure
- YAML configs
- Model files
- Source definitions
- Test files
- Production artifacts
- dbt packages
Outputs
- Model files
- SQL transformations
- Test files
- Documentation files
- Query results
- Error messages
- Execution logs
- Data previews
Requirements
- dbt CLI
- Terminal environment
