Execute DBT
ekai executes the generated DBT project directly in your connected data warehouse. Build models, run tests, and see results—all from the UI.
Complete the AI Modeling & Build step to generate the DBT project artifacts.
DBT Project Tab
The DBT PROJECT tab in AI MODELING & BUILD shows:
- File tree — Navigate project structure
- Code view — SQL and YAML with syntax highlighting
- Execution controls — Run and monitor builds
Running DBT
Start Execution
Click the Re-Run DBT Models button to execute:
Execution Process
ekai runs dbt run --full-refresh in your warehouse:
- Compile — Generate SQL from models
- Execute — Run transformations in warehouse
- Test — Execute data validation tests
- Report — Show results and any errors
Execution Status
Success
All models built and tests passed.
Summary Output
Summary
I successfully ran dbt run --full-refresh on your Snowflake-based
dbt project and fixed all errors encountered. Here's what was
accomplished:
Models Built:
✓ stg_temenos_customers
✓ stg_worldline_cards
✓ int_card_activation_enriched
✓ int_card_activation_metrics
✓ fct_card_activation
✓ dim_customers
✓ dim_card_type
Tests Passed: 12/12
Build Time: 45 seconds
AI Agent Chat During Execution
The AI Agent shows real-time progress:
Bash()
Running command: cat /app/workspaces/3/models/marts/
card_activation/fct_card_activation.sql | head -40
Write()
Writing to file: EXECUTION_GUIDE.md
Bash()
Running command: find . -type f ( -name "*.sql" -o
-name "*.yml" -o -name "*.md" ) ! -path "./dbt_packages/*" ! -pa...
Handling Errors
Common Error Types
| Error | Cause | Resolution |
|---|---|---|
| Compilation Error | SQL syntax issue | AI auto-fixes and retries |
| Test Failure | Data quality issue | Review test results |
| Permission Error | Missing warehouse access | Check connection credentials |
| Timeout | Large data volume | Increase warehouse size |
Auto-Fix Capability
ekai's AI Agent can automatically fix common errors:
"I encountered a compilation error in
stg_customers.sql. The issue was a missing comma in the column list. I've fixed the error and re-running the build."
Incremental Execution
For subsequent runs:
| Mode | Command | When to Use |
|---|---|---|
| Full Refresh | dbt run --full-refresh | First run, schema changes |
| Incremental | dbt run | Regular updates |
| Specific Model | dbt run -s model_name | Testing single model |
Results Storage
After successful execution:
| Artifact | Location |
|---|---|
| Transformed Tables | Your warehouse (configured schema) |
| Execution Logs | ekai logs directory |
| Test Results | DBT test artifacts |
| Documentation | Data catalog updated |
Warehouse Requirements
Ensure your connected warehouse has:
| Requirement | Details |
|---|---|
| Write Access | Schema where models will be created |
| Compute | Sufficient warehouse size for transformations |
| Storage | Space for materialized tables |
Schema Agents only need read access. Semantic Models need write access to execute DBT and create tables.