# .dbt_cloud/job_config.yml
jobs:
  - name: "Production Run"
    description: "Daily production run for all models"
    environment: "Production"
    triggers:
      - type: "scheduled"
        cron: "0 2 * * *"
      - type: "git_push"
        branches: ["main"]
    
    steps:
      - command: "dbt deps"
      - command: "dbt seed"
      - command: "dbt run --full-refresh"
      - command: "dbt test"
    
    notifications:
      - type: "slack"
        channel: "#data-engineering"
      - type: "email"
        recipients:
          - "data-eng@company.com"
    
    settings:
      warehouse: "ANALYTICS_WH"
      schema: "production"
      threads: 8
    
    alert_on:
      - "failure"
      - "warning"

# .dbt_cloud/ci_config.yml
ci:
  enabled: true
  
  state:
    compare:
      - "manifest.json"
      - "run_results.json"
  
  selection:
    strategy: "modified"
    include:
      - "state:modified+"
      - "state:new+"
    exclude:
      - "tag:deprecated"
  
  optimization:
    enabled: true
    max_run_time: "30m"
    cost_threshold: 100
  
  notifications:
    on_success:
      - type: "slack"
        channel: "#ci-results"
    on_failure:
      - type: "slack"
        channel: "#ci-alerts"
      - type: "pagerduty"
        severity: "critical"

# .dbt_cloud/semantic_layer.yml
semantic_layer:
  enabled: true
  
  metrics:
    - name: "total_revenue"
      type: "simple"
      expression: "sum(amount)"
      description: "Total revenue from all orders"
    
    - name: "order_count"
      type: "simple"
      expression: "count(*)"
      description: "Total number of orders"
    
    - name: "avg_order_value"
      type: "derived"
      expression: "total_revenue / order_count"
      description: "Average order value"
  
  dimensions:
    - name: "order_date"
      type: "time"
      granularity: "day"
    
    - name: "customer_segment"
      type: "categorical"
  
  access:
    - type: "bi_tool"
      name: "Looker"
      permissions: ["read"]
    
    - type: "application"
      name: "Feature Store"
      permissions: ["read", "query"]

# .dbt_cloud/monitoring.yml
monitoring:
  enabled: true
  
  metrics:
    - name: "run_duration"
      type: "histogram"
      alert_threshold: "30m"
    
    - name: "cost_per_model"
      type: "gauge"
      alert_threshold: 10
  
  alerts:
    - name: "Long Running Job"
      condition: "run_duration > 30m"
      severity: "warning"
      channels:
        - "slack:#data-engineering"
        - "email:data-eng@company.com"
    
    - name: "High Cost Job"
      condition: "total_cost > 500"
      severity: "critical"
      channels:
        - "slack:#data-engineering"
        - "pagerduty:data-eng"
  
  dashboards:
    - name: "Job Performance"
      metrics: ["run_duration", "success_rate", "cost"]
      refresh: "1h"
    
    - name: "Cost Tracking"
      metrics: ["cost_per_model", "cost_per_job"]
      refresh: "1d"