Cost Optimizer (Cloud Data Platforms)

Overview

Analyzes and optimizes costs for cloud data platforms. This skill provides deep expertise in platform-specific cost structures and optimization strategies.

Capabilities

• •Snowflake credit analysis and optimization
• •BigQuery slot and on-demand optimization
• •Redshift node sizing
• •Storage cost optimization
• •Query cost estimation
• •Warehouse scheduling recommendations
• •Data lifecycle policy recommendations
• •Reserved capacity planning

Input Schema

{
  "platform": "snowflake|bigquery|redshift|databricks",
  "usageMetrics": "object",
  "billingData": "object",
  "queryHistory": "object"
}

Output Schema

{
  "currentCost": "number",
  "optimizedCost": "number",
  "savings": "percentage",
  "recommendations": [{
    "category": "string",
    "action": "string",
    "impact": "number",
    "effort": "low|medium|high"
  }]
}

Target Processes

• •Data Warehouse Setup
• •Query Optimization
• •Pipeline Migration

Usage Guidelines

1. •Provide platform-specific usage metrics
2. •Include billing data for cost baseline
3. •Share query history for optimization analysis
4. •Prioritize recommendations by impact and effort

Best Practices

• •Regularly review and optimize warehouse sizes
• •Implement auto-suspend and auto-resume policies
• •Use clustering and partitioning to reduce scan costs
• •Consider reserved capacity for predictable workloads
• •Monitor and alert on cost anomalies