strategyshifu.com

{
  "type": "object",
  "properties": {
    "dataSizeGb": {
      "type": "number",
      "minimum": 0,
      "description": "Total source data volume in GB."
    },
    "tableCount": {
      "type": "integer",
      "minimum": 0,
      "description": "Number of source tables in migration scope."
    },
    "largestTableGb": {
      "type": "number",
      "minimum": 0,
      "description": "Largest in-scope source table size in GB."
    },
    "dailyChangeRate": {
      "type": "string",
      "enum": [
        "< 1%",
        "1–5%",
        "5–20%",
        "> 20%",
        "Unknown"
      ]
    },
    "writePattern": {
      "type": "string",
      "enum": [
        "Mostly append",
        "MERGE / upsert",
        "Frequent UPDATE",
        "Frequent DELETE",
        "Mixed workload",
        "Mostly read-only"
      ]
    },
    "redshiftSqlComplexity": {
      "type": "string",
      "enum": [
        "Low",
        "Medium",
        "High",
        "Unknown"
      ]
    },
    "keepRedshiftActive": {
      "type": "boolean"
    },
    "coexistenceDuration": {
      "type": "string",
      "enum": [
        "< 1 month",
        "1–3 months",
        "3–6 months",
        "> 6 months",
        "Unknown"
      ]
    },
    "downtimeTolerance": {
      "type": "string",
      "enum": [
        "Near zero",
        "< 1 hour",
        "< 1 day",
        "Multiple days acceptable"
      ]
    },
    "sharedS3Available": {
      "type": "string",
      "enum": [
        "Yes",
        "No",
        "Unknown"
      ]
    },
    "targetState": {
      "type": "string",
      "enum": [
        "Databricks becomes primary platform",
        "Long-term Redshift + Databricks coexistence",
        "Evaluate Databricks before migration",
        "Only move selected workloads",
        "Not decided"
      ]
    },
    "targetFormat": {
      "type": "string",
      "enum": [
        "Delta Lake",
        "Iceberg",
        "No preference",
        "Not decided"
      ]
    },
    "migrationPriority": {
      "type": "string",
      "enum": [
        "Data pipelines / ETL",
        "BI and reporting",
        "Selected workload POC",
        "Not decided"
      ]
    },
    "changeSyncPlan": {
      "type": "string",
      "enum": [
        "Write freeze",
        "Scheduled incremental loads",
        "CDC / replication tool",
        "Dual-write",
        "No plan",
        "Unknown"
      ]
    },
    "specialDataTypes": {
      "type": "string",
      "enum": [
        "None known",
        "Some",
        "Extensive",
        "Unknown"
      ]
    }
  },
  "additionalProperties": false
}