{
  "id": "workflow:data-warehouse-cost-optimization",
  "_kind": "Workflow",
  "_file": "workflows/workflows/workflows-deeper-domains.yaml",
  "_cluster": "workflows",
  "attributes": {
    "displayName": "Data Warehouse Cost Optimization",
    "workflowKind": "operational",
    "triggerType": "scheduled",
    "typicalCadence": "monthly",
    "complexity": "cross-team",
    "description": "Optimizes data warehouse costs while maintaining query performance and\nSLA adherence -- analyzing query-cost attribution by team, dashboard, and\nad-hoc usage patterns, identifying expensive scans caused by missing\npartitioning or clustering, evaluating storage-tier placement for hot,\nwarm, and cold data based on access frequency, reviewing\nmaterialized-view cost-benefit against the queries they accelerate,\nassessing slot or compute-reservation sizing against peak-demand\nprofiles, modeling cost impact of migrating workloads between on-demand\nand flat-rate pricing, and implementing query-governance policies for\nrunaway queries. Produces cost optimization report and implementation\nrunbook. Excludes data-model redesign.\n"
  },
  "outgoingEdges": [
    {
      "from": "workflow:data-warehouse-cost-optimization",
      "to": "role:data-scientist",
      "kind": "involves_role",
      "attributes": {}
    },
    {
      "from": "workflow:data-warehouse-cost-optimization",
      "to": "role:platform-engineer",
      "kind": "involves_role",
      "attributes": {}
    },
    {
      "from": "workflow:data-warehouse-cost-optimization",
      "to": "role:engineering-manager",
      "kind": "involves_role",
      "attributes": {}
    },
    {
      "from": "workflow:data-warehouse-cost-optimization",
      "to": "skill-area:data-warehouse-modeling",
      "kind": "requires_skill_area",
      "attributes": {}
    },
    {
      "from": "workflow:data-warehouse-cost-optimization",
      "to": "skill-area:columnar-storage",
      "kind": "requires_skill_area",
      "attributes": {}
    },
    {
      "from": "workflow:data-warehouse-cost-optimization",
      "to": "domain:data-science",
      "kind": "applies_to_domain",
      "attributes": {}
    },
    {
      "from": "workflow:data-warehouse-cost-optimization",
      "to": "domain:data-engineering",
      "kind": "applies_to_domain",
      "attributes": {}
    },
    {
      "from": "workflow:data-warehouse-cost-optimization",
      "to": "domain:cloud-infra",
      "kind": "applies_to_domain",
      "attributes": {}
    },
    {
      "from": "workflow:data-warehouse-cost-optimization",
      "to": "responsibility:cost-optimization",
      "kind": "triggers_responsibility",
      "attributes": {}
    },
    {
      "from": "workflow:data-warehouse-cost-optimization",
      "to": "responsibility:performance-budget-tracking",
      "kind": "triggers_responsibility",
      "attributes": {}
    },
    {
      "from": "workflow:data-warehouse-cost-optimization",
      "to": "org-unit:data-platform-team",
      "kind": "performed_by_org_unit",
      "attributes": {}
    },
    {
      "from": "workflow:data-warehouse-cost-optimization",
      "to": "org-unit:analytics-team",
      "kind": "performed_by_org_unit",
      "attributes": {}
    },
    {
      "from": "workflow:data-warehouse-cost-optimization",
      "to": "org-unit:infra-engineering",
      "kind": "performed_by_org_unit",
      "attributes": {}
    }
  ],
  "incomingEdges": []
}