Interactive Exercise: Github Workflows
🐙
GitHub Analytics Team Simulator
Practice dbt collaboration workflows with your team
📋 Current Scenario: Morning Standup
Welcome to the Analytics Engineering team! You’ve just joined a team working on a dbt project for an e-commerce company. Today, you need to add a new revenue metric that Marketing requested. Let’s practice the full GitHub workflow!
Repository
Pull Requests
Workflow
Terminal
📦 analytics-dbt-project
🌿
main
▼
models/staging/
models/intermediate/
models/marts/
dbt_project.yml
README.md
Quick Actions
●
Add customer segmentation model
needs review
dbt tests passing
●
Update staging layer for new Shopify fields
WIP
📊 GitHub Workflow Steps
Create a Feature Branch
Branch from main: feature/marketing-roas
Sync with Main
Pull latest changes from main
Make Changes
Add int_campaign_roas.sql model
Commit Changes
Write clear commit message
Push to Remote
Push branch to GitHub
Open Pull Request
Create PR with description
Code Review
Get feedback from team
Merge to Main
Merge approved PR
Workflow Best Practices:
• Always sync with main before pushing
• Keep branches small and focused
• Write descriptive commit messages
• Request reviews from relevant team members
• Run dbt tests before pushing
• Update documentation with changes
📚 Terminal Workflow Guide
1
Check current status:
git statusSee which branch you’re on and if there are changes
2
Create feature branch:
git checkout -b feature/marketing-roasCreate and switch to a new branch for your work
3
Sync with main:
git pull origin mainGet the latest changes from the main branch
4
Stage changes:
git add .Stage all your changes for commit
5
Commit:
git commit -m "Add ROAS calculation"Save your changes with a descriptive message
6
Push to GitHub:
git push origin feature/marketing-roasUpload your branch to GitHub
💡 Helpful Commands: Type
help for all commands • clear to clear the terminal • git log to see commit history
Analytics dbt Project Terminal
=============================
🎯 Let’s start with checking your current status. Type: git status
$