--- policy: /ce/ca/aws/glue/job-underutilized logic: /ce/ca/aws/glue/job-underutilized/prod.logic.yaml executionTime: 2026-10-17T12:03:32.836069709Z generationMs: 113 executionMs: 922 rows: - id: low-utilization match: true status: expected: INCOMPLIANT actual: INCOMPLIANT conditionIndex: expected: 699 actual: 699 conditionText: expected: extract('CA10__avgAllCpuSystemLoad14d__c') < number(20.0) && extract('CA10__avgAllJvmHeapUsage14d__c') < number(20.0) && extract('CA10__avgDriverCpuSystemLoad14d__c') < number(20.0) && extract('CA10__avgDriverJvmHeapUsage14d__c') < number(20.0) actual: extract('CA10__avgAllCpuSystemLoad14d__c') < number(20.0) && extract('CA10__avgAllJvmHeapUsage14d__c') < number(20.0) && extract('CA10__avgDriverCpuSystemLoad14d__c') < number(20.0) && extract('CA10__avgDriverJvmHeapUsage14d__c') < number(20.0) runtimeError: {} - id: CA10__avgAllCpuSystemLoad14d__c-20 match: true status: expected: COMPLIANT actual: COMPLIANT conditionIndex: expected: 700 actual: 700 conditionText: expected: otherwise actual: otherwise runtimeError: {} - id: CA10__avgAllCpuSystemLoad14d__c-100 match: true status: expected: COMPLIANT actual: COMPLIANT conditionIndex: expected: 700 actual: 700 conditionText: expected: otherwise actual: otherwise runtimeError: {} - id: CA10__avgAllCpuSystemLoad14d__c-None match: true status: expected: UNDETERMINED actual: UNDETERMINED conditionIndex: expected: 401 actual: 401 conditionText: expected: CA10__avgAllCpuSystemLoad14d__c.isEmpty() actual: CA10__avgAllCpuSystemLoad14d__c.isEmpty() runtimeError: {} - id: CA10__avgAllCpuSystemLoad14d__c--1 match: true status: expected: UNDETERMINED actual: UNDETERMINED conditionIndex: expected: 499 actual: 499 conditionText: expected: extract('CA10__avgAllCpuSystemLoad14d__c') <= number(0.0) || extract('CA10__avgAllCpuSystemLoad14d__c') > number(100.0) || extract('CA10__avgAllJvmHeapUsage14d__c') <= number(0.0) || extract('CA10__avgAllJvmHeapUsage14d__c') > number(100.0) || extract('CA10__avgDriverCpuSystemLoad14d__c') <= number(0.0) || extract('CA10__avgDriverCpuSystemLoad14d__c') > number(100.0) || extract('CA10__avgDriverJvmHeapUsage14d__c') <= number(0.0) || extract('CA10__avgDriverJvmHeapUsage14d__c') > number(100.0) actual: extract('CA10__avgAllCpuSystemLoad14d__c') <= number(0.0) || extract('CA10__avgAllCpuSystemLoad14d__c') > number(100.0) || extract('CA10__avgAllJvmHeapUsage14d__c') <= number(0.0) || extract('CA10__avgAllJvmHeapUsage14d__c') > number(100.0) || extract('CA10__avgDriverCpuSystemLoad14d__c') <= number(0.0) || extract('CA10__avgDriverCpuSystemLoad14d__c') > number(100.0) || extract('CA10__avgDriverJvmHeapUsage14d__c') <= number(0.0) || extract('CA10__avgDriverJvmHeapUsage14d__c') > number(100.0) runtimeError: {} - id: CA10__avgAllCpuSystemLoad14d__c-101 match: true status: expected: UNDETERMINED actual: UNDETERMINED conditionIndex: expected: 499 actual: 499 conditionText: expected: extract('CA10__avgAllCpuSystemLoad14d__c') <= number(0.0) || extract('CA10__avgAllCpuSystemLoad14d__c') > number(100.0) || extract('CA10__avgAllJvmHeapUsage14d__c') <= number(0.0) || extract('CA10__avgAllJvmHeapUsage14d__c') > number(100.0) || extract('CA10__avgDriverCpuSystemLoad14d__c') <= number(0.0) || extract('CA10__avgDriverCpuSystemLoad14d__c') > number(100.0) || extract('CA10__avgDriverJvmHeapUsage14d__c') <= number(0.0) || extract('CA10__avgDriverJvmHeapUsage14d__c') > number(100.0) actual: extract('CA10__avgAllCpuSystemLoad14d__c') <= number(0.0) || extract('CA10__avgAllCpuSystemLoad14d__c') > number(100.0) || extract('CA10__avgAllJvmHeapUsage14d__c') <= number(0.0) || extract('CA10__avgAllJvmHeapUsage14d__c') > number(100.0) || extract('CA10__avgDriverCpuSystemLoad14d__c') <= number(0.0) || extract('CA10__avgDriverCpuSystemLoad14d__c') > number(100.0) || extract('CA10__avgDriverJvmHeapUsage14d__c') <= number(0.0) || extract('CA10__avgDriverJvmHeapUsage14d__c') > number(100.0) runtimeError: {} - id: CA10__avgAllJvmHeapUsage14d__c-20 match: true status: expected: COMPLIANT actual: COMPLIANT conditionIndex: expected: 700 actual: 700 conditionText: expected: otherwise actual: otherwise runtimeError: {} - id: CA10__avgAllJvmHeapUsage14d__c-100 match: true status: expected: COMPLIANT actual: COMPLIANT conditionIndex: expected: 700 actual: 700 conditionText: expected: otherwise actual: otherwise runtimeError: {} - id: CA10__avgAllJvmHeapUsage14d__c-None match: true status: expected: UNDETERMINED actual: UNDETERMINED conditionIndex: expected: 402 actual: 402 conditionText: expected: CA10__avgAllJvmHeapUsage14d__c.isEmpty() actual: CA10__avgAllJvmHeapUsage14d__c.isEmpty() runtimeError: {} - id: CA10__avgAllJvmHeapUsage14d__c--1 match: true status: expected: UNDETERMINED actual: UNDETERMINED conditionIndex: expected: 499 actual: 499 conditionText: expected: extract('CA10__avgAllCpuSystemLoad14d__c') <= number(0.0) || extract('CA10__avgAllCpuSystemLoad14d__c') > number(100.0) || extract('CA10__avgAllJvmHeapUsage14d__c') <= number(0.0) || extract('CA10__avgAllJvmHeapUsage14d__c') > number(100.0) || extract('CA10__avgDriverCpuSystemLoad14d__c') <= number(0.0) || extract('CA10__avgDriverCpuSystemLoad14d__c') > number(100.0) || extract('CA10__avgDriverJvmHeapUsage14d__c') <= number(0.0) || extract('CA10__avgDriverJvmHeapUsage14d__c') > number(100.0) actual: extract('CA10__avgAllCpuSystemLoad14d__c') <= number(0.0) || extract('CA10__avgAllCpuSystemLoad14d__c') > number(100.0) || extract('CA10__avgAllJvmHeapUsage14d__c') <= number(0.0) || extract('CA10__avgAllJvmHeapUsage14d__c') > number(100.0) || extract('CA10__avgDriverCpuSystemLoad14d__c') <= number(0.0) || extract('CA10__avgDriverCpuSystemLoad14d__c') > number(100.0) || extract('CA10__avgDriverJvmHeapUsage14d__c') <= number(0.0) || extract('CA10__avgDriverJvmHeapUsage14d__c') > number(100.0) runtimeError: {} - id: CA10__avgAllJvmHeapUsage14d__c-101 match: true status: expected: UNDETERMINED actual: UNDETERMINED conditionIndex: expected: 499 actual: 499 conditionText: expected: extract('CA10__avgAllCpuSystemLoad14d__c') <= number(0.0) || extract('CA10__avgAllCpuSystemLoad14d__c') > number(100.0) || extract('CA10__avgAllJvmHeapUsage14d__c') <= number(0.0) || extract('CA10__avgAllJvmHeapUsage14d__c') > number(100.0) || extract('CA10__avgDriverCpuSystemLoad14d__c') <= number(0.0) || extract('CA10__avgDriverCpuSystemLoad14d__c') > number(100.0) || extract('CA10__avgDriverJvmHeapUsage14d__c') <= number(0.0) || extract('CA10__avgDriverJvmHeapUsage14d__c') > number(100.0) actual: extract('CA10__avgAllCpuSystemLoad14d__c') <= number(0.0) || extract('CA10__avgAllCpuSystemLoad14d__c') > number(100.0) || extract('CA10__avgAllJvmHeapUsage14d__c') <= number(0.0) || extract('CA10__avgAllJvmHeapUsage14d__c') > number(100.0) || extract('CA10__avgDriverCpuSystemLoad14d__c') <= number(0.0) || extract('CA10__avgDriverCpuSystemLoad14d__c') > number(100.0) || extract('CA10__avgDriverJvmHeapUsage14d__c') <= number(0.0) || extract('CA10__avgDriverJvmHeapUsage14d__c') > number(100.0) runtimeError: {} - id: CA10__avgDriverCpuSystemLoad14d__c-20 match: true status: expected: COMPLIANT actual: COMPLIANT conditionIndex: expected: 700 actual: 700 conditionText: expected: otherwise actual: otherwise runtimeError: {} - id: CA10__avgDriverCpuSystemLoad14d__c-100 match: true status: expected: COMPLIANT actual: COMPLIANT conditionIndex: expected: 700 actual: 700 conditionText: expected: otherwise actual: otherwise runtimeError: {} - id: CA10__avgDriverCpuSystemLoad14d__c-None match: true status: expected: UNDETERMINED actual: UNDETERMINED conditionIndex: expected: 403 actual: 403 conditionText: expected: CA10__avgDriverCpuSystemLoad14d__c.isEmpty() actual: CA10__avgDriverCpuSystemLoad14d__c.isEmpty() runtimeError: {} - id: CA10__avgDriverCpuSystemLoad14d__c--1 match: true status: expected: UNDETERMINED actual: UNDETERMINED conditionIndex: expected: 499 actual: 499 conditionText: expected: extract('CA10__avgAllCpuSystemLoad14d__c') <= number(0.0) || extract('CA10__avgAllCpuSystemLoad14d__c') > number(100.0) || extract('CA10__avgAllJvmHeapUsage14d__c') <= number(0.0) || extract('CA10__avgAllJvmHeapUsage14d__c') > number(100.0) || extract('CA10__avgDriverCpuSystemLoad14d__c') <= number(0.0) || extract('CA10__avgDriverCpuSystemLoad14d__c') > number(100.0) || extract('CA10__avgDriverJvmHeapUsage14d__c') <= number(0.0) || extract('CA10__avgDriverJvmHeapUsage14d__c') > number(100.0) actual: extract('CA10__avgAllCpuSystemLoad14d__c') <= number(0.0) || extract('CA10__avgAllCpuSystemLoad14d__c') > number(100.0) || extract('CA10__avgAllJvmHeapUsage14d__c') <= number(0.0) || extract('CA10__avgAllJvmHeapUsage14d__c') > number(100.0) || extract('CA10__avgDriverCpuSystemLoad14d__c') <= number(0.0) || extract('CA10__avgDriverCpuSystemLoad14d__c') > number(100.0) || extract('CA10__avgDriverJvmHeapUsage14d__c') <= number(0.0) || extract('CA10__avgDriverJvmHeapUsage14d__c') > number(100.0) runtimeError: {} - id: CA10__avgDriverCpuSystemLoad14d__c-101 match: true status: expected: UNDETERMINED actual: UNDETERMINED conditionIndex: expected: 499 actual: 499 conditionText: expected: extract('CA10__avgAllCpuSystemLoad14d__c') <= number(0.0) || extract('CA10__avgAllCpuSystemLoad14d__c') > number(100.0) || extract('CA10__avgAllJvmHeapUsage14d__c') <= number(0.0) || extract('CA10__avgAllJvmHeapUsage14d__c') > number(100.0) || extract('CA10__avgDriverCpuSystemLoad14d__c') <= number(0.0) || extract('CA10__avgDriverCpuSystemLoad14d__c') > number(100.0) || extract('CA10__avgDriverJvmHeapUsage14d__c') <= number(0.0) || extract('CA10__avgDriverJvmHeapUsage14d__c') > number(100.0) actual: extract('CA10__avgAllCpuSystemLoad14d__c') <= number(0.0) || extract('CA10__avgAllCpuSystemLoad14d__c') > number(100.0) || extract('CA10__avgAllJvmHeapUsage14d__c') <= number(0.0) || extract('CA10__avgAllJvmHeapUsage14d__c') > number(100.0) || extract('CA10__avgDriverCpuSystemLoad14d__c') <= number(0.0) || extract('CA10__avgDriverCpuSystemLoad14d__c') > number(100.0) || extract('CA10__avgDriverJvmHeapUsage14d__c') <= number(0.0) || extract('CA10__avgDriverJvmHeapUsage14d__c') > number(100.0) runtimeError: {} - id: CA10__avgDriverJvmHeapUsage14d__c-20 match: true status: expected: COMPLIANT actual: COMPLIANT conditionIndex: expected: 700 actual: 700 conditionText: expected: otherwise actual: otherwise runtimeError: {} - id: CA10__avgDriverJvmHeapUsage14d__c-100 match: true status: expected: COMPLIANT actual: COMPLIANT conditionIndex: expected: 700 actual: 700 conditionText: expected: otherwise actual: otherwise runtimeError: {} - id: CA10__avgDriverJvmHeapUsage14d__c-None match: true status: expected: UNDETERMINED actual: UNDETERMINED conditionIndex: expected: 404 actual: 404 conditionText: expected: CA10__avgDriverJvmHeapUsage14d__c.isEmpty() actual: CA10__avgDriverJvmHeapUsage14d__c.isEmpty() runtimeError: {} - id: CA10__avgDriverJvmHeapUsage14d__c--1 match: true status: expected: UNDETERMINED actual: UNDETERMINED conditionIndex: expected: 499 actual: 499 conditionText: expected: extract('CA10__avgAllCpuSystemLoad14d__c') <= number(0.0) || extract('CA10__avgAllCpuSystemLoad14d__c') > number(100.0) || extract('CA10__avgAllJvmHeapUsage14d__c') <= number(0.0) || extract('CA10__avgAllJvmHeapUsage14d__c') > number(100.0) || extract('CA10__avgDriverCpuSystemLoad14d__c') <= number(0.0) || extract('CA10__avgDriverCpuSystemLoad14d__c') > number(100.0) || extract('CA10__avgDriverJvmHeapUsage14d__c') <= number(0.0) || extract('CA10__avgDriverJvmHeapUsage14d__c') > number(100.0) actual: extract('CA10__avgAllCpuSystemLoad14d__c') <= number(0.0) || extract('CA10__avgAllCpuSystemLoad14d__c') > number(100.0) || extract('CA10__avgAllJvmHeapUsage14d__c') <= number(0.0) || extract('CA10__avgAllJvmHeapUsage14d__c') > number(100.0) || extract('CA10__avgDriverCpuSystemLoad14d__c') <= number(0.0) || extract('CA10__avgDriverCpuSystemLoad14d__c') > number(100.0) || extract('CA10__avgDriverJvmHeapUsage14d__c') <= number(0.0) || extract('CA10__avgDriverJvmHeapUsage14d__c') > number(100.0) runtimeError: {} - id: CA10__avgDriverJvmHeapUsage14d__c-101 match: true status: expected: UNDETERMINED actual: UNDETERMINED conditionIndex: expected: 499 actual: 499 conditionText: expected: extract('CA10__avgAllCpuSystemLoad14d__c') <= number(0.0) || extract('CA10__avgAllCpuSystemLoad14d__c') > number(100.0) || extract('CA10__avgAllJvmHeapUsage14d__c') <= number(0.0) || extract('CA10__avgAllJvmHeapUsage14d__c') > number(100.0) || extract('CA10__avgDriverCpuSystemLoad14d__c') <= number(0.0) || extract('CA10__avgDriverCpuSystemLoad14d__c') > number(100.0) || extract('CA10__avgDriverJvmHeapUsage14d__c') <= number(0.0) || extract('CA10__avgDriverJvmHeapUsage14d__c') > number(100.0) actual: extract('CA10__avgAllCpuSystemLoad14d__c') <= number(0.0) || extract('CA10__avgAllCpuSystemLoad14d__c') > number(100.0) || extract('CA10__avgAllJvmHeapUsage14d__c') <= number(0.0) || extract('CA10__avgAllJvmHeapUsage14d__c') > number(100.0) || extract('CA10__avgDriverCpuSystemLoad14d__c') <= number(0.0) || extract('CA10__avgDriverCpuSystemLoad14d__c') > number(100.0) || extract('CA10__avgDriverJvmHeapUsage14d__c') <= number(0.0) || extract('CA10__avgDriverJvmHeapUsage14d__c') > number(100.0) runtimeError: {} - id: tasks-None match: true status: expected: UNDETERMINED actual: UNDETERMINED conditionIndex: expected: 301 actual: 301 conditionText: expected: CA10__numCompletedTasksSum14d__c.isEmpty() actual: CA10__numCompletedTasksSum14d__c.isEmpty() runtimeError: {} - id: tasks-0 match: true status: expected: UNDETERMINED actual: UNDETERMINED conditionIndex: expected: 399 actual: 399 conditionText: expected: extract('CA10__numCompletedTasksSum14d__c') <= number(0.0) actual: extract('CA10__numCompletedTasksSum14d__c') <= number(0.0) runtimeError: {} - id: tasks--1 match: true status: expected: UNDETERMINED actual: UNDETERMINED conditionIndex: expected: 399 actual: 399 conditionText: expected: extract('CA10__numCompletedTasksSum14d__c') <= number(0.0) actual: extract('CA10__numCompletedTasksSum14d__c') <= number(0.0) runtimeError: {} - id: command-pythonshell match: true status: expected: INAPPLICABLE actual: INAPPLICABLE conditionIndex: expected: 199 actual: 199 conditionText: expected: extract('CA10__commandName__c') != 'glueetl' actual: extract('CA10__commandName__c') != 'glueetl' runtimeError: {} - id: command-gluestreaming match: true status: expected: INAPPLICABLE actual: INAPPLICABLE conditionIndex: expected: 199 actual: 199 conditionText: expected: extract('CA10__commandName__c') != 'glueetl' actual: extract('CA10__commandName__c') != 'glueetl' runtimeError: {} - id: command-None match: true status: expected: UNDETERMINED actual: UNDETERMINED conditionIndex: expected: 101 actual: 101 conditionText: expected: CA10__commandName__c.isEmpty() actual: CA10__commandName__c.isEmpty() runtimeError: {} - id: created-2026-10-12T00:00:00Z match: true status: expected: INAPPLICABLE actual: INAPPLICABLE conditionIndex: expected: 299 actual: 299 conditionText: expected: not(extract('CA10__createdOn__c').beyondLastDays(14)) actual: not(extract('CA10__createdOn__c').beyondLastDays(14)) runtimeError: {} - id: created-2026-09-29T00:00:00Z match: true status: expected: INAPPLICABLE actual: INAPPLICABLE conditionIndex: expected: 299 actual: 299 conditionText: expected: not(extract('CA10__createdOn__c').beyondLastDays(14)) actual: not(extract('CA10__createdOn__c').beyondLastDays(14)) runtimeError: {} - id: created-None match: true status: expected: UNDETERMINED actual: UNDETERMINED conditionIndex: expected: 201 actual: 201 conditionText: expected: CA10__createdOn__c.isEmpty() actual: CA10__createdOn__c.isEmpty() runtimeError: {} - id: disappeared match: true status: expected: DISAPPEARED actual: DISAPPEARED conditionIndex: expected: 99 actual: 99 conditionText: expected: isDisappeared(CA10__disappearanceTime__c) actual: isDisappeared(CA10__disappearanceTime__c) runtimeError: {} - id: sample-one-task-zero-executor-cpu match: true status: expected: UNDETERMINED actual: UNDETERMINED conditionIndex: expected: 499 actual: 499 conditionText: expected: extract('CA10__avgAllCpuSystemLoad14d__c') <= number(0.0) || extract('CA10__avgAllCpuSystemLoad14d__c') > number(100.0) || extract('CA10__avgAllJvmHeapUsage14d__c') <= number(0.0) || extract('CA10__avgAllJvmHeapUsage14d__c') > number(100.0) || extract('CA10__avgDriverCpuSystemLoad14d__c') <= number(0.0) || extract('CA10__avgDriverCpuSystemLoad14d__c') > number(100.0) || extract('CA10__avgDriverJvmHeapUsage14d__c') <= number(0.0) || extract('CA10__avgDriverJvmHeapUsage14d__c') > number(100.0) actual: extract('CA10__avgAllCpuSystemLoad14d__c') <= number(0.0) || extract('CA10__avgAllCpuSystemLoad14d__c') > number(100.0) || extract('CA10__avgAllJvmHeapUsage14d__c') <= number(0.0) || extract('CA10__avgAllJvmHeapUsage14d__c') > number(100.0) || extract('CA10__avgDriverCpuSystemLoad14d__c') <= number(0.0) || extract('CA10__avgDriverCpuSystemLoad14d__c') > number(100.0) || extract('CA10__avgDriverJvmHeapUsage14d__c') <= number(0.0) || extract('CA10__avgDriverJvmHeapUsage14d__c') > number(100.0) runtimeError: {} - id: sample-high-task-count-auto-scaling match: true status: expected: INCOMPLIANT actual: INCOMPLIANT conditionIndex: expected: 699 actual: 699 conditionText: expected: extract('CA10__avgAllCpuSystemLoad14d__c') < number(20.0) && extract('CA10__avgAllJvmHeapUsage14d__c') < number(20.0) && extract('CA10__avgDriverCpuSystemLoad14d__c') < number(20.0) && extract('CA10__avgDriverJvmHeapUsage14d__c') < number(20.0) actual: extract('CA10__avgAllCpuSystemLoad14d__c') < number(20.0) && extract('CA10__avgAllJvmHeapUsage14d__c') < number(20.0) && extract('CA10__avgDriverCpuSystemLoad14d__c') < number(20.0) && extract('CA10__avgDriverJvmHeapUsage14d__c') < number(20.0) runtimeError: {} - id: all-zero-averages-positive-tasks match: true status: expected: UNDETERMINED actual: UNDETERMINED conditionIndex: expected: 499 actual: 499 conditionText: expected: extract('CA10__avgAllCpuSystemLoad14d__c') <= number(0.0) || extract('CA10__avgAllCpuSystemLoad14d__c') > number(100.0) || extract('CA10__avgAllJvmHeapUsage14d__c') <= number(0.0) || extract('CA10__avgAllJvmHeapUsage14d__c') > number(100.0) || extract('CA10__avgDriverCpuSystemLoad14d__c') <= number(0.0) || extract('CA10__avgDriverCpuSystemLoad14d__c') > number(100.0) || extract('CA10__avgDriverJvmHeapUsage14d__c') <= number(0.0) || extract('CA10__avgDriverJvmHeapUsage14d__c') > number(100.0) actual: extract('CA10__avgAllCpuSystemLoad14d__c') <= number(0.0) || extract('CA10__avgAllCpuSystemLoad14d__c') > number(100.0) || extract('CA10__avgAllJvmHeapUsage14d__c') <= number(0.0) || extract('CA10__avgAllJvmHeapUsage14d__c') > number(100.0) || extract('CA10__avgDriverCpuSystemLoad14d__c') <= number(0.0) || extract('CA10__avgDriverCpuSystemLoad14d__c') > number(100.0) || extract('CA10__avgDriverJvmHeapUsage14d__c') <= number(0.0) || extract('CA10__avgDriverJvmHeapUsage14d__c') > number(100.0) runtimeError: {} - id: created-just-before-utc-age-boundary match: true status: expected: INCOMPLIANT actual: INCOMPLIANT conditionIndex: expected: 699 actual: 699 conditionText: expected: extract('CA10__avgAllCpuSystemLoad14d__c') < number(20.0) && extract('CA10__avgAllJvmHeapUsage14d__c') < number(20.0) && extract('CA10__avgDriverCpuSystemLoad14d__c') < number(20.0) && extract('CA10__avgDriverJvmHeapUsage14d__c') < number(20.0) actual: extract('CA10__avgAllCpuSystemLoad14d__c') < number(20.0) && extract('CA10__avgAllJvmHeapUsage14d__c') < number(20.0) && extract('CA10__avgDriverCpuSystemLoad14d__c') < number(20.0) && extract('CA10__avgDriverJvmHeapUsage14d__c') < number(20.0) runtimeError: {} - id: high-cpu-missing-heap-is-not-compliant match: true status: expected: UNDETERMINED actual: UNDETERMINED conditionIndex: expected: 402 actual: 402 conditionText: expected: CA10__avgAllJvmHeapUsage14d__c.isEmpty() actual: CA10__avgAllJvmHeapUsage14d__c.isEmpty() runtimeError: {} - id: activity-only-in-earlier-week match: true status: expected: UNDETERMINED actual: UNDETERMINED conditionIndex: expected: 599 actual: 599 conditionText: expected: extract('CA10__numCompletedTasksSum7d__c') <= number(0.0) || extract('CA10__numCompletedTasksSum14d__c') <= extract('CA10__numCompletedTasksSum7d__c') actual: extract('CA10__numCompletedTasksSum7d__c') <= number(0.0) || extract('CA10__numCompletedTasksSum14d__c') <= extract('CA10__numCompletedTasksSum7d__c') runtimeError: {} - id: activity-only-in-recent-week match: true status: expected: UNDETERMINED actual: UNDETERMINED conditionIndex: expected: 599 actual: 599 conditionText: expected: extract('CA10__numCompletedTasksSum7d__c') <= number(0.0) || extract('CA10__numCompletedTasksSum14d__c') <= extract('CA10__numCompletedTasksSum7d__c') actual: extract('CA10__numCompletedTasksSum7d__c') <= number(0.0) || extract('CA10__numCompletedTasksSum14d__c') <= extract('CA10__numCompletedTasksSum7d__c') runtimeError: {} - id: negative-seven-day-tasks match: true status: expected: UNDETERMINED actual: UNDETERMINED conditionIndex: expected: 599 actual: 599 conditionText: expected: extract('CA10__numCompletedTasksSum7d__c') <= number(0.0) || extract('CA10__numCompletedTasksSum14d__c') <= extract('CA10__numCompletedTasksSum7d__c') actual: extract('CA10__numCompletedTasksSum7d__c') <= number(0.0) || extract('CA10__numCompletedTasksSum14d__c') <= extract('CA10__numCompletedTasksSum7d__c') runtimeError: {} - id: seven-day-tasks-exceed-fourteen-day-total match: true status: expected: UNDETERMINED actual: UNDETERMINED conditionIndex: expected: 599 actual: 599 conditionText: expected: extract('CA10__numCompletedTasksSum7d__c') <= number(0.0) || extract('CA10__numCompletedTasksSum14d__c') <= extract('CA10__numCompletedTasksSum7d__c') actual: extract('CA10__numCompletedTasksSum7d__c') <= number(0.0) || extract('CA10__numCompletedTasksSum14d__c') <= extract('CA10__numCompletedTasksSum7d__c') runtimeError: {} - id: missing-seven-day-tasks match: true status: expected: UNDETERMINED actual: UNDETERMINED conditionIndex: expected: 501 actual: 501 conditionText: expected: CA10__numCompletedTasksSum7d__c.isEmpty() actual: CA10__numCompletedTasksSum7d__c.isEmpty() runtimeError: {} - id: CA10__avgAllCpuSystemLoad14d__c-zero match: true status: expected: UNDETERMINED actual: UNDETERMINED conditionIndex: expected: 499 actual: 499 conditionText: expected: extract('CA10__avgAllCpuSystemLoad14d__c') <= number(0.0) || extract('CA10__avgAllCpuSystemLoad14d__c') > number(100.0) || extract('CA10__avgAllJvmHeapUsage14d__c') <= number(0.0) || extract('CA10__avgAllJvmHeapUsage14d__c') > number(100.0) || extract('CA10__avgDriverCpuSystemLoad14d__c') <= number(0.0) || extract('CA10__avgDriverCpuSystemLoad14d__c') > number(100.0) || extract('CA10__avgDriverJvmHeapUsage14d__c') <= number(0.0) || extract('CA10__avgDriverJvmHeapUsage14d__c') > number(100.0) actual: extract('CA10__avgAllCpuSystemLoad14d__c') <= number(0.0) || extract('CA10__avgAllCpuSystemLoad14d__c') > number(100.0) || extract('CA10__avgAllJvmHeapUsage14d__c') <= number(0.0) || extract('CA10__avgAllJvmHeapUsage14d__c') > number(100.0) || extract('CA10__avgDriverCpuSystemLoad14d__c') <= number(0.0) || extract('CA10__avgDriverCpuSystemLoad14d__c') > number(100.0) || extract('CA10__avgDriverJvmHeapUsage14d__c') <= number(0.0) || extract('CA10__avgDriverJvmHeapUsage14d__c') > number(100.0) runtimeError: {} - id: CA10__avgAllJvmHeapUsage14d__c-zero match: true status: expected: UNDETERMINED actual: UNDETERMINED conditionIndex: expected: 499 actual: 499 conditionText: expected: extract('CA10__avgAllCpuSystemLoad14d__c') <= number(0.0) || extract('CA10__avgAllCpuSystemLoad14d__c') > number(100.0) || extract('CA10__avgAllJvmHeapUsage14d__c') <= number(0.0) || extract('CA10__avgAllJvmHeapUsage14d__c') > number(100.0) || extract('CA10__avgDriverCpuSystemLoad14d__c') <= number(0.0) || extract('CA10__avgDriverCpuSystemLoad14d__c') > number(100.0) || extract('CA10__avgDriverJvmHeapUsage14d__c') <= number(0.0) || extract('CA10__avgDriverJvmHeapUsage14d__c') > number(100.0) actual: extract('CA10__avgAllCpuSystemLoad14d__c') <= number(0.0) || extract('CA10__avgAllCpuSystemLoad14d__c') > number(100.0) || extract('CA10__avgAllJvmHeapUsage14d__c') <= number(0.0) || extract('CA10__avgAllJvmHeapUsage14d__c') > number(100.0) || extract('CA10__avgDriverCpuSystemLoad14d__c') <= number(0.0) || extract('CA10__avgDriverCpuSystemLoad14d__c') > number(100.0) || extract('CA10__avgDriverJvmHeapUsage14d__c') <= number(0.0) || extract('CA10__avgDriverJvmHeapUsage14d__c') > number(100.0) runtimeError: {} - id: CA10__avgDriverCpuSystemLoad14d__c-zero match: true status: expected: UNDETERMINED actual: UNDETERMINED conditionIndex: expected: 499 actual: 499 conditionText: expected: extract('CA10__avgAllCpuSystemLoad14d__c') <= number(0.0) || extract('CA10__avgAllCpuSystemLoad14d__c') > number(100.0) || extract('CA10__avgAllJvmHeapUsage14d__c') <= number(0.0) || extract('CA10__avgAllJvmHeapUsage14d__c') > number(100.0) || extract('CA10__avgDriverCpuSystemLoad14d__c') <= number(0.0) || extract('CA10__avgDriverCpuSystemLoad14d__c') > number(100.0) || extract('CA10__avgDriverJvmHeapUsage14d__c') <= number(0.0) || extract('CA10__avgDriverJvmHeapUsage14d__c') > number(100.0) actual: extract('CA10__avgAllCpuSystemLoad14d__c') <= number(0.0) || extract('CA10__avgAllCpuSystemLoad14d__c') > number(100.0) || extract('CA10__avgAllJvmHeapUsage14d__c') <= number(0.0) || extract('CA10__avgAllJvmHeapUsage14d__c') > number(100.0) || extract('CA10__avgDriverCpuSystemLoad14d__c') <= number(0.0) || extract('CA10__avgDriverCpuSystemLoad14d__c') > number(100.0) || extract('CA10__avgDriverJvmHeapUsage14d__c') <= number(0.0) || extract('CA10__avgDriverJvmHeapUsage14d__c') > number(100.0) runtimeError: {} - id: CA10__avgDriverJvmHeapUsage14d__c-zero match: true status: expected: UNDETERMINED actual: UNDETERMINED conditionIndex: expected: 499 actual: 499 conditionText: expected: extract('CA10__avgAllCpuSystemLoad14d__c') <= number(0.0) || extract('CA10__avgAllCpuSystemLoad14d__c') > number(100.0) || extract('CA10__avgAllJvmHeapUsage14d__c') <= number(0.0) || extract('CA10__avgAllJvmHeapUsage14d__c') > number(100.0) || extract('CA10__avgDriverCpuSystemLoad14d__c') <= number(0.0) || extract('CA10__avgDriverCpuSystemLoad14d__c') > number(100.0) || extract('CA10__avgDriverJvmHeapUsage14d__c') <= number(0.0) || extract('CA10__avgDriverJvmHeapUsage14d__c') > number(100.0) actual: extract('CA10__avgAllCpuSystemLoad14d__c') <= number(0.0) || extract('CA10__avgAllCpuSystemLoad14d__c') > number(100.0) || extract('CA10__avgAllJvmHeapUsage14d__c') <= number(0.0) || extract('CA10__avgAllJvmHeapUsage14d__c') > number(100.0) || extract('CA10__avgDriverCpuSystemLoad14d__c') <= number(0.0) || extract('CA10__avgDriverCpuSystemLoad14d__c') > number(100.0) || extract('CA10__avgDriverJvmHeapUsage14d__c') <= number(0.0) || extract('CA10__avgDriverJvmHeapUsage14d__c') > number(100.0) runtimeError: {} - id: small-positive-utilization match: true status: expected: INCOMPLIANT actual: INCOMPLIANT conditionIndex: expected: 699 actual: 699 conditionText: expected: extract('CA10__avgAllCpuSystemLoad14d__c') < number(20.0) && extract('CA10__avgAllJvmHeapUsage14d__c') < number(20.0) && extract('CA10__avgDriverCpuSystemLoad14d__c') < number(20.0) && extract('CA10__avgDriverJvmHeapUsage14d__c') < number(20.0) actual: extract('CA10__avgAllCpuSystemLoad14d__c') < number(20.0) && extract('CA10__avgAllJvmHeapUsage14d__c') < number(20.0) && extract('CA10__avgDriverCpuSystemLoad14d__c') < number(20.0) && extract('CA10__avgDriverJvmHeapUsage14d__c') < number(20.0) runtimeError: {} - id: unsupported-command-without-metrics match: true status: expected: INAPPLICABLE actual: INAPPLICABLE conditionIndex: expected: 199 actual: 199 conditionText: expected: extract('CA10__commandName__c') != 'glueetl' actual: extract('CA10__commandName__c') != 'glueetl' runtimeError: {} usedFiles: - path: /ce/ca/aws/glue/job-underutilized/policy.yaml md5Hash: DC1B0585B82D53F14F7420F1A3E50286 content: | --- names: full: AWS Glue Job is underutilized contextual: Job is underutilized description: > Identify recurring Apache Spark batch ETL jobs with positive workload activity and 14-day average driver and executor CPU and JVM heap utilization below 20% for a performance and cost-optimization review. type: BEST_PRACTICE categories: - COST - PERFORMANCE frameworkMappings: - /frameworks/cloudaware/cost-efficiency-and-optimization/resource-right-sizing - /frameworks/cloudaware/resource-performance/workload-efficiency - path: /ce/ca/aws/glue/job-underutilized/prod.logic.yaml md5Hash: 08B8ECD9A505B347A528A951FBE6125E content: | --- inputType: CA10__CaAwsGlueJob__c importExtracts: - file: /types/CA10__CaAwsGlueJob__c/object.extracts.yaml testData: - file: test-data.json conditions: - status: INAPPLICABLE currentStateMessage: This policy applies only to Apache Spark batch ETL jobs. check: NOT_EQUAL: left: EXTRACT: CA10__commandName__c right: TEXT: glueetl - status: INAPPLICABLE currentStateMessage: The job was not created before UTC midnight 14 days ago. check: NOT: arg: IS_BEYOND_LAST_DAYS: offsetDays: 14 arg: EXTRACT: CA10__createdOn__c - status: UNDETERMINED currentStateMessage: No completed Spark tasks were observed; the utilization assessment is inconclusive. check: LESS_THAN_EQUAL: left: EXTRACT: CA10__numCompletedTasksSum14d__c right: NUMBER: 0 - status: UNDETERMINED currentStateMessage: At least one 14-day utilization percentage is zero or outside the valid 0 to 100 range; positive utilization evidence is required. check: OR: args: - LESS_THAN_EQUAL: left: EXTRACT: CA10__avgAllCpuSystemLoad14d__c right: NUMBER: 0 - GREATER_THAN: left: EXTRACT: CA10__avgAllCpuSystemLoad14d__c right: NUMBER: 100 - LESS_THAN_EQUAL: left: EXTRACT: CA10__avgAllJvmHeapUsage14d__c right: NUMBER: 0 - GREATER_THAN: left: EXTRACT: CA10__avgAllJvmHeapUsage14d__c right: NUMBER: 100 - LESS_THAN_EQUAL: left: EXTRACT: CA10__avgDriverCpuSystemLoad14d__c right: NUMBER: 0 - GREATER_THAN: left: EXTRACT: CA10__avgDriverCpuSystemLoad14d__c right: NUMBER: 100 - LESS_THAN_EQUAL: left: EXTRACT: CA10__avgDriverJvmHeapUsage14d__c right: NUMBER: 0 - GREATER_THAN: left: EXTRACT: CA10__avgDriverJvmHeapUsage14d__c right: NUMBER: 100 - status: UNDETERMINED currentStateMessage: Completed-task totals do not establish activity in both halves of the 14-day period, or the totals are inconsistent. check: OR: args: - LESS_THAN_EQUAL: left: EXTRACT: CA10__numCompletedTasksSum7d__c right: NUMBER: 0 - LESS_THAN_EQUAL: left: EXTRACT: CA10__numCompletedTasksSum14d__c right: EXTRACT: CA10__numCompletedTasksSum7d__c - status: INCOMPLIANT currentStateMessage: The job completed tasks in both halves of the 14-day period, and average driver and executor CPU and JVM heap utilization are all positive and below 20%. remediationMessage: Review worker sizing, parallelism, peak demand, disk usage, and actual Auto Scaling allocation. Benchmark changes before reducing capacity. check: AND: args: - LESS_THAN: left: EXTRACT: CA10__avgAllCpuSystemLoad14d__c right: NUMBER: 20 - LESS_THAN: left: EXTRACT: CA10__avgAllJvmHeapUsage14d__c right: NUMBER: 20 - LESS_THAN: left: EXTRACT: CA10__avgDriverCpuSystemLoad14d__c right: NUMBER: 20 - LESS_THAN: left: EXTRACT: CA10__avgDriverJvmHeapUsage14d__c right: NUMBER: 20 otherwise: status: COMPLIANT currentStateMessage: At least one driver or executor CPU or JVM heap average is 20% or higher; the low-average criterion is not met. This does not establish appropriate job sizing. - path: /ce/ca/aws/glue/job-underutilized/test-data.json md5Hash: 16B1174A8B68A510EEAE765225B4EC95 content: | [ { "expectedResult": { "status": "INCOMPLIANT", "conditionIndex": "699", "conditionText": "extract('CA10__avgAllCpuSystemLoad14d__c') < number(20.0) && extract('CA10__avgAllJvmHeapUsage14d__c') < number(20.0) && extract('CA10__avgDriverCpuSystemLoad14d__c') < number(20.0) && extract('CA10__avgDriverJvmHeapUsage14d__c') < number(20.0)", "runtimeError": null }, "context": { "snapshotTime": "2026-10-13T12:00:00Z" }, "Id": "low-utilization", "CA10__disappearanceTime__c": null, "CA10__commandName__c": "glueetl", "CA10__createdOn__c": "2026-08-01T00:00:00Z", "CA10__numCompletedTasksSum14d__c": 100, "CA10__avgAllCpuSystemLoad14d__c": 10, "CA10__avgAllJvmHeapUsage14d__c": 10, "CA10__avgDriverCpuSystemLoad14d__c": 10, "CA10__avgDriverJvmHeapUsage14d__c": 10, "CA10__numCompletedTasksSum7d__c": 50 }, { "expectedResult": { "status": "COMPLIANT", "conditionIndex": "700", "conditionText": "otherwise", "runtimeError": null }, "context": { "snapshotTime": "2026-10-13T12:00:00Z" }, "Id": "CA10__avgAllCpuSystemLoad14d__c-20", "CA10__disappearanceTime__c": null, "CA10__commandName__c": "glueetl", "CA10__createdOn__c": "2026-08-01T00:00:00Z", "CA10__numCompletedTasksSum14d__c": 100, "CA10__avgAllCpuSystemLoad14d__c": 20, "CA10__avgAllJvmHeapUsage14d__c": 10, "CA10__avgDriverCpuSystemLoad14d__c": 10, "CA10__avgDriverJvmHeapUsage14d__c": 10, "CA10__numCompletedTasksSum7d__c": 50 }, { "expectedResult": { "status": "COMPLIANT", "conditionIndex": "700", "conditionText": "otherwise", "runtimeError": null }, "context": { "snapshotTime": "2026-10-13T12:00:00Z" }, "Id": "CA10__avgAllCpuSystemLoad14d__c-100", "CA10__disappearanceTime__c": null, "CA10__commandName__c": "glueetl", "CA10__createdOn__c": "2026-08-01T00:00:00Z", "CA10__numCompletedTasksSum14d__c": 100, "CA10__avgAllCpuSystemLoad14d__c": 100, "CA10__avgAllJvmHeapUsage14d__c": 10, "CA10__avgDriverCpuSystemLoad14d__c": 10, "CA10__avgDriverJvmHeapUsage14d__c": 10, "CA10__numCompletedTasksSum7d__c": 50 }, { "expectedResult": { "status": "UNDETERMINED", "conditionIndex": "401", "conditionText": "CA10__avgAllCpuSystemLoad14d__c.isEmpty()", "runtimeError": null }, "context": { "snapshotTime": "2026-10-13T12:00:00Z" }, "Id": "CA10__avgAllCpuSystemLoad14d__c-None", "CA10__disappearanceTime__c": null, "CA10__commandName__c": "glueetl", "CA10__createdOn__c": "2026-08-01T00:00:00Z", "CA10__numCompletedTasksSum14d__c": 100, "CA10__avgAllCpuSystemLoad14d__c": null, "CA10__avgAllJvmHeapUsage14d__c": 10, "CA10__avgDriverCpuSystemLoad14d__c": 10, "CA10__avgDriverJvmHeapUsage14d__c": 10, "CA10__numCompletedTasksSum7d__c": 50 }, { "expectedResult": { "status": "UNDETERMINED", "conditionIndex": "499", "conditionText": "extract('CA10__avgAllCpuSystemLoad14d__c') <= number(0.0) || extract('CA10__avgAllCpuSystemLoad14d__c') > number(100.0) || extract('CA10__avgAllJvmHeapUsage14d__c') <= number(0.0) || extract('CA10__avgAllJvmHeapUsage14d__c') > number(100.0) || extract('CA10__avgDriverCpuSystemLoad14d__c') <= number(0.0) || extract('CA10__avgDriverCpuSystemLoad14d__c') > number(100.0) || extract('CA10__avgDriverJvmHeapUsage14d__c') <= number(0.0) || extract('CA10__avgDriverJvmHeapUsage14d__c') > number(100.0)", "runtimeError": null }, "context": { "snapshotTime": "2026-10-13T12:00:00Z" }, "Id": "CA10__avgAllCpuSystemLoad14d__c--1", "CA10__disappearanceTime__c": null, "CA10__commandName__c": "glueetl", "CA10__createdOn__c": "2026-08-01T00:00:00Z", "CA10__numCompletedTasksSum14d__c": 100, "CA10__avgAllCpuSystemLoad14d__c": -1, "CA10__avgAllJvmHeapUsage14d__c": 10, "CA10__avgDriverCpuSystemLoad14d__c": 10, "CA10__avgDriverJvmHeapUsage14d__c": 10, "CA10__numCompletedTasksSum7d__c": 50 }, { "expectedResult": { "status": "UNDETERMINED", "conditionIndex": "499", "conditionText": "extract('CA10__avgAllCpuSystemLoad14d__c') <= number(0.0) || extract('CA10__avgAllCpuSystemLoad14d__c') > number(100.0) || extract('CA10__avgAllJvmHeapUsage14d__c') <= number(0.0) || extract('CA10__avgAllJvmHeapUsage14d__c') > number(100.0) || extract('CA10__avgDriverCpuSystemLoad14d__c') <= number(0.0) || extract('CA10__avgDriverCpuSystemLoad14d__c') > number(100.0) || extract('CA10__avgDriverJvmHeapUsage14d__c') <= number(0.0) || extract('CA10__avgDriverJvmHeapUsage14d__c') > number(100.0)", "runtimeError": null }, "context": { "snapshotTime": "2026-10-13T12:00:00Z" }, "Id": "CA10__avgAllCpuSystemLoad14d__c-101", "CA10__disappearanceTime__c": null, "CA10__commandName__c": "glueetl", "CA10__createdOn__c": "2026-08-01T00:00:00Z", "CA10__numCompletedTasksSum14d__c": 100, "CA10__avgAllCpuSystemLoad14d__c": 101, "CA10__avgAllJvmHeapUsage14d__c": 10, "CA10__avgDriverCpuSystemLoad14d__c": 10, "CA10__avgDriverJvmHeapUsage14d__c": 10, "CA10__numCompletedTasksSum7d__c": 50 }, { "expectedResult": { "status": "COMPLIANT", "conditionIndex": "700", "conditionText": "otherwise", "runtimeError": null }, "context": { "snapshotTime": "2026-10-13T12:00:00Z" }, "Id": "CA10__avgAllJvmHeapUsage14d__c-20", "CA10__disappearanceTime__c": null, "CA10__commandName__c": "glueetl", "CA10__createdOn__c": "2026-08-01T00:00:00Z", "CA10__numCompletedTasksSum14d__c": 100, "CA10__avgAllCpuSystemLoad14d__c": 10, "CA10__avgAllJvmHeapUsage14d__c": 20, "CA10__avgDriverCpuSystemLoad14d__c": 10, "CA10__avgDriverJvmHeapUsage14d__c": 10, "CA10__numCompletedTasksSum7d__c": 50 }, { "expectedResult": { "status": "COMPLIANT", "conditionIndex": "700", "conditionText": "otherwise", "runtimeError": null }, "context": { "snapshotTime": "2026-10-13T12:00:00Z" }, "Id": "CA10__avgAllJvmHeapUsage14d__c-100", "CA10__disappearanceTime__c": null, "CA10__commandName__c": "glueetl", "CA10__createdOn__c": "2026-08-01T00:00:00Z", "CA10__numCompletedTasksSum14d__c": 100, "CA10__avgAllCpuSystemLoad14d__c": 10, "CA10__avgAllJvmHeapUsage14d__c": 100, "CA10__avgDriverCpuSystemLoad14d__c": 10, "CA10__avgDriverJvmHeapUsage14d__c": 10, "CA10__numCompletedTasksSum7d__c": 50 }, { "expectedResult": { "status": "UNDETERMINED", "conditionIndex": "402", "conditionText": "CA10__avgAllJvmHeapUsage14d__c.isEmpty()", "runtimeError": null }, "context": { "snapshotTime": "2026-10-13T12:00:00Z" }, "Id": "CA10__avgAllJvmHeapUsage14d__c-None", "CA10__disappearanceTime__c": null, "CA10__commandName__c": "glueetl", "CA10__createdOn__c": "2026-08-01T00:00:00Z", "CA10__numCompletedTasksSum14d__c": 100, "CA10__avgAllCpuSystemLoad14d__c": 10, "CA10__avgAllJvmHeapUsage14d__c": null, "CA10__avgDriverCpuSystemLoad14d__c": 10, "CA10__avgDriverJvmHeapUsage14d__c": 10, "CA10__numCompletedTasksSum7d__c": 50 }, { "expectedResult": { "status": "UNDETERMINED", "conditionIndex": "499", "conditionText": "extract('CA10__avgAllCpuSystemLoad14d__c') <= number(0.0) || extract('CA10__avgAllCpuSystemLoad14d__c') > number(100.0) || extract('CA10__avgAllJvmHeapUsage14d__c') <= number(0.0) || extract('CA10__avgAllJvmHeapUsage14d__c') > number(100.0) || extract('CA10__avgDriverCpuSystemLoad14d__c') <= number(0.0) || extract('CA10__avgDriverCpuSystemLoad14d__c') > number(100.0) || extract('CA10__avgDriverJvmHeapUsage14d__c') <= number(0.0) || extract('CA10__avgDriverJvmHeapUsage14d__c') > number(100.0)", "runtimeError": null }, "context": { "snapshotTime": "2026-10-13T12:00:00Z" }, "Id": "CA10__avgAllJvmHeapUsage14d__c--1", "CA10__disappearanceTime__c": null, "CA10__commandName__c": "glueetl", "CA10__createdOn__c": "2026-08-01T00:00:00Z", "CA10__numCompletedTasksSum14d__c": 100, "CA10__avgAllCpuSystemLoad14d__c": 10, "CA10__avgAllJvmHeapUsage14d__c": -1, "CA10__avgDriverCpuSystemLoad14d__c": 10, "CA10__avgDriverJvmHeapUsage14d__c": 10, "CA10__numCompletedTasksSum7d__c": 50 }, { "expectedResult": { "status": "UNDETERMINED", "conditionIndex": "499", "conditionText": "extract('CA10__avgAllCpuSystemLoad14d__c') <= number(0.0) || extract('CA10__avgAllCpuSystemLoad14d__c') > number(100.0) || extract('CA10__avgAllJvmHeapUsage14d__c') <= number(0.0) || extract('CA10__avgAllJvmHeapUsage14d__c') > number(100.0) || extract('CA10__avgDriverCpuSystemLoad14d__c') <= number(0.0) || extract('CA10__avgDriverCpuSystemLoad14d__c') > number(100.0) || extract('CA10__avgDriverJvmHeapUsage14d__c') <= number(0.0) || extract('CA10__avgDriverJvmHeapUsage14d__c') > number(100.0)", "runtimeError": null }, "context": { "snapshotTime": "2026-10-13T12:00:00Z" }, "Id": "CA10__avgAllJvmHeapUsage14d__c-101", "CA10__disappearanceTime__c": null, "CA10__commandName__c": "glueetl", "CA10__createdOn__c": "2026-08-01T00:00:00Z", "CA10__numCompletedTasksSum14d__c": 100, "CA10__avgAllCpuSystemLoad14d__c": 10, "CA10__avgAllJvmHeapUsage14d__c": 101, "CA10__avgDriverCpuSystemLoad14d__c": 10, "CA10__avgDriverJvmHeapUsage14d__c": 10, "CA10__numCompletedTasksSum7d__c": 50 }, { "expectedResult": { "status": "COMPLIANT", "conditionIndex": "700", "conditionText": "otherwise", "runtimeError": null }, "context": { "snapshotTime": "2026-10-13T12:00:00Z" }, "Id": "CA10__avgDriverCpuSystemLoad14d__c-20", "CA10__disappearanceTime__c": null, "CA10__commandName__c": "glueetl", "CA10__createdOn__c": "2026-08-01T00:00:00Z", "CA10__numCompletedTasksSum14d__c": 100, "CA10__avgAllCpuSystemLoad14d__c": 10, "CA10__avgAllJvmHeapUsage14d__c": 10, "CA10__avgDriverCpuSystemLoad14d__c": 20, "CA10__avgDriverJvmHeapUsage14d__c": 10, "CA10__numCompletedTasksSum7d__c": 50 }, { "expectedResult": { "status": "COMPLIANT", "conditionIndex": "700", "conditionText": "otherwise", "runtimeError": null }, "context": { "snapshotTime": "2026-10-13T12:00:00Z" }, "Id": "CA10__avgDriverCpuSystemLoad14d__c-100", "CA10__disappearanceTime__c": null, "CA10__commandName__c": "glueetl", "CA10__createdOn__c": "2026-08-01T00:00:00Z", "CA10__numCompletedTasksSum14d__c": 100, "CA10__avgAllCpuSystemLoad14d__c": 10, "CA10__avgAllJvmHeapUsage14d__c": 10, "CA10__avgDriverCpuSystemLoad14d__c": 100, "CA10__avgDriverJvmHeapUsage14d__c": 10, "CA10__numCompletedTasksSum7d__c": 50 }, { "expectedResult": { "status": "UNDETERMINED", "conditionIndex": "403", "conditionText": "CA10__avgDriverCpuSystemLoad14d__c.isEmpty()", "runtimeError": null }, "context": { "snapshotTime": "2026-10-13T12:00:00Z" }, "Id": "CA10__avgDriverCpuSystemLoad14d__c-None", "CA10__disappearanceTime__c": null, "CA10__commandName__c": "glueetl", "CA10__createdOn__c": "2026-08-01T00:00:00Z", "CA10__numCompletedTasksSum14d__c": 100, "CA10__avgAllCpuSystemLoad14d__c": 10, "CA10__avgAllJvmHeapUsage14d__c": 10, "CA10__avgDriverCpuSystemLoad14d__c": null, "CA10__avgDriverJvmHeapUsage14d__c": 10, "CA10__numCompletedTasksSum7d__c": 50 }, { "expectedResult": { "status": "UNDETERMINED", "conditionIndex": "499", "conditionText": "extract('CA10__avgAllCpuSystemLoad14d__c') <= number(0.0) || extract('CA10__avgAllCpuSystemLoad14d__c') > number(100.0) || extract('CA10__avgAllJvmHeapUsage14d__c') <= number(0.0) || extract('CA10__avgAllJvmHeapUsage14d__c') > number(100.0) || extract('CA10__avgDriverCpuSystemLoad14d__c') <= number(0.0) || extract('CA10__avgDriverCpuSystemLoad14d__c') > number(100.0) || extract('CA10__avgDriverJvmHeapUsage14d__c') <= number(0.0) || extract('CA10__avgDriverJvmHeapUsage14d__c') > number(100.0)", "runtimeError": null }, "context": { "snapshotTime": "2026-10-13T12:00:00Z" }, "Id": "CA10__avgDriverCpuSystemLoad14d__c--1", "CA10__disappearanceTime__c": null, "CA10__commandName__c": "glueetl", "CA10__createdOn__c": "2026-08-01T00:00:00Z", "CA10__numCompletedTasksSum14d__c": 100, "CA10__avgAllCpuSystemLoad14d__c": 10, "CA10__avgAllJvmHeapUsage14d__c": 10, "CA10__avgDriverCpuSystemLoad14d__c": -1, "CA10__avgDriverJvmHeapUsage14d__c": 10, "CA10__numCompletedTasksSum7d__c": 50 }, { "expectedResult": { "status": "UNDETERMINED", "conditionIndex": "499", "conditionText": "extract('CA10__avgAllCpuSystemLoad14d__c') <= number(0.0) || extract('CA10__avgAllCpuSystemLoad14d__c') > number(100.0) || extract('CA10__avgAllJvmHeapUsage14d__c') <= number(0.0) || extract('CA10__avgAllJvmHeapUsage14d__c') > number(100.0) || extract('CA10__avgDriverCpuSystemLoad14d__c') <= number(0.0) || extract('CA10__avgDriverCpuSystemLoad14d__c') > number(100.0) || extract('CA10__avgDriverJvmHeapUsage14d__c') <= number(0.0) || extract('CA10__avgDriverJvmHeapUsage14d__c') > number(100.0)", "runtimeError": null }, "context": { "snapshotTime": "2026-10-13T12:00:00Z" }, "Id": "CA10__avgDriverCpuSystemLoad14d__c-101", "CA10__disappearanceTime__c": null, "CA10__commandName__c": "glueetl", "CA10__createdOn__c": "2026-08-01T00:00:00Z", "CA10__numCompletedTasksSum14d__c": 100, "CA10__avgAllCpuSystemLoad14d__c": 10, "CA10__avgAllJvmHeapUsage14d__c": 10, "CA10__avgDriverCpuSystemLoad14d__c": 101, "CA10__avgDriverJvmHeapUsage14d__c": 10, "CA10__numCompletedTasksSum7d__c": 50 }, { "expectedResult": { "status": "COMPLIANT", "conditionIndex": "700", "conditionText": "otherwise", "runtimeError": null }, "context": { "snapshotTime": "2026-10-13T12:00:00Z" }, "Id": "CA10__avgDriverJvmHeapUsage14d__c-20", "CA10__disappearanceTime__c": null, "CA10__commandName__c": "glueetl", "CA10__createdOn__c": "2026-08-01T00:00:00Z", "CA10__numCompletedTasksSum14d__c": 100, "CA10__avgAllCpuSystemLoad14d__c": 10, "CA10__avgAllJvmHeapUsage14d__c": 10, "CA10__avgDriverCpuSystemLoad14d__c": 10, "CA10__avgDriverJvmHeapUsage14d__c": 20, "CA10__numCompletedTasksSum7d__c": 50 }, { "expectedResult": { "status": "COMPLIANT", "conditionIndex": "700", "conditionText": "otherwise", "runtimeError": null }, "context": { "snapshotTime": "2026-10-13T12:00:00Z" }, "Id": "CA10__avgDriverJvmHeapUsage14d__c-100", "CA10__disappearanceTime__c": null, "CA10__commandName__c": "glueetl", "CA10__createdOn__c": "2026-08-01T00:00:00Z", "CA10__numCompletedTasksSum14d__c": 100, "CA10__avgAllCpuSystemLoad14d__c": 10, "CA10__avgAllJvmHeapUsage14d__c": 10, "CA10__avgDriverCpuSystemLoad14d__c": 10, "CA10__avgDriverJvmHeapUsage14d__c": 100, "CA10__numCompletedTasksSum7d__c": 50 }, { "expectedResult": { "status": "UNDETERMINED", "conditionIndex": "404", "conditionText": "CA10__avgDriverJvmHeapUsage14d__c.isEmpty()", "runtimeError": null }, "context": { "snapshotTime": "2026-10-13T12:00:00Z" }, "Id": "CA10__avgDriverJvmHeapUsage14d__c-None", "CA10__disappearanceTime__c": null, "CA10__commandName__c": "glueetl", "CA10__createdOn__c": "2026-08-01T00:00:00Z", "CA10__numCompletedTasksSum14d__c": 100, "CA10__avgAllCpuSystemLoad14d__c": 10, "CA10__avgAllJvmHeapUsage14d__c": 10, "CA10__avgDriverCpuSystemLoad14d__c": 10, "CA10__avgDriverJvmHeapUsage14d__c": null, "CA10__numCompletedTasksSum7d__c": 50 }, { "expectedResult": { "status": "UNDETERMINED", "conditionIndex": "499", "conditionText": "extract('CA10__avgAllCpuSystemLoad14d__c') <= number(0.0) || extract('CA10__avgAllCpuSystemLoad14d__c') > number(100.0) || extract('CA10__avgAllJvmHeapUsage14d__c') <= number(0.0) || extract('CA10__avgAllJvmHeapUsage14d__c') > number(100.0) || extract('CA10__avgDriverCpuSystemLoad14d__c') <= number(0.0) || extract('CA10__avgDriverCpuSystemLoad14d__c') > number(100.0) || extract('CA10__avgDriverJvmHeapUsage14d__c') <= number(0.0) || extract('CA10__avgDriverJvmHeapUsage14d__c') > number(100.0)", "runtimeError": null }, "context": { "snapshotTime": "2026-10-13T12:00:00Z" }, "Id": "CA10__avgDriverJvmHeapUsage14d__c--1", "CA10__disappearanceTime__c": null, "CA10__commandName__c": "glueetl", "CA10__createdOn__c": "2026-08-01T00:00:00Z", "CA10__numCompletedTasksSum14d__c": 100, "CA10__avgAllCpuSystemLoad14d__c": 10, "CA10__avgAllJvmHeapUsage14d__c": 10, "CA10__avgDriverCpuSystemLoad14d__c": 10, "CA10__avgDriverJvmHeapUsage14d__c": -1, "CA10__numCompletedTasksSum7d__c": 50 }, { "expectedResult": { "status": "UNDETERMINED", "conditionIndex": "499", "conditionText": "extract('CA10__avgAllCpuSystemLoad14d__c') <= number(0.0) || extract('CA10__avgAllCpuSystemLoad14d__c') > number(100.0) || extract('CA10__avgAllJvmHeapUsage14d__c') <= number(0.0) || extract('CA10__avgAllJvmHeapUsage14d__c') > number(100.0) || extract('CA10__avgDriverCpuSystemLoad14d__c') <= number(0.0) || extract('CA10__avgDriverCpuSystemLoad14d__c') > number(100.0) || extract('CA10__avgDriverJvmHeapUsage14d__c') <= number(0.0) || extract('CA10__avgDriverJvmHeapUsage14d__c') > number(100.0)", "runtimeError": null }, "context": { "snapshotTime": "2026-10-13T12:00:00Z" }, "Id": "CA10__avgDriverJvmHeapUsage14d__c-101", "CA10__disappearanceTime__c": null, "CA10__commandName__c": "glueetl", "CA10__createdOn__c": "2026-08-01T00:00:00Z", "CA10__numCompletedTasksSum14d__c": 100, "CA10__avgAllCpuSystemLoad14d__c": 10, "CA10__avgAllJvmHeapUsage14d__c": 10, "CA10__avgDriverCpuSystemLoad14d__c": 10, "CA10__avgDriverJvmHeapUsage14d__c": 101, "CA10__numCompletedTasksSum7d__c": 50 }, { "expectedResult": { "status": "UNDETERMINED", "conditionIndex": "301", "conditionText": "CA10__numCompletedTasksSum14d__c.isEmpty()", "runtimeError": null }, "context": { "snapshotTime": "2026-10-13T12:00:00Z" }, "Id": "tasks-None", "CA10__disappearanceTime__c": null, "CA10__commandName__c": "glueetl", "CA10__createdOn__c": "2026-08-01T00:00:00Z", "CA10__numCompletedTasksSum14d__c": null, "CA10__avgAllCpuSystemLoad14d__c": 10, "CA10__avgAllJvmHeapUsage14d__c": 10, "CA10__avgDriverCpuSystemLoad14d__c": 10, "CA10__avgDriverJvmHeapUsage14d__c": 10, "CA10__numCompletedTasksSum7d__c": 50 }, { "expectedResult": { "status": "UNDETERMINED", "conditionIndex": "399", "conditionText": "extract('CA10__numCompletedTasksSum14d__c') <= number(0.0)", "runtimeError": null }, "context": { "snapshotTime": "2026-10-13T12:00:00Z" }, "Id": "tasks-0", "CA10__disappearanceTime__c": null, "CA10__commandName__c": "glueetl", "CA10__createdOn__c": "2026-08-01T00:00:00Z", "CA10__numCompletedTasksSum14d__c": 0, "CA10__avgAllCpuSystemLoad14d__c": 10, "CA10__avgAllJvmHeapUsage14d__c": 10, "CA10__avgDriverCpuSystemLoad14d__c": 10, "CA10__avgDriverJvmHeapUsage14d__c": 10, "CA10__numCompletedTasksSum7d__c": 50 }, { "expectedResult": { "status": "UNDETERMINED", "conditionIndex": "399", "conditionText": "extract('CA10__numCompletedTasksSum14d__c') <= number(0.0)", "runtimeError": null }, "context": { "snapshotTime": "2026-10-13T12:00:00Z" }, "Id": "tasks--1", "CA10__disappearanceTime__c": null, "CA10__commandName__c": "glueetl", "CA10__createdOn__c": "2026-08-01T00:00:00Z", "CA10__numCompletedTasksSum14d__c": -1, "CA10__avgAllCpuSystemLoad14d__c": 10, "CA10__avgAllJvmHeapUsage14d__c": 10, "CA10__avgDriverCpuSystemLoad14d__c": 10, "CA10__avgDriverJvmHeapUsage14d__c": 10, "CA10__numCompletedTasksSum7d__c": 50 }, { "expectedResult": { "status": "INAPPLICABLE", "conditionIndex": "199", "conditionText": "extract('CA10__commandName__c') != 'glueetl'", "runtimeError": null }, "context": { "snapshotTime": "2026-10-13T12:00:00Z" }, "Id": "command-pythonshell", "CA10__disappearanceTime__c": null, "CA10__commandName__c": "pythonshell", "CA10__createdOn__c": "2026-08-01T00:00:00Z", "CA10__numCompletedTasksSum14d__c": 100, "CA10__avgAllCpuSystemLoad14d__c": 10, "CA10__avgAllJvmHeapUsage14d__c": 10, "CA10__avgDriverCpuSystemLoad14d__c": 10, "CA10__avgDriverJvmHeapUsage14d__c": 10, "CA10__numCompletedTasksSum7d__c": 50 }, { "expectedResult": { "status": "INAPPLICABLE", "conditionIndex": "199", "conditionText": "extract('CA10__commandName__c') != 'glueetl'", "runtimeError": null }, "context": { "snapshotTime": "2026-10-13T12:00:00Z" }, "Id": "command-gluestreaming", "CA10__disappearanceTime__c": null, "CA10__commandName__c": "gluestreaming", "CA10__createdOn__c": "2026-08-01T00:00:00Z", "CA10__numCompletedTasksSum14d__c": 100, "CA10__avgAllCpuSystemLoad14d__c": 10, "CA10__avgAllJvmHeapUsage14d__c": 10, "CA10__avgDriverCpuSystemLoad14d__c": 10, "CA10__avgDriverJvmHeapUsage14d__c": 10, "CA10__numCompletedTasksSum7d__c": 50 }, { "expectedResult": { "status": "UNDETERMINED", "conditionIndex": "101", "conditionText": "CA10__commandName__c.isEmpty()", "runtimeError": null }, "context": { "snapshotTime": "2026-10-13T12:00:00Z" }, "Id": "command-None", "CA10__disappearanceTime__c": null, "CA10__commandName__c": null, "CA10__createdOn__c": "2026-08-01T00:00:00Z", "CA10__numCompletedTasksSum14d__c": 100, "CA10__avgAllCpuSystemLoad14d__c": 10, "CA10__avgAllJvmHeapUsage14d__c": 10, "CA10__avgDriverCpuSystemLoad14d__c": 10, "CA10__avgDriverJvmHeapUsage14d__c": 10, "CA10__numCompletedTasksSum7d__c": 50 }, { "expectedResult": { "status": "INAPPLICABLE", "conditionIndex": "299", "conditionText": "not(extract('CA10__createdOn__c').beyondLastDays(14))", "runtimeError": null }, "context": { "snapshotTime": "2026-10-13T12:00:00Z" }, "Id": "created-2026-10-12T00:00:00Z", "CA10__disappearanceTime__c": null, "CA10__commandName__c": "glueetl", "CA10__createdOn__c": "2026-10-12T00:00:00Z", "CA10__numCompletedTasksSum14d__c": 100, "CA10__avgAllCpuSystemLoad14d__c": 10, "CA10__avgAllJvmHeapUsage14d__c": 10, "CA10__avgDriverCpuSystemLoad14d__c": 10, "CA10__avgDriverJvmHeapUsage14d__c": 10, "CA10__numCompletedTasksSum7d__c": 50 }, { "expectedResult": { "status": "INAPPLICABLE", "conditionIndex": "299", "conditionText": "not(extract('CA10__createdOn__c').beyondLastDays(14))", "runtimeError": null }, "context": { "snapshotTime": "2026-10-13T12:00:00Z" }, "Id": "created-2026-09-29T00:00:00Z", "CA10__disappearanceTime__c": null, "CA10__commandName__c": "glueetl", "CA10__createdOn__c": "2026-09-29T00:00:00Z", "CA10__numCompletedTasksSum14d__c": 100, "CA10__avgAllCpuSystemLoad14d__c": 10, "CA10__avgAllJvmHeapUsage14d__c": 10, "CA10__avgDriverCpuSystemLoad14d__c": 10, "CA10__avgDriverJvmHeapUsage14d__c": 10, "CA10__numCompletedTasksSum7d__c": 50 }, { "expectedResult": { "status": "UNDETERMINED", "conditionIndex": "201", "conditionText": "CA10__createdOn__c.isEmpty()", "runtimeError": null }, "context": { "snapshotTime": "2026-10-13T12:00:00Z" }, "Id": "created-None", "CA10__disappearanceTime__c": null, "CA10__commandName__c": "glueetl", "CA10__createdOn__c": null, "CA10__numCompletedTasksSum14d__c": 100, "CA10__avgAllCpuSystemLoad14d__c": 10, "CA10__avgAllJvmHeapUsage14d__c": 10, "CA10__avgDriverCpuSystemLoad14d__c": 10, "CA10__avgDriverJvmHeapUsage14d__c": 10, "CA10__numCompletedTasksSum7d__c": 50 }, { "expectedResult": { "status": "DISAPPEARED", "conditionIndex": "99", "conditionText": "isDisappeared(CA10__disappearanceTime__c)", "runtimeError": null }, "context": { "snapshotTime": "2026-10-13T12:00:00Z" }, "Id": "disappeared", "CA10__disappearanceTime__c": "2026-10-12T00:00:00Z", "CA10__commandName__c": "glueetl", "CA10__createdOn__c": "2026-08-01T00:00:00Z", "CA10__numCompletedTasksSum14d__c": 100, "CA10__avgAllCpuSystemLoad14d__c": 10, "CA10__avgAllJvmHeapUsage14d__c": 10, "CA10__avgDriverCpuSystemLoad14d__c": 10, "CA10__avgDriverJvmHeapUsage14d__c": 10, "CA10__numCompletedTasksSum7d__c": 50 }, { "expectedResult": { "status": "UNDETERMINED", "conditionIndex": "499", "conditionText": "extract('CA10__avgAllCpuSystemLoad14d__c') <= number(0.0) || extract('CA10__avgAllCpuSystemLoad14d__c') > number(100.0) || extract('CA10__avgAllJvmHeapUsage14d__c') <= number(0.0) || extract('CA10__avgAllJvmHeapUsage14d__c') > number(100.0) || extract('CA10__avgDriverCpuSystemLoad14d__c') <= number(0.0) || extract('CA10__avgDriverCpuSystemLoad14d__c') > number(100.0) || extract('CA10__avgDriverJvmHeapUsage14d__c') <= number(0.0) || extract('CA10__avgDriverJvmHeapUsage14d__c') > number(100.0)", "runtimeError": null }, "context": { "snapshotTime": "2026-10-13T12:00:00Z" }, "Id": "sample-one-task-zero-executor-cpu", "CA10__disappearanceTime__c": null, "CA10__commandName__c": "glueetl", "CA10__createdOn__c": "2026-08-01T00:00:00Z", "CA10__numCompletedTasksSum14d__c": 1, "CA10__avgAllCpuSystemLoad14d__c": 0, "CA10__avgAllJvmHeapUsage14d__c": 3.4702069312334065, "CA10__avgDriverCpuSystemLoad14d__c": 2.517354516327376, "CA10__avgDriverJvmHeapUsage14d__c": 4.574851865569751, "CA10__workerType__c": "G.1X", "CA10__numberOfWorkers__c": 2, "CA10__numCompletedTasksSum7d__c": 1 }, { "expectedResult": { "status": "INCOMPLIANT", "conditionIndex": "699", "conditionText": "extract('CA10__avgAllCpuSystemLoad14d__c') < number(20.0) && extract('CA10__avgAllJvmHeapUsage14d__c') < number(20.0) && extract('CA10__avgDriverCpuSystemLoad14d__c') < number(20.0) && extract('CA10__avgDriverJvmHeapUsage14d__c') < number(20.0)", "runtimeError": null }, "context": { "snapshotTime": "2026-10-13T12:00:00Z" }, "Id": "sample-high-task-count-auto-scaling", "CA10__disappearanceTime__c": null, "CA10__commandName__c": "glueetl", "CA10__createdOn__c": "2026-08-01T00:00:00Z", "CA10__numCompletedTasksSum14d__c": 19417430, "CA10__avgAllCpuSystemLoad14d__c": 7.212892001124691, "CA10__avgAllJvmHeapUsage14d__c": 5.552194605252455, "CA10__avgDriverCpuSystemLoad14d__c": 6.932769307905659, "CA10__avgDriverJvmHeapUsage14d__c": 2.954946758152317, "CA10__workerType__c": "G.4X", "CA10__numberOfWorkers__c": 10, "CA10__defaultArguments__c": "--enable-auto-scaling: true\n--enable-metrics: true", "CA10__numCompletedTasksSum7d__c": 9000000 }, { "expectedResult": { "status": "UNDETERMINED", "conditionIndex": "499", "conditionText": "extract('CA10__avgAllCpuSystemLoad14d__c') <= number(0.0) || extract('CA10__avgAllCpuSystemLoad14d__c') > number(100.0) || extract('CA10__avgAllJvmHeapUsage14d__c') <= number(0.0) || extract('CA10__avgAllJvmHeapUsage14d__c') > number(100.0) || extract('CA10__avgDriverCpuSystemLoad14d__c') <= number(0.0) || extract('CA10__avgDriverCpuSystemLoad14d__c') > number(100.0) || extract('CA10__avgDriverJvmHeapUsage14d__c') <= number(0.0) || extract('CA10__avgDriverJvmHeapUsage14d__c') > number(100.0)", "runtimeError": null }, "context": { "snapshotTime": "2026-10-13T12:00:00Z" }, "Id": "all-zero-averages-positive-tasks", "CA10__disappearanceTime__c": null, "CA10__commandName__c": "glueetl", "CA10__createdOn__c": "2026-08-01T00:00:00Z", "CA10__numCompletedTasksSum14d__c": 100, "CA10__avgAllCpuSystemLoad14d__c": 0, "CA10__avgAllJvmHeapUsage14d__c": 0, "CA10__avgDriverCpuSystemLoad14d__c": 0, "CA10__avgDriverJvmHeapUsage14d__c": 0, "CA10__numCompletedTasksSum7d__c": 50 }, { "expectedResult": { "status": "INCOMPLIANT", "conditionIndex": "699", "conditionText": "extract('CA10__avgAllCpuSystemLoad14d__c') < number(20.0) && extract('CA10__avgAllJvmHeapUsage14d__c') < number(20.0) && extract('CA10__avgDriverCpuSystemLoad14d__c') < number(20.0) && extract('CA10__avgDriverJvmHeapUsage14d__c') < number(20.0)", "runtimeError": null }, "context": { "snapshotTime": "2026-10-13T12:00:00Z" }, "Id": "created-just-before-utc-age-boundary", "CA10__disappearanceTime__c": null, "CA10__commandName__c": "glueetl", "CA10__createdOn__c": "2026-09-28T23:59:59Z", "CA10__numCompletedTasksSum14d__c": 100, "CA10__avgAllCpuSystemLoad14d__c": 10, "CA10__avgAllJvmHeapUsage14d__c": 10, "CA10__avgDriverCpuSystemLoad14d__c": 10, "CA10__avgDriverJvmHeapUsage14d__c": 10, "CA10__numCompletedTasksSum7d__c": 50 }, { "expectedResult": { "status": "UNDETERMINED", "conditionIndex": "402", "conditionText": "CA10__avgAllJvmHeapUsage14d__c.isEmpty()", "runtimeError": null }, "context": { "snapshotTime": "2026-10-13T12:00:00Z" }, "Id": "high-cpu-missing-heap-is-not-compliant", "CA10__disappearanceTime__c": null, "CA10__commandName__c": "glueetl", "CA10__createdOn__c": "2026-08-01T00:00:00Z", "CA10__numCompletedTasksSum14d__c": 100, "CA10__avgAllCpuSystemLoad14d__c": 50, "CA10__avgAllJvmHeapUsage14d__c": null, "CA10__avgDriverCpuSystemLoad14d__c": 10, "CA10__avgDriverJvmHeapUsage14d__c": 10, "CA10__numCompletedTasksSum7d__c": 50 }, { "expectedResult": { "status": "UNDETERMINED", "conditionIndex": "599", "conditionText": "extract('CA10__numCompletedTasksSum7d__c') <= number(0.0) || extract('CA10__numCompletedTasksSum14d__c') <= extract('CA10__numCompletedTasksSum7d__c')", "runtimeError": null }, "context": { "snapshotTime": "2026-10-13T12:00:00Z" }, "Id": "activity-only-in-earlier-week", "CA10__disappearanceTime__c": null, "CA10__commandName__c": "glueetl", "CA10__createdOn__c": "2026-08-01T00:00:00Z", "CA10__numCompletedTasksSum14d__c": 100, "CA10__avgAllCpuSystemLoad14d__c": 10, "CA10__avgAllJvmHeapUsage14d__c": 10, "CA10__avgDriverCpuSystemLoad14d__c": 10, "CA10__avgDriverJvmHeapUsage14d__c": 10, "CA10__numCompletedTasksSum7d__c": 0 }, { "expectedResult": { "status": "UNDETERMINED", "conditionIndex": "599", "conditionText": "extract('CA10__numCompletedTasksSum7d__c') <= number(0.0) || extract('CA10__numCompletedTasksSum14d__c') <= extract('CA10__numCompletedTasksSum7d__c')", "runtimeError": null }, "context": { "snapshotTime": "2026-10-13T12:00:00Z" }, "Id": "activity-only-in-recent-week", "CA10__disappearanceTime__c": null, "CA10__commandName__c": "glueetl", "CA10__createdOn__c": "2026-08-01T00:00:00Z", "CA10__numCompletedTasksSum14d__c": 100, "CA10__avgAllCpuSystemLoad14d__c": 10, "CA10__avgAllJvmHeapUsage14d__c": 10, "CA10__avgDriverCpuSystemLoad14d__c": 10, "CA10__avgDriverJvmHeapUsage14d__c": 10, "CA10__numCompletedTasksSum7d__c": 100 }, { "expectedResult": { "status": "UNDETERMINED", "conditionIndex": "599", "conditionText": "extract('CA10__numCompletedTasksSum7d__c') <= number(0.0) || extract('CA10__numCompletedTasksSum14d__c') <= extract('CA10__numCompletedTasksSum7d__c')", "runtimeError": null }, "context": { "snapshotTime": "2026-10-13T12:00:00Z" }, "Id": "negative-seven-day-tasks", "CA10__disappearanceTime__c": null, "CA10__commandName__c": "glueetl", "CA10__createdOn__c": "2026-08-01T00:00:00Z", "CA10__numCompletedTasksSum14d__c": 100, "CA10__avgAllCpuSystemLoad14d__c": 10, "CA10__avgAllJvmHeapUsage14d__c": 10, "CA10__avgDriverCpuSystemLoad14d__c": 10, "CA10__avgDriverJvmHeapUsage14d__c": 10, "CA10__numCompletedTasksSum7d__c": -1 }, { "expectedResult": { "status": "UNDETERMINED", "conditionIndex": "599", "conditionText": "extract('CA10__numCompletedTasksSum7d__c') <= number(0.0) || extract('CA10__numCompletedTasksSum14d__c') <= extract('CA10__numCompletedTasksSum7d__c')", "runtimeError": null }, "context": { "snapshotTime": "2026-10-13T12:00:00Z" }, "Id": "seven-day-tasks-exceed-fourteen-day-total", "CA10__disappearanceTime__c": null, "CA10__commandName__c": "glueetl", "CA10__createdOn__c": "2026-08-01T00:00:00Z", "CA10__numCompletedTasksSum14d__c": 100, "CA10__avgAllCpuSystemLoad14d__c": 10, "CA10__avgAllJvmHeapUsage14d__c": 10, "CA10__avgDriverCpuSystemLoad14d__c": 10, "CA10__avgDriverJvmHeapUsage14d__c": 10, "CA10__numCompletedTasksSum7d__c": 101 }, { "expectedResult": { "status": "UNDETERMINED", "conditionIndex": "501", "conditionText": "CA10__numCompletedTasksSum7d__c.isEmpty()", "runtimeError": null }, "context": { "snapshotTime": "2026-10-13T12:00:00Z" }, "Id": "missing-seven-day-tasks", "CA10__disappearanceTime__c": null, "CA10__commandName__c": "glueetl", "CA10__createdOn__c": "2026-08-01T00:00:00Z", "CA10__numCompletedTasksSum14d__c": 100, "CA10__avgAllCpuSystemLoad14d__c": 10, "CA10__avgAllJvmHeapUsage14d__c": 10, "CA10__avgDriverCpuSystemLoad14d__c": 10, "CA10__avgDriverJvmHeapUsage14d__c": 10, "CA10__numCompletedTasksSum7d__c": null }, { "expectedResult": { "status": "UNDETERMINED", "conditionIndex": "499", "conditionText": "extract('CA10__avgAllCpuSystemLoad14d__c') <= number(0.0) || extract('CA10__avgAllCpuSystemLoad14d__c') > number(100.0) || extract('CA10__avgAllJvmHeapUsage14d__c') <= number(0.0) || extract('CA10__avgAllJvmHeapUsage14d__c') > number(100.0) || extract('CA10__avgDriverCpuSystemLoad14d__c') <= number(0.0) || extract('CA10__avgDriverCpuSystemLoad14d__c') > number(100.0) || extract('CA10__avgDriverJvmHeapUsage14d__c') <= number(0.0) || extract('CA10__avgDriverJvmHeapUsage14d__c') > number(100.0)", "runtimeError": null }, "context": { "snapshotTime": "2026-10-13T12:00:00Z" }, "Id": "CA10__avgAllCpuSystemLoad14d__c-zero", "CA10__disappearanceTime__c": null, "CA10__commandName__c": "glueetl", "CA10__createdOn__c": "2026-08-01T00:00:00Z", "CA10__numCompletedTasksSum14d__c": 100, "CA10__avgAllCpuSystemLoad14d__c": 0, "CA10__avgAllJvmHeapUsage14d__c": 10, "CA10__avgDriverCpuSystemLoad14d__c": 10, "CA10__avgDriverJvmHeapUsage14d__c": 10, "CA10__numCompletedTasksSum7d__c": 50 }, { "expectedResult": { "status": "UNDETERMINED", "conditionIndex": "499", "conditionText": "extract('CA10__avgAllCpuSystemLoad14d__c') <= number(0.0) || extract('CA10__avgAllCpuSystemLoad14d__c') > number(100.0) || extract('CA10__avgAllJvmHeapUsage14d__c') <= number(0.0) || extract('CA10__avgAllJvmHeapUsage14d__c') > number(100.0) || extract('CA10__avgDriverCpuSystemLoad14d__c') <= number(0.0) || extract('CA10__avgDriverCpuSystemLoad14d__c') > number(100.0) || extract('CA10__avgDriverJvmHeapUsage14d__c') <= number(0.0) || extract('CA10__avgDriverJvmHeapUsage14d__c') > number(100.0)", "runtimeError": null }, "context": { "snapshotTime": "2026-10-13T12:00:00Z" }, "Id": "CA10__avgAllJvmHeapUsage14d__c-zero", "CA10__disappearanceTime__c": null, "CA10__commandName__c": "glueetl", "CA10__createdOn__c": "2026-08-01T00:00:00Z", "CA10__numCompletedTasksSum14d__c": 100, "CA10__avgAllCpuSystemLoad14d__c": 10, "CA10__avgAllJvmHeapUsage14d__c": 0, "CA10__avgDriverCpuSystemLoad14d__c": 10, "CA10__avgDriverJvmHeapUsage14d__c": 10, "CA10__numCompletedTasksSum7d__c": 50 }, { "expectedResult": { "status": "UNDETERMINED", "conditionIndex": "499", "conditionText": "extract('CA10__avgAllCpuSystemLoad14d__c') <= number(0.0) || extract('CA10__avgAllCpuSystemLoad14d__c') > number(100.0) || extract('CA10__avgAllJvmHeapUsage14d__c') <= number(0.0) || extract('CA10__avgAllJvmHeapUsage14d__c') > number(100.0) || extract('CA10__avgDriverCpuSystemLoad14d__c') <= number(0.0) || extract('CA10__avgDriverCpuSystemLoad14d__c') > number(100.0) || extract('CA10__avgDriverJvmHeapUsage14d__c') <= number(0.0) || extract('CA10__avgDriverJvmHeapUsage14d__c') > number(100.0)", "runtimeError": null }, "context": { "snapshotTime": "2026-10-13T12:00:00Z" }, "Id": "CA10__avgDriverCpuSystemLoad14d__c-zero", "CA10__disappearanceTime__c": null, "CA10__commandName__c": "glueetl", "CA10__createdOn__c": "2026-08-01T00:00:00Z", "CA10__numCompletedTasksSum14d__c": 100, "CA10__avgAllCpuSystemLoad14d__c": 10, "CA10__avgAllJvmHeapUsage14d__c": 10, "CA10__avgDriverCpuSystemLoad14d__c": 0, "CA10__avgDriverJvmHeapUsage14d__c": 10, "CA10__numCompletedTasksSum7d__c": 50 }, { "expectedResult": { "status": "UNDETERMINED", "conditionIndex": "499", "conditionText": "extract('CA10__avgAllCpuSystemLoad14d__c') <= number(0.0) || extract('CA10__avgAllCpuSystemLoad14d__c') > number(100.0) || extract('CA10__avgAllJvmHeapUsage14d__c') <= number(0.0) || extract('CA10__avgAllJvmHeapUsage14d__c') > number(100.0) || extract('CA10__avgDriverCpuSystemLoad14d__c') <= number(0.0) || extract('CA10__avgDriverCpuSystemLoad14d__c') > number(100.0) || extract('CA10__avgDriverJvmHeapUsage14d__c') <= number(0.0) || extract('CA10__avgDriverJvmHeapUsage14d__c') > number(100.0)", "runtimeError": null }, "context": { "snapshotTime": "2026-10-13T12:00:00Z" }, "Id": "CA10__avgDriverJvmHeapUsage14d__c-zero", "CA10__disappearanceTime__c": null, "CA10__commandName__c": "glueetl", "CA10__createdOn__c": "2026-08-01T00:00:00Z", "CA10__numCompletedTasksSum14d__c": 100, "CA10__avgAllCpuSystemLoad14d__c": 10, "CA10__avgAllJvmHeapUsage14d__c": 10, "CA10__avgDriverCpuSystemLoad14d__c": 10, "CA10__avgDriverJvmHeapUsage14d__c": 0, "CA10__numCompletedTasksSum7d__c": 50 }, { "expectedResult": { "status": "INCOMPLIANT", "conditionIndex": "699", "conditionText": "extract('CA10__avgAllCpuSystemLoad14d__c') < number(20.0) && extract('CA10__avgAllJvmHeapUsage14d__c') < number(20.0) && extract('CA10__avgDriverCpuSystemLoad14d__c') < number(20.0) && extract('CA10__avgDriverJvmHeapUsage14d__c') < number(20.0)", "runtimeError": null }, "context": { "snapshotTime": "2026-10-13T12:00:00Z" }, "Id": "small-positive-utilization", "CA10__disappearanceTime__c": null, "CA10__commandName__c": "glueetl", "CA10__createdOn__c": "2026-08-01T00:00:00Z", "CA10__numCompletedTasksSum14d__c": 100, "CA10__avgAllCpuSystemLoad14d__c": 0.01, "CA10__avgAllJvmHeapUsage14d__c": 0.01, "CA10__avgDriverCpuSystemLoad14d__c": 0.01, "CA10__avgDriverJvmHeapUsage14d__c": 0.01, "CA10__numCompletedTasksSum7d__c": 50 }, { "expectedResult": { "status": "INAPPLICABLE", "conditionIndex": "199", "conditionText": "extract('CA10__commandName__c') != 'glueetl'", "runtimeError": null }, "context": { "snapshotTime": "2026-10-13T12:00:00Z" }, "Id": "unsupported-command-without-metrics", "CA10__disappearanceTime__c": null, "CA10__commandName__c": "pythonshell", "CA10__createdOn__c": "2026-08-01T00:00:00Z", "CA10__numCompletedTasksSum14d__c": 100, "CA10__avgAllCpuSystemLoad14d__c": null, "CA10__avgAllJvmHeapUsage14d__c": null, "CA10__avgDriverCpuSystemLoad14d__c": null, "CA10__avgDriverJvmHeapUsage14d__c": null, "CA10__numCompletedTasksSum7d__c": 50 } ] - path: /types/CA10__CaAwsGlueJob__c/object.extracts.yaml md5Hash: A81051173E230F73B624DBEDA1C3B3AA content: | --- extracts: - name: CA10__commandName__c value: FIELD: path: CA10__commandName__c undeterminedIf: isEmpty: The Glue job command is unavailable. - name: CA10__createdOn__c value: FIELD: path: CA10__createdOn__c undeterminedIf: isEmpty: The Glue job creation date is unavailable. - name: CA10__numCompletedTasksSum7d__c value: FIELD: path: CA10__numCompletedTasksSum7d__c undeterminedIf: isEmpty: The 7-day completed-task count is unavailable. - name: CA10__numCompletedTasksSum14d__c value: FIELD: path: CA10__numCompletedTasksSum14d__c undeterminedIf: isEmpty: The 14-day completed-task count is unavailable. - name: CA10__avgAllCpuSystemLoad14d__c value: FIELD: path: CA10__avgAllCpuSystemLoad14d__c undeterminedIf: isEmpty: The 14-day executor CPU utilization is unavailable. - name: CA10__avgAllJvmHeapUsage14d__c value: FIELD: path: CA10__avgAllJvmHeapUsage14d__c undeterminedIf: isEmpty: The 14-day executor JVM heap utilization is unavailable. - name: CA10__avgDriverCpuSystemLoad14d__c value: FIELD: path: CA10__avgDriverCpuSystemLoad14d__c undeterminedIf: isEmpty: The 14-day driver CPU utilization is unavailable. - name: CA10__avgDriverJvmHeapUsage14d__c value: FIELD: path: CA10__avgDriverJvmHeapUsage14d__c undeterminedIf: isEmpty: The 14-day driver JVM heap utilization is unavailable. script: |- CREATE TEMP FUNCTION mock_ExpectedResult() RETURNS ARRAY >> DETERMINISTIC LANGUAGE js AS r""" return [ { "Id" : "low-utilization", "expectedResult" : { "status" : "INCOMPLIANT", "conditionIndex" : "699", "conditionText" : "extract('CA10__avgAllCpuSystemLoad14d__c') < number(20.0) && extract('CA10__avgAllJvmHeapUsage14d__c') < number(20.0) && extract('CA10__avgDriverCpuSystemLoad14d__c') < number(20.0) && extract('CA10__avgDriverJvmHeapUsage14d__c') < number(20.0)", "runtimeError" : null } }, { "Id" : "CA10__avgAllCpuSystemLoad14d__c-20", "expectedResult" : { "status" : "COMPLIANT", "conditionIndex" : "700", "conditionText" : "otherwise", "runtimeError" : null } }, { "Id" : "CA10__avgAllCpuSystemLoad14d__c-100", "expectedResult" : { "status" : "COMPLIANT", "conditionIndex" : "700", "conditionText" : "otherwise", "runtimeError" : null } }, { "Id" : "CA10__avgAllCpuSystemLoad14d__c-None", "expectedResult" : { "status" : "UNDETERMINED", "conditionIndex" : "401", "conditionText" : "CA10__avgAllCpuSystemLoad14d__c.isEmpty()", "runtimeError" : null } }, { "Id" : "CA10__avgAllCpuSystemLoad14d__c--1", "expectedResult" : { "status" : "UNDETERMINED", "conditionIndex" : "499", "conditionText" : "extract('CA10__avgAllCpuSystemLoad14d__c') <= number(0.0) || extract('CA10__avgAllCpuSystemLoad14d__c') > number(100.0) || extract('CA10__avgAllJvmHeapUsage14d__c') <= number(0.0) || extract('CA10__avgAllJvmHeapUsage14d__c') > number(100.0) || extract('CA10__avgDriverCpuSystemLoad14d__c') <= number(0.0) || extract('CA10__avgDriverCpuSystemLoad14d__c') > number(100.0) || extract('CA10__avgDriverJvmHeapUsage14d__c') <= number(0.0) || extract('CA10__avgDriverJvmHeapUsage14d__c') > number(100.0)", "runtimeError" : null } }, { "Id" : "CA10__avgAllCpuSystemLoad14d__c-101", "expectedResult" : { "status" : "UNDETERMINED", "conditionIndex" : "499", "conditionText" : "extract('CA10__avgAllCpuSystemLoad14d__c') <= number(0.0) || extract('CA10__avgAllCpuSystemLoad14d__c') > number(100.0) || extract('CA10__avgAllJvmHeapUsage14d__c') <= number(0.0) || extract('CA10__avgAllJvmHeapUsage14d__c') > number(100.0) || extract('CA10__avgDriverCpuSystemLoad14d__c') <= number(0.0) || extract('CA10__avgDriverCpuSystemLoad14d__c') > number(100.0) || extract('CA10__avgDriverJvmHeapUsage14d__c') <= number(0.0) || extract('CA10__avgDriverJvmHeapUsage14d__c') > number(100.0)", "runtimeError" : null } }, { "Id" : "CA10__avgAllJvmHeapUsage14d__c-20", "expectedResult" : { "status" : "COMPLIANT", "conditionIndex" : "700", "conditionText" : "otherwise", "runtimeError" : null } }, { "Id" : "CA10__avgAllJvmHeapUsage14d__c-100", "expectedResult" : { "status" : "COMPLIANT", "conditionIndex" : "700", "conditionText" : "otherwise", "runtimeError" : null } }, { "Id" : "CA10__avgAllJvmHeapUsage14d__c-None", "expectedResult" : { "status" : "UNDETERMINED", "conditionIndex" : "402", "conditionText" : "CA10__avgAllJvmHeapUsage14d__c.isEmpty()", "runtimeError" : null } }, { "Id" : "CA10__avgAllJvmHeapUsage14d__c--1", "expectedResult" : { "status" : "UNDETERMINED", "conditionIndex" : "499", "conditionText" : "extract('CA10__avgAllCpuSystemLoad14d__c') <= number(0.0) || extract('CA10__avgAllCpuSystemLoad14d__c') > number(100.0) || extract('CA10__avgAllJvmHeapUsage14d__c') <= number(0.0) || extract('CA10__avgAllJvmHeapUsage14d__c') > number(100.0) || extract('CA10__avgDriverCpuSystemLoad14d__c') <= number(0.0) || extract('CA10__avgDriverCpuSystemLoad14d__c') > number(100.0) || extract('CA10__avgDriverJvmHeapUsage14d__c') <= number(0.0) || extract('CA10__avgDriverJvmHeapUsage14d__c') > number(100.0)", "runtimeError" : null } }, { "Id" : "CA10__avgAllJvmHeapUsage14d__c-101", "expectedResult" : { "status" : "UNDETERMINED", "conditionIndex" : "499", "conditionText" : "extract('CA10__avgAllCpuSystemLoad14d__c') <= number(0.0) || extract('CA10__avgAllCpuSystemLoad14d__c') > number(100.0) || extract('CA10__avgAllJvmHeapUsage14d__c') <= number(0.0) || extract('CA10__avgAllJvmHeapUsage14d__c') > number(100.0) || extract('CA10__avgDriverCpuSystemLoad14d__c') <= number(0.0) || extract('CA10__avgDriverCpuSystemLoad14d__c') > number(100.0) || extract('CA10__avgDriverJvmHeapUsage14d__c') <= number(0.0) || extract('CA10__avgDriverJvmHeapUsage14d__c') > number(100.0)", "runtimeError" : null } }, { "Id" : "CA10__avgDriverCpuSystemLoad14d__c-20", "expectedResult" : { "status" : "COMPLIANT", "conditionIndex" : "700", "conditionText" : "otherwise", "runtimeError" : null } }, { "Id" : "CA10__avgDriverCpuSystemLoad14d__c-100", "expectedResult" : { "status" : "COMPLIANT", "conditionIndex" : "700", "conditionText" : "otherwise", "runtimeError" : null } }, { "Id" : "CA10__avgDriverCpuSystemLoad14d__c-None", "expectedResult" : { "status" : "UNDETERMINED", "conditionIndex" : "403", "conditionText" : "CA10__avgDriverCpuSystemLoad14d__c.isEmpty()", "runtimeError" : null } }, { "Id" : "CA10__avgDriverCpuSystemLoad14d__c--1", "expectedResult" : { "status" : "UNDETERMINED", "conditionIndex" : "499", "conditionText" : "extract('CA10__avgAllCpuSystemLoad14d__c') <= number(0.0) || extract('CA10__avgAllCpuSystemLoad14d__c') > number(100.0) || extract('CA10__avgAllJvmHeapUsage14d__c') <= number(0.0) || extract('CA10__avgAllJvmHeapUsage14d__c') > number(100.0) || extract('CA10__avgDriverCpuSystemLoad14d__c') <= number(0.0) || extract('CA10__avgDriverCpuSystemLoad14d__c') > number(100.0) || extract('CA10__avgDriverJvmHeapUsage14d__c') <= number(0.0) || extract('CA10__avgDriverJvmHeapUsage14d__c') > number(100.0)", "runtimeError" : null } }, { "Id" : "CA10__avgDriverCpuSystemLoad14d__c-101", "expectedResult" : { "status" : "UNDETERMINED", "conditionIndex" : "499", "conditionText" : "extract('CA10__avgAllCpuSystemLoad14d__c') <= number(0.0) || extract('CA10__avgAllCpuSystemLoad14d__c') > number(100.0) || extract('CA10__avgAllJvmHeapUsage14d__c') <= number(0.0) || extract('CA10__avgAllJvmHeapUsage14d__c') > number(100.0) || extract('CA10__avgDriverCpuSystemLoad14d__c') <= number(0.0) || extract('CA10__avgDriverCpuSystemLoad14d__c') > number(100.0) || extract('CA10__avgDriverJvmHeapUsage14d__c') <= number(0.0) || extract('CA10__avgDriverJvmHeapUsage14d__c') > number(100.0)", "runtimeError" : null } }, { "Id" : "CA10__avgDriverJvmHeapUsage14d__c-20", "expectedResult" : { "status" : "COMPLIANT", "conditionIndex" : "700", "conditionText" : "otherwise", "runtimeError" : null } }, { "Id" : "CA10__avgDriverJvmHeapUsage14d__c-100", "expectedResult" : { "status" : "COMPLIANT", "conditionIndex" : "700", "conditionText" : "otherwise", "runtimeError" : null } }, { "Id" : "CA10__avgDriverJvmHeapUsage14d__c-None", "expectedResult" : { "status" : "UNDETERMINED", "conditionIndex" : "404", "conditionText" : "CA10__avgDriverJvmHeapUsage14d__c.isEmpty()", "runtimeError" : null } }, { "Id" : "CA10__avgDriverJvmHeapUsage14d__c--1", "expectedResult" : { "status" : "UNDETERMINED", "conditionIndex" : "499", "conditionText" : "extract('CA10__avgAllCpuSystemLoad14d__c') <= number(0.0) || extract('CA10__avgAllCpuSystemLoad14d__c') > number(100.0) || extract('CA10__avgAllJvmHeapUsage14d__c') <= number(0.0) || extract('CA10__avgAllJvmHeapUsage14d__c') > number(100.0) || extract('CA10__avgDriverCpuSystemLoad14d__c') <= number(0.0) || extract('CA10__avgDriverCpuSystemLoad14d__c') > number(100.0) || extract('CA10__avgDriverJvmHeapUsage14d__c') <= number(0.0) || extract('CA10__avgDriverJvmHeapUsage14d__c') > number(100.0)", "runtimeError" : null } }, { "Id" : "CA10__avgDriverJvmHeapUsage14d__c-101", "expectedResult" : { "status" : "UNDETERMINED", "conditionIndex" : "499", "conditionText" : "extract('CA10__avgAllCpuSystemLoad14d__c') <= number(0.0) || extract('CA10__avgAllCpuSystemLoad14d__c') > number(100.0) || extract('CA10__avgAllJvmHeapUsage14d__c') <= number(0.0) || extract('CA10__avgAllJvmHeapUsage14d__c') > number(100.0) || extract('CA10__avgDriverCpuSystemLoad14d__c') <= number(0.0) || extract('CA10__avgDriverCpuSystemLoad14d__c') > number(100.0) || extract('CA10__avgDriverJvmHeapUsage14d__c') <= number(0.0) || extract('CA10__avgDriverJvmHeapUsage14d__c') > number(100.0)", "runtimeError" : null } }, { "Id" : "tasks-None", "expectedResult" : { "status" : "UNDETERMINED", "conditionIndex" : "301", "conditionText" : "CA10__numCompletedTasksSum14d__c.isEmpty()", "runtimeError" : null } }, { "Id" : "tasks-0", "expectedResult" : { "status" : "UNDETERMINED", "conditionIndex" : "399", "conditionText" : "extract('CA10__numCompletedTasksSum14d__c') <= number(0.0)", "runtimeError" : null } }, { "Id" : "tasks--1", "expectedResult" : { "status" : "UNDETERMINED", "conditionIndex" : "399", "conditionText" : "extract('CA10__numCompletedTasksSum14d__c') <= number(0.0)", "runtimeError" : null } }, { "Id" : "command-pythonshell", "expectedResult" : { "status" : "INAPPLICABLE", "conditionIndex" : "199", "conditionText" : "extract('CA10__commandName__c') != 'glueetl'", "runtimeError" : null } }, { "Id" : "command-gluestreaming", "expectedResult" : { "status" : "INAPPLICABLE", "conditionIndex" : "199", "conditionText" : "extract('CA10__commandName__c') != 'glueetl'", "runtimeError" : null } }, { "Id" : "command-None", "expectedResult" : { "status" : "UNDETERMINED", "conditionIndex" : "101", "conditionText" : "CA10__commandName__c.isEmpty()", "runtimeError" : null } }, { "Id" : "created-2026-10-12T00:00:00Z", "expectedResult" : { "status" : "INAPPLICABLE", "conditionIndex" : "299", "conditionText" : "not(extract('CA10__createdOn__c').beyondLastDays(14))", "runtimeError" : null } }, { "Id" : "created-2026-09-29T00:00:00Z", "expectedResult" : { "status" : "INAPPLICABLE", "conditionIndex" : "299", "conditionText" : "not(extract('CA10__createdOn__c').beyondLastDays(14))", "runtimeError" : null } }, { "Id" : "created-None", "expectedResult" : { "status" : "UNDETERMINED", "conditionIndex" : "201", "conditionText" : "CA10__createdOn__c.isEmpty()", "runtimeError" : null } }, { "Id" : "disappeared", "expectedResult" : { "status" : "DISAPPEARED", "conditionIndex" : "99", "conditionText" : "isDisappeared(CA10__disappearanceTime__c)", "runtimeError" : null } }, { "Id" : "sample-one-task-zero-executor-cpu", "expectedResult" : { "status" : "UNDETERMINED", "conditionIndex" : "499", "conditionText" : "extract('CA10__avgAllCpuSystemLoad14d__c') <= number(0.0) || extract('CA10__avgAllCpuSystemLoad14d__c') > number(100.0) || extract('CA10__avgAllJvmHeapUsage14d__c') <= number(0.0) || extract('CA10__avgAllJvmHeapUsage14d__c') > number(100.0) || extract('CA10__avgDriverCpuSystemLoad14d__c') <= number(0.0) || extract('CA10__avgDriverCpuSystemLoad14d__c') > number(100.0) || extract('CA10__avgDriverJvmHeapUsage14d__c') <= number(0.0) || extract('CA10__avgDriverJvmHeapUsage14d__c') > number(100.0)", "runtimeError" : null } }, { "Id" : "sample-high-task-count-auto-scaling", "expectedResult" : { "status" : "INCOMPLIANT", "conditionIndex" : "699", "conditionText" : "extract('CA10__avgAllCpuSystemLoad14d__c') < number(20.0) && extract('CA10__avgAllJvmHeapUsage14d__c') < number(20.0) && extract('CA10__avgDriverCpuSystemLoad14d__c') < number(20.0) && extract('CA10__avgDriverJvmHeapUsage14d__c') < number(20.0)", "runtimeError" : null } }, { "Id" : "all-zero-averages-positive-tasks", "expectedResult" : { "status" : "UNDETERMINED", "conditionIndex" : "499", "conditionText" : "extract('CA10__avgAllCpuSystemLoad14d__c') <= number(0.0) || extract('CA10__avgAllCpuSystemLoad14d__c') > number(100.0) || extract('CA10__avgAllJvmHeapUsage14d__c') <= number(0.0) || extract('CA10__avgAllJvmHeapUsage14d__c') > number(100.0) || extract('CA10__avgDriverCpuSystemLoad14d__c') <= number(0.0) || extract('CA10__avgDriverCpuSystemLoad14d__c') > number(100.0) || extract('CA10__avgDriverJvmHeapUsage14d__c') <= number(0.0) || extract('CA10__avgDriverJvmHeapUsage14d__c') > number(100.0)", "runtimeError" : null } }, { "Id" : "created-just-before-utc-age-boundary", "expectedResult" : { "status" : "INCOMPLIANT", "conditionIndex" : "699", "conditionText" : "extract('CA10__avgAllCpuSystemLoad14d__c') < number(20.0) && extract('CA10__avgAllJvmHeapUsage14d__c') < number(20.0) && extract('CA10__avgDriverCpuSystemLoad14d__c') < number(20.0) && extract('CA10__avgDriverJvmHeapUsage14d__c') < number(20.0)", "runtimeError" : null } }, { "Id" : "high-cpu-missing-heap-is-not-compliant", "expectedResult" : { "status" : "UNDETERMINED", "conditionIndex" : "402", "conditionText" : "CA10__avgAllJvmHeapUsage14d__c.isEmpty()", "runtimeError" : null } }, { "Id" : "activity-only-in-earlier-week", "expectedResult" : { "status" : "UNDETERMINED", "conditionIndex" : "599", "conditionText" : "extract('CA10__numCompletedTasksSum7d__c') <= number(0.0) || extract('CA10__numCompletedTasksSum14d__c') <= extract('CA10__numCompletedTasksSum7d__c')", "runtimeError" : null } }, { "Id" : "activity-only-in-recent-week", "expectedResult" : { "status" : "UNDETERMINED", "conditionIndex" : "599", "conditionText" : "extract('CA10__numCompletedTasksSum7d__c') <= number(0.0) || extract('CA10__numCompletedTasksSum14d__c') <= extract('CA10__numCompletedTasksSum7d__c')", "runtimeError" : null } }, { "Id" : "negative-seven-day-tasks", "expectedResult" : { "status" : "UNDETERMINED", "conditionIndex" : "599", "conditionText" : "extract('CA10__numCompletedTasksSum7d__c') <= number(0.0) || extract('CA10__numCompletedTasksSum14d__c') <= extract('CA10__numCompletedTasksSum7d__c')", "runtimeError" : null } }, { "Id" : "seven-day-tasks-exceed-fourteen-day-total", "expectedResult" : { "status" : "UNDETERMINED", "conditionIndex" : "599", "conditionText" : "extract('CA10__numCompletedTasksSum7d__c') <= number(0.0) || extract('CA10__numCompletedTasksSum14d__c') <= extract('CA10__numCompletedTasksSum7d__c')", "runtimeError" : null } }, { "Id" : "missing-seven-day-tasks", "expectedResult" : { "status" : "UNDETERMINED", "conditionIndex" : "501", "conditionText" : "CA10__numCompletedTasksSum7d__c.isEmpty()", "runtimeError" : null } }, { "Id" : "CA10__avgAllCpuSystemLoad14d__c-zero", "expectedResult" : { "status" : "UNDETERMINED", "conditionIndex" : "499", "conditionText" : "extract('CA10__avgAllCpuSystemLoad14d__c') <= number(0.0) || extract('CA10__avgAllCpuSystemLoad14d__c') > number(100.0) || extract('CA10__avgAllJvmHeapUsage14d__c') <= number(0.0) || extract('CA10__avgAllJvmHeapUsage14d__c') > number(100.0) || extract('CA10__avgDriverCpuSystemLoad14d__c') <= number(0.0) || extract('CA10__avgDriverCpuSystemLoad14d__c') > number(100.0) || extract('CA10__avgDriverJvmHeapUsage14d__c') <= number(0.0) || extract('CA10__avgDriverJvmHeapUsage14d__c') > number(100.0)", "runtimeError" : null } }, { "Id" : "CA10__avgAllJvmHeapUsage14d__c-zero", "expectedResult" : { "status" : "UNDETERMINED", "conditionIndex" : "499", "conditionText" : "extract('CA10__avgAllCpuSystemLoad14d__c') <= number(0.0) || extract('CA10__avgAllCpuSystemLoad14d__c') > number(100.0) || extract('CA10__avgAllJvmHeapUsage14d__c') <= number(0.0) || extract('CA10__avgAllJvmHeapUsage14d__c') > number(100.0) || extract('CA10__avgDriverCpuSystemLoad14d__c') <= number(0.0) || extract('CA10__avgDriverCpuSystemLoad14d__c') > number(100.0) || extract('CA10__avgDriverJvmHeapUsage14d__c') <= number(0.0) || extract('CA10__avgDriverJvmHeapUsage14d__c') > number(100.0)", "runtimeError" : null } }, { "Id" : "CA10__avgDriverCpuSystemLoad14d__c-zero", "expectedResult" : { "status" : "UNDETERMINED", "conditionIndex" : "499", "conditionText" : "extract('CA10__avgAllCpuSystemLoad14d__c') <= number(0.0) || extract('CA10__avgAllCpuSystemLoad14d__c') > number(100.0) || extract('CA10__avgAllJvmHeapUsage14d__c') <= number(0.0) || extract('CA10__avgAllJvmHeapUsage14d__c') > number(100.0) || extract('CA10__avgDriverCpuSystemLoad14d__c') <= number(0.0) || extract('CA10__avgDriverCpuSystemLoad14d__c') > number(100.0) || extract('CA10__avgDriverJvmHeapUsage14d__c') <= number(0.0) || extract('CA10__avgDriverJvmHeapUsage14d__c') > number(100.0)", "runtimeError" : null } }, { "Id" : "CA10__avgDriverJvmHeapUsage14d__c-zero", "expectedResult" : { "status" : "UNDETERMINED", "conditionIndex" : "499", "conditionText" : "extract('CA10__avgAllCpuSystemLoad14d__c') <= number(0.0) || extract('CA10__avgAllCpuSystemLoad14d__c') > number(100.0) || extract('CA10__avgAllJvmHeapUsage14d__c') <= number(0.0) || extract('CA10__avgAllJvmHeapUsage14d__c') > number(100.0) || extract('CA10__avgDriverCpuSystemLoad14d__c') <= number(0.0) || extract('CA10__avgDriverCpuSystemLoad14d__c') > number(100.0) || extract('CA10__avgDriverJvmHeapUsage14d__c') <= number(0.0) || extract('CA10__avgDriverJvmHeapUsage14d__c') > number(100.0)", "runtimeError" : null } }, { "Id" : "small-positive-utilization", "expectedResult" : { "status" : "INCOMPLIANT", "conditionIndex" : "699", "conditionText" : "extract('CA10__avgAllCpuSystemLoad14d__c') < number(20.0) && extract('CA10__avgAllJvmHeapUsage14d__c') < number(20.0) && extract('CA10__avgDriverCpuSystemLoad14d__c') < number(20.0) && extract('CA10__avgDriverJvmHeapUsage14d__c') < number(20.0)", "runtimeError" : null } }, { "Id" : "unsupported-command-without-metrics", "expectedResult" : { "status" : "INAPPLICABLE", "conditionIndex" : "199", "conditionText" : "extract('CA10__commandName__c') != 'glueetl'", "runtimeError" : null } } ]; """; CREATE TEMP FUNCTION mock_CA10__CaAwsGlueJob__c() RETURNS ARRAY >> DETERMINISTIC LANGUAGE js AS r""" return [ { "context" : { "snapshotTime" : new Date("2026-10-13T12:00:00Z") }, "CA10__commandName__c" : "glueetl", "CA10__createdOn__c" : new Date("2026-08-01T00:00:00Z"), "CA10__numCompletedTasksSum14d__c" : 100, "CA10__avgAllCpuSystemLoad14d__c" : 10, "CA10__avgAllJvmHeapUsage14d__c" : 10, "CA10__avgDriverCpuSystemLoad14d__c" : 10, "CA10__avgDriverJvmHeapUsage14d__c" : 10, "CA10__numCompletedTasksSum7d__c" : 50, "Id" : "low-utilization" }, { "context" : { "snapshotTime" : new Date("2026-10-13T12:00:00Z") }, "CA10__commandName__c" : "glueetl", "CA10__createdOn__c" : new Date("2026-08-01T00:00:00Z"), "CA10__numCompletedTasksSum14d__c" : 100, "CA10__avgAllCpuSystemLoad14d__c" : 20, "CA10__avgAllJvmHeapUsage14d__c" : 10, "CA10__avgDriverCpuSystemLoad14d__c" : 10, "CA10__avgDriverJvmHeapUsage14d__c" : 10, "CA10__numCompletedTasksSum7d__c" : 50, "Id" : "CA10__avgAllCpuSystemLoad14d__c-20" }, { "context" : { "snapshotTime" : new Date("2026-10-13T12:00:00Z") }, "CA10__commandName__c" : "glueetl", "CA10__createdOn__c" : new Date("2026-08-01T00:00:00Z"), "CA10__numCompletedTasksSum14d__c" : 100, "CA10__avgAllCpuSystemLoad14d__c" : 100, "CA10__avgAllJvmHeapUsage14d__c" : 10, "CA10__avgDriverCpuSystemLoad14d__c" : 10, "CA10__avgDriverJvmHeapUsage14d__c" : 10, "CA10__numCompletedTasksSum7d__c" : 50, "Id" : "CA10__avgAllCpuSystemLoad14d__c-100" }, { "context" : { "snapshotTime" : new Date("2026-10-13T12:00:00Z") }, "CA10__commandName__c" : "glueetl", "CA10__createdOn__c" : new Date("2026-08-01T00:00:00Z"), "CA10__numCompletedTasksSum14d__c" : 100, "CA10__avgAllCpuSystemLoad14d__c" : null, "CA10__avgAllJvmHeapUsage14d__c" : 10, "CA10__avgDriverCpuSystemLoad14d__c" : 10, "CA10__avgDriverJvmHeapUsage14d__c" : 10, "CA10__numCompletedTasksSum7d__c" : 50, "Id" : "CA10__avgAllCpuSystemLoad14d__c-None" }, { "context" : { "snapshotTime" : new Date("2026-10-13T12:00:00Z") }, "CA10__commandName__c" : "glueetl", "CA10__createdOn__c" : new Date("2026-08-01T00:00:00Z"), "CA10__numCompletedTasksSum14d__c" : 100, "CA10__avgAllCpuSystemLoad14d__c" : -1, "CA10__avgAllJvmHeapUsage14d__c" : 10, "CA10__avgDriverCpuSystemLoad14d__c" : 10, "CA10__avgDriverJvmHeapUsage14d__c" : 10, "CA10__numCompletedTasksSum7d__c" : 50, "Id" : "CA10__avgAllCpuSystemLoad14d__c--1" }, { "context" : { "snapshotTime" : new Date("2026-10-13T12:00:00Z") }, "CA10__commandName__c" : "glueetl", "CA10__createdOn__c" : new Date("2026-08-01T00:00:00Z"), "CA10__numCompletedTasksSum14d__c" : 100, "CA10__avgAllCpuSystemLoad14d__c" : 101, "CA10__avgAllJvmHeapUsage14d__c" : 10, "CA10__avgDriverCpuSystemLoad14d__c" : 10, "CA10__avgDriverJvmHeapUsage14d__c" : 10, "CA10__numCompletedTasksSum7d__c" : 50, "Id" : "CA10__avgAllCpuSystemLoad14d__c-101" }, { "context" : { "snapshotTime" : new Date("2026-10-13T12:00:00Z") }, "CA10__commandName__c" : "glueetl", "CA10__createdOn__c" : new Date("2026-08-01T00:00:00Z"), "CA10__numCompletedTasksSum14d__c" : 100, "CA10__avgAllCpuSystemLoad14d__c" : 10, "CA10__avgAllJvmHeapUsage14d__c" : 20, "CA10__avgDriverCpuSystemLoad14d__c" : 10, "CA10__avgDriverJvmHeapUsage14d__c" : 10, "CA10__numCompletedTasksSum7d__c" : 50, "Id" : "CA10__avgAllJvmHeapUsage14d__c-20" }, { "context" : { "snapshotTime" : new Date("2026-10-13T12:00:00Z") }, "CA10__commandName__c" : "glueetl", "CA10__createdOn__c" : new Date("2026-08-01T00:00:00Z"), "CA10__numCompletedTasksSum14d__c" : 100, "CA10__avgAllCpuSystemLoad14d__c" : 10, "CA10__avgAllJvmHeapUsage14d__c" : 100, "CA10__avgDriverCpuSystemLoad14d__c" : 10, "CA10__avgDriverJvmHeapUsage14d__c" : 10, "CA10__numCompletedTasksSum7d__c" : 50, "Id" : "CA10__avgAllJvmHeapUsage14d__c-100" }, { "context" : { "snapshotTime" : new Date("2026-10-13T12:00:00Z") }, "CA10__commandName__c" : "glueetl", "CA10__createdOn__c" : new Date("2026-08-01T00:00:00Z"), "CA10__numCompletedTasksSum14d__c" : 100, "CA10__avgAllCpuSystemLoad14d__c" : 10, "CA10__avgAllJvmHeapUsage14d__c" : null, "CA10__avgDriverCpuSystemLoad14d__c" : 10, "CA10__avgDriverJvmHeapUsage14d__c" : 10, "CA10__numCompletedTasksSum7d__c" : 50, "Id" : "CA10__avgAllJvmHeapUsage14d__c-None" }, { "context" : { "snapshotTime" : new Date("2026-10-13T12:00:00Z") }, "CA10__commandName__c" : "glueetl", "CA10__createdOn__c" : new Date("2026-08-01T00:00:00Z"), "CA10__numCompletedTasksSum14d__c" : 100, "CA10__avgAllCpuSystemLoad14d__c" : 10, "CA10__avgAllJvmHeapUsage14d__c" : -1, "CA10__avgDriverCpuSystemLoad14d__c" : 10, "CA10__avgDriverJvmHeapUsage14d__c" : 10, "CA10__numCompletedTasksSum7d__c" : 50, "Id" : "CA10__avgAllJvmHeapUsage14d__c--1" }, { "context" : { "snapshotTime" : new Date("2026-10-13T12:00:00Z") }, "CA10__commandName__c" : "glueetl", "CA10__createdOn__c" : new Date("2026-08-01T00:00:00Z"), "CA10__numCompletedTasksSum14d__c" : 100, "CA10__avgAllCpuSystemLoad14d__c" : 10, "CA10__avgAllJvmHeapUsage14d__c" : 101, "CA10__avgDriverCpuSystemLoad14d__c" : 10, "CA10__avgDriverJvmHeapUsage14d__c" : 10, "CA10__numCompletedTasksSum7d__c" : 50, "Id" : "CA10__avgAllJvmHeapUsage14d__c-101" }, { "context" : { "snapshotTime" : new Date("2026-10-13T12:00:00Z") }, "CA10__commandName__c" : "glueetl", "CA10__createdOn__c" : new Date("2026-08-01T00:00:00Z"), "CA10__numCompletedTasksSum14d__c" : 100, "CA10__avgAllCpuSystemLoad14d__c" : 10, "CA10__avgAllJvmHeapUsage14d__c" : 10, "CA10__avgDriverCpuSystemLoad14d__c" : 20, "CA10__avgDriverJvmHeapUsage14d__c" : 10, "CA10__numCompletedTasksSum7d__c" : 50, "Id" : "CA10__avgDriverCpuSystemLoad14d__c-20" }, { "context" : { "snapshotTime" : new Date("2026-10-13T12:00:00Z") }, "CA10__commandName__c" : "glueetl", "CA10__createdOn__c" : new Date("2026-08-01T00:00:00Z"), "CA10__numCompletedTasksSum14d__c" : 100, "CA10__avgAllCpuSystemLoad14d__c" : 10, "CA10__avgAllJvmHeapUsage14d__c" : 10, "CA10__avgDriverCpuSystemLoad14d__c" : 100, "CA10__avgDriverJvmHeapUsage14d__c" : 10, "CA10__numCompletedTasksSum7d__c" : 50, "Id" : "CA10__avgDriverCpuSystemLoad14d__c-100" }, { "context" : { "snapshotTime" : new Date("2026-10-13T12:00:00Z") }, "CA10__commandName__c" : "glueetl", "CA10__createdOn__c" : new Date("2026-08-01T00:00:00Z"), "CA10__numCompletedTasksSum14d__c" : 100, "CA10__avgAllCpuSystemLoad14d__c" : 10, "CA10__avgAllJvmHeapUsage14d__c" : 10, "CA10__avgDriverCpuSystemLoad14d__c" : null, "CA10__avgDriverJvmHeapUsage14d__c" : 10, "CA10__numCompletedTasksSum7d__c" : 50, "Id" : "CA10__avgDriverCpuSystemLoad14d__c-None" }, { "context" : { "snapshotTime" : new Date("2026-10-13T12:00:00Z") }, "CA10__commandName__c" : "glueetl", "CA10__createdOn__c" : new Date("2026-08-01T00:00:00Z"), "CA10__numCompletedTasksSum14d__c" : 100, "CA10__avgAllCpuSystemLoad14d__c" : 10, "CA10__avgAllJvmHeapUsage14d__c" : 10, "CA10__avgDriverCpuSystemLoad14d__c" : -1, "CA10__avgDriverJvmHeapUsage14d__c" : 10, "CA10__numCompletedTasksSum7d__c" : 50, "Id" : "CA10__avgDriverCpuSystemLoad14d__c--1" }, { "context" : { "snapshotTime" : new Date("2026-10-13T12:00:00Z") }, "CA10__commandName__c" : "glueetl", "CA10__createdOn__c" : new Date("2026-08-01T00:00:00Z"), "CA10__numCompletedTasksSum14d__c" : 100, "CA10__avgAllCpuSystemLoad14d__c" : 10, "CA10__avgAllJvmHeapUsage14d__c" : 10, "CA10__avgDriverCpuSystemLoad14d__c" : 101, "CA10__avgDriverJvmHeapUsage14d__c" : 10, "CA10__numCompletedTasksSum7d__c" : 50, "Id" : "CA10__avgDriverCpuSystemLoad14d__c-101" }, { "context" : { "snapshotTime" : new Date("2026-10-13T12:00:00Z") }, "CA10__commandName__c" : "glueetl", "CA10__createdOn__c" : new Date("2026-08-01T00:00:00Z"), "CA10__numCompletedTasksSum14d__c" : 100, "CA10__avgAllCpuSystemLoad14d__c" : 10, "CA10__avgAllJvmHeapUsage14d__c" : 10, "CA10__avgDriverCpuSystemLoad14d__c" : 10, "CA10__avgDriverJvmHeapUsage14d__c" : 20, "CA10__numCompletedTasksSum7d__c" : 50, "Id" : "CA10__avgDriverJvmHeapUsage14d__c-20" }, { "context" : { "snapshotTime" : new Date("2026-10-13T12:00:00Z") }, "CA10__commandName__c" : "glueetl", "CA10__createdOn__c" : new Date("2026-08-01T00:00:00Z"), "CA10__numCompletedTasksSum14d__c" : 100, "CA10__avgAllCpuSystemLoad14d__c" : 10, "CA10__avgAllJvmHeapUsage14d__c" : 10, "CA10__avgDriverCpuSystemLoad14d__c" : 10, "CA10__avgDriverJvmHeapUsage14d__c" : 100, "CA10__numCompletedTasksSum7d__c" : 50, "Id" : "CA10__avgDriverJvmHeapUsage14d__c-100" }, { "context" : { "snapshotTime" : new Date("2026-10-13T12:00:00Z") }, "CA10__commandName__c" : "glueetl", "CA10__createdOn__c" : new Date("2026-08-01T00:00:00Z"), "CA10__numCompletedTasksSum14d__c" : 100, "CA10__avgAllCpuSystemLoad14d__c" : 10, "CA10__avgAllJvmHeapUsage14d__c" : 10, "CA10__avgDriverCpuSystemLoad14d__c" : 10, "CA10__avgDriverJvmHeapUsage14d__c" : null, "CA10__numCompletedTasksSum7d__c" : 50, "Id" : "CA10__avgDriverJvmHeapUsage14d__c-None" }, { "context" : { "snapshotTime" : new Date("2026-10-13T12:00:00Z") }, "CA10__commandName__c" : "glueetl", "CA10__createdOn__c" : new Date("2026-08-01T00:00:00Z"), "CA10__numCompletedTasksSum14d__c" : 100, "CA10__avgAllCpuSystemLoad14d__c" : 10, "CA10__avgAllJvmHeapUsage14d__c" : 10, "CA10__avgDriverCpuSystemLoad14d__c" : 10, "CA10__avgDriverJvmHeapUsage14d__c" : -1, "CA10__numCompletedTasksSum7d__c" : 50, "Id" : "CA10__avgDriverJvmHeapUsage14d__c--1" }, { "context" : { "snapshotTime" : new Date("2026-10-13T12:00:00Z") }, "CA10__commandName__c" : "glueetl", "CA10__createdOn__c" : new Date("2026-08-01T00:00:00Z"), "CA10__numCompletedTasksSum14d__c" : 100, "CA10__avgAllCpuSystemLoad14d__c" : 10, "CA10__avgAllJvmHeapUsage14d__c" : 10, "CA10__avgDriverCpuSystemLoad14d__c" : 10, "CA10__avgDriverJvmHeapUsage14d__c" : 101, "CA10__numCompletedTasksSum7d__c" : 50, "Id" : "CA10__avgDriverJvmHeapUsage14d__c-101" }, { "context" : { "snapshotTime" : new Date("2026-10-13T12:00:00Z") }, "CA10__commandName__c" : "glueetl", "CA10__createdOn__c" : new Date("2026-08-01T00:00:00Z"), "CA10__numCompletedTasksSum14d__c" : null, "CA10__avgAllCpuSystemLoad14d__c" : 10, "CA10__avgAllJvmHeapUsage14d__c" : 10, "CA10__avgDriverCpuSystemLoad14d__c" : 10, "CA10__avgDriverJvmHeapUsage14d__c" : 10, "CA10__numCompletedTasksSum7d__c" : 50, "Id" : "tasks-None" }, { "context" : { "snapshotTime" : new Date("2026-10-13T12:00:00Z") }, "CA10__commandName__c" : "glueetl", "CA10__createdOn__c" : new Date("2026-08-01T00:00:00Z"), "CA10__numCompletedTasksSum14d__c" : 0, "CA10__avgAllCpuSystemLoad14d__c" : 10, "CA10__avgAllJvmHeapUsage14d__c" : 10, "CA10__avgDriverCpuSystemLoad14d__c" : 10, "CA10__avgDriverJvmHeapUsage14d__c" : 10, "CA10__numCompletedTasksSum7d__c" : 50, "Id" : "tasks-0" }, { "context" : { "snapshotTime" : new Date("2026-10-13T12:00:00Z") }, "CA10__commandName__c" : "glueetl", "CA10__createdOn__c" : new Date("2026-08-01T00:00:00Z"), "CA10__numCompletedTasksSum14d__c" : -1, "CA10__avgAllCpuSystemLoad14d__c" : 10, "CA10__avgAllJvmHeapUsage14d__c" : 10, "CA10__avgDriverCpuSystemLoad14d__c" : 10, "CA10__avgDriverJvmHeapUsage14d__c" : 10, "CA10__numCompletedTasksSum7d__c" : 50, "Id" : "tasks--1" }, { "context" : { "snapshotTime" : new Date("2026-10-13T12:00:00Z") }, "CA10__commandName__c" : "pythonshell", "CA10__createdOn__c" : new Date("2026-08-01T00:00:00Z"), "CA10__numCompletedTasksSum14d__c" : 100, "CA10__avgAllCpuSystemLoad14d__c" : 10, "CA10__avgAllJvmHeapUsage14d__c" : 10, "CA10__avgDriverCpuSystemLoad14d__c" : 10, "CA10__avgDriverJvmHeapUsage14d__c" : 10, "CA10__numCompletedTasksSum7d__c" : 50, "Id" : "command-pythonshell" }, { "context" : { "snapshotTime" : new Date("2026-10-13T12:00:00Z") }, "CA10__commandName__c" : "gluestreaming", "CA10__createdOn__c" : new Date("2026-08-01T00:00:00Z"), "CA10__numCompletedTasksSum14d__c" : 100, "CA10__avgAllCpuSystemLoad14d__c" : 10, "CA10__avgAllJvmHeapUsage14d__c" : 10, "CA10__avgDriverCpuSystemLoad14d__c" : 10, "CA10__avgDriverJvmHeapUsage14d__c" : 10, "CA10__numCompletedTasksSum7d__c" : 50, "Id" : "command-gluestreaming" }, { "context" : { "snapshotTime" : new Date("2026-10-13T12:00:00Z") }, "CA10__commandName__c" : null, "CA10__createdOn__c" : new Date("2026-08-01T00:00:00Z"), "CA10__numCompletedTasksSum14d__c" : 100, "CA10__avgAllCpuSystemLoad14d__c" : 10, "CA10__avgAllJvmHeapUsage14d__c" : 10, "CA10__avgDriverCpuSystemLoad14d__c" : 10, "CA10__avgDriverJvmHeapUsage14d__c" : 10, "CA10__numCompletedTasksSum7d__c" : 50, "Id" : "command-None" }, { "context" : { "snapshotTime" : new Date("2026-10-13T12:00:00Z") }, "CA10__commandName__c" : "glueetl", "CA10__createdOn__c" : new Date("2026-10-12T00:00:00Z"), "CA10__numCompletedTasksSum14d__c" : 100, "CA10__avgAllCpuSystemLoad14d__c" : 10, "CA10__avgAllJvmHeapUsage14d__c" : 10, "CA10__avgDriverCpuSystemLoad14d__c" : 10, "CA10__avgDriverJvmHeapUsage14d__c" : 10, "CA10__numCompletedTasksSum7d__c" : 50, "Id" : "created-2026-10-12T00:00:00Z" }, { "context" : { "snapshotTime" : new Date("2026-10-13T12:00:00Z") }, "CA10__commandName__c" : "glueetl", "CA10__createdOn__c" : new Date("2026-09-29T00:00:00Z"), "CA10__numCompletedTasksSum14d__c" : 100, "CA10__avgAllCpuSystemLoad14d__c" : 10, "CA10__avgAllJvmHeapUsage14d__c" : 10, "CA10__avgDriverCpuSystemLoad14d__c" : 10, "CA10__avgDriverJvmHeapUsage14d__c" : 10, "CA10__numCompletedTasksSum7d__c" : 50, "Id" : "created-2026-09-29T00:00:00Z" }, { "context" : { "snapshotTime" : new Date("2026-10-13T12:00:00Z") }, "CA10__commandName__c" : "glueetl", "CA10__numCompletedTasksSum14d__c" : 100, "CA10__avgAllCpuSystemLoad14d__c" : 10, "CA10__avgAllJvmHeapUsage14d__c" : 10, "CA10__avgDriverCpuSystemLoad14d__c" : 10, "CA10__avgDriverJvmHeapUsage14d__c" : 10, "CA10__numCompletedTasksSum7d__c" : 50, "Id" : "created-None" }, { "context" : { "snapshotTime" : new Date("2026-10-13T12:00:00Z") }, "CA10__disappearanceTime__c" : new Date("2026-10-12T00:00:00Z"), "CA10__commandName__c" : "glueetl", "CA10__createdOn__c" : new Date("2026-08-01T00:00:00Z"), "CA10__numCompletedTasksSum14d__c" : 100, "CA10__avgAllCpuSystemLoad14d__c" : 10, "CA10__avgAllJvmHeapUsage14d__c" : 10, "CA10__avgDriverCpuSystemLoad14d__c" : 10, "CA10__avgDriverJvmHeapUsage14d__c" : 10, "CA10__numCompletedTasksSum7d__c" : 50, "Id" : "disappeared" }, { "context" : { "snapshotTime" : new Date("2026-10-13T12:00:00Z") }, "CA10__commandName__c" : "glueetl", "CA10__createdOn__c" : new Date("2026-08-01T00:00:00Z"), "CA10__numCompletedTasksSum14d__c" : 1, "CA10__avgAllCpuSystemLoad14d__c" : 0, "CA10__avgAllJvmHeapUsage14d__c" : 3.4702069312334065, "CA10__avgDriverCpuSystemLoad14d__c" : 2.517354516327376, "CA10__avgDriverJvmHeapUsage14d__c" : 4.574851865569751, "CA10__numCompletedTasksSum7d__c" : 1, "Id" : "sample-one-task-zero-executor-cpu" }, { "context" : { "snapshotTime" : new Date("2026-10-13T12:00:00Z") }, "CA10__commandName__c" : "glueetl", "CA10__createdOn__c" : new Date("2026-08-01T00:00:00Z"), "CA10__numCompletedTasksSum14d__c" : 19417430, "CA10__avgAllCpuSystemLoad14d__c" : 7.212892001124691, "CA10__avgAllJvmHeapUsage14d__c" : 5.552194605252455, "CA10__avgDriverCpuSystemLoad14d__c" : 6.932769307905659, "CA10__avgDriverJvmHeapUsage14d__c" : 2.954946758152317, "CA10__numCompletedTasksSum7d__c" : 9000000, "Id" : "sample-high-task-count-auto-scaling" }, { "context" : { "snapshotTime" : new Date("2026-10-13T12:00:00Z") }, "CA10__commandName__c" : "glueetl", "CA10__createdOn__c" : new Date("2026-08-01T00:00:00Z"), "CA10__numCompletedTasksSum14d__c" : 100, "CA10__avgAllCpuSystemLoad14d__c" : 0, "CA10__avgAllJvmHeapUsage14d__c" : 0, "CA10__avgDriverCpuSystemLoad14d__c" : 0, "CA10__avgDriverJvmHeapUsage14d__c" : 0, "CA10__numCompletedTasksSum7d__c" : 50, "Id" : "all-zero-averages-positive-tasks" }, { "context" : { "snapshotTime" : new Date("2026-10-13T12:00:00Z") }, "CA10__commandName__c" : "glueetl", "CA10__createdOn__c" : new Date("2026-09-28T23:59:59Z"), "CA10__numCompletedTasksSum14d__c" : 100, "CA10__avgAllCpuSystemLoad14d__c" : 10, "CA10__avgAllJvmHeapUsage14d__c" : 10, "CA10__avgDriverCpuSystemLoad14d__c" : 10, "CA10__avgDriverJvmHeapUsage14d__c" : 10, "CA10__numCompletedTasksSum7d__c" : 50, "Id" : "created-just-before-utc-age-boundary" }, { "context" : { "snapshotTime" : new Date("2026-10-13T12:00:00Z") }, "CA10__commandName__c" : "glueetl", "CA10__createdOn__c" : new Date("2026-08-01T00:00:00Z"), "CA10__numCompletedTasksSum14d__c" : 100, "CA10__avgAllCpuSystemLoad14d__c" : 50, "CA10__avgAllJvmHeapUsage14d__c" : null, "CA10__avgDriverCpuSystemLoad14d__c" : 10, "CA10__avgDriverJvmHeapUsage14d__c" : 10, "CA10__numCompletedTasksSum7d__c" : 50, "Id" : "high-cpu-missing-heap-is-not-compliant" }, { "context" : { "snapshotTime" : new Date("2026-10-13T12:00:00Z") }, "CA10__commandName__c" : "glueetl", "CA10__createdOn__c" : new Date("2026-08-01T00:00:00Z"), "CA10__numCompletedTasksSum14d__c" : 100, "CA10__avgAllCpuSystemLoad14d__c" : 10, "CA10__avgAllJvmHeapUsage14d__c" : 10, "CA10__avgDriverCpuSystemLoad14d__c" : 10, "CA10__avgDriverJvmHeapUsage14d__c" : 10, "CA10__numCompletedTasksSum7d__c" : 0, "Id" : "activity-only-in-earlier-week" }, { "context" : { "snapshotTime" : new Date("2026-10-13T12:00:00Z") }, "CA10__commandName__c" : "glueetl", "CA10__createdOn__c" : new Date("2026-08-01T00:00:00Z"), "CA10__numCompletedTasksSum14d__c" : 100, "CA10__avgAllCpuSystemLoad14d__c" : 10, "CA10__avgAllJvmHeapUsage14d__c" : 10, "CA10__avgDriverCpuSystemLoad14d__c" : 10, "CA10__avgDriverJvmHeapUsage14d__c" : 10, "CA10__numCompletedTasksSum7d__c" : 100, "Id" : "activity-only-in-recent-week" }, { "context" : { "snapshotTime" : new Date("2026-10-13T12:00:00Z") }, "CA10__commandName__c" : "glueetl", "CA10__createdOn__c" : new Date("2026-08-01T00:00:00Z"), "CA10__numCompletedTasksSum14d__c" : 100, "CA10__avgAllCpuSystemLoad14d__c" : 10, "CA10__avgAllJvmHeapUsage14d__c" : 10, "CA10__avgDriverCpuSystemLoad14d__c" : 10, "CA10__avgDriverJvmHeapUsage14d__c" : 10, "CA10__numCompletedTasksSum7d__c" : -1, "Id" : "negative-seven-day-tasks" }, { "context" : { "snapshotTime" : new Date("2026-10-13T12:00:00Z") }, "CA10__commandName__c" : "glueetl", "CA10__createdOn__c" : new Date("2026-08-01T00:00:00Z"), "CA10__numCompletedTasksSum14d__c" : 100, "CA10__avgAllCpuSystemLoad14d__c" : 10, "CA10__avgAllJvmHeapUsage14d__c" : 10, "CA10__avgDriverCpuSystemLoad14d__c" : 10, "CA10__avgDriverJvmHeapUsage14d__c" : 10, "CA10__numCompletedTasksSum7d__c" : 101, "Id" : "seven-day-tasks-exceed-fourteen-day-total" }, { "context" : { "snapshotTime" : new Date("2026-10-13T12:00:00Z") }, "CA10__commandName__c" : "glueetl", "CA10__createdOn__c" : new Date("2026-08-01T00:00:00Z"), "CA10__numCompletedTasksSum14d__c" : 100, "CA10__avgAllCpuSystemLoad14d__c" : 10, "CA10__avgAllJvmHeapUsage14d__c" : 10, "CA10__avgDriverCpuSystemLoad14d__c" : 10, "CA10__avgDriverJvmHeapUsage14d__c" : 10, "CA10__numCompletedTasksSum7d__c" : null, "Id" : "missing-seven-day-tasks" }, { "context" : { "snapshotTime" : new Date("2026-10-13T12:00:00Z") }, "CA10__commandName__c" : "glueetl", "CA10__createdOn__c" : new Date("2026-08-01T00:00:00Z"), "CA10__numCompletedTasksSum14d__c" : 100, "CA10__avgAllCpuSystemLoad14d__c" : 0, "CA10__avgAllJvmHeapUsage14d__c" : 10, "CA10__avgDriverCpuSystemLoad14d__c" : 10, "CA10__avgDriverJvmHeapUsage14d__c" : 10, "CA10__numCompletedTasksSum7d__c" : 50, "Id" : "CA10__avgAllCpuSystemLoad14d__c-zero" }, { "context" : { "snapshotTime" : new Date("2026-10-13T12:00:00Z") }, "CA10__commandName__c" : "glueetl", "CA10__createdOn__c" : new Date("2026-08-01T00:00:00Z"), "CA10__numCompletedTasksSum14d__c" : 100, "CA10__avgAllCpuSystemLoad14d__c" : 10, "CA10__avgAllJvmHeapUsage14d__c" : 0, "CA10__avgDriverCpuSystemLoad14d__c" : 10, "CA10__avgDriverJvmHeapUsage14d__c" : 10, "CA10__numCompletedTasksSum7d__c" : 50, "Id" : "CA10__avgAllJvmHeapUsage14d__c-zero" }, { "context" : { "snapshotTime" : new Date("2026-10-13T12:00:00Z") }, "CA10__commandName__c" : "glueetl", "CA10__createdOn__c" : new Date("2026-08-01T00:00:00Z"), "CA10__numCompletedTasksSum14d__c" : 100, "CA10__avgAllCpuSystemLoad14d__c" : 10, "CA10__avgAllJvmHeapUsage14d__c" : 10, "CA10__avgDriverCpuSystemLoad14d__c" : 0, "CA10__avgDriverJvmHeapUsage14d__c" : 10, "CA10__numCompletedTasksSum7d__c" : 50, "Id" : "CA10__avgDriverCpuSystemLoad14d__c-zero" }, { "context" : { "snapshotTime" : new Date("2026-10-13T12:00:00Z") }, "CA10__commandName__c" : "glueetl", "CA10__createdOn__c" : new Date("2026-08-01T00:00:00Z"), "CA10__numCompletedTasksSum14d__c" : 100, "CA10__avgAllCpuSystemLoad14d__c" : 10, "CA10__avgAllJvmHeapUsage14d__c" : 10, "CA10__avgDriverCpuSystemLoad14d__c" : 10, "CA10__avgDriverJvmHeapUsage14d__c" : 0, "CA10__numCompletedTasksSum7d__c" : 50, "Id" : "CA10__avgDriverJvmHeapUsage14d__c-zero" }, { "context" : { "snapshotTime" : new Date("2026-10-13T12:00:00Z") }, "CA10__commandName__c" : "glueetl", "CA10__createdOn__c" : new Date("2026-08-01T00:00:00Z"), "CA10__numCompletedTasksSum14d__c" : 100, "CA10__avgAllCpuSystemLoad14d__c" : 0.01, "CA10__avgAllJvmHeapUsage14d__c" : 0.01, "CA10__avgDriverCpuSystemLoad14d__c" : 0.01, "CA10__avgDriverJvmHeapUsage14d__c" : 0.01, "CA10__numCompletedTasksSum7d__c" : 50, "Id" : "small-positive-utilization" }, { "context" : { "snapshotTime" : new Date("2026-10-13T12:00:00Z") }, "CA10__commandName__c" : "pythonshell", "CA10__createdOn__c" : new Date("2026-08-01T00:00:00Z"), "CA10__numCompletedTasksSum14d__c" : 100, "CA10__avgAllCpuSystemLoad14d__c" : null, "CA10__avgAllJvmHeapUsage14d__c" : null, "CA10__avgDriverCpuSystemLoad14d__c" : null, "CA10__avgDriverJvmHeapUsage14d__c" : null, "CA10__numCompletedTasksSum7d__c" : 50, "Id" : "unsupported-command-without-metrics" } ]; """; CREATE TEMP FUNCTION process_CA10__CaAwsGlueJob__c( obj STRUCT< CA10__disappearanceTime__c TIMESTAMP, CA10__commandName__c STRING, CA10__createdOn__c TIMESTAMP, CA10__numCompletedTasksSum14d__c FLOAT64, CA10__avgAllCpuSystemLoad14d__c FLOAT64, CA10__avgAllJvmHeapUsage14d__c FLOAT64, CA10__avgDriverCpuSystemLoad14d__c FLOAT64, CA10__avgDriverJvmHeapUsage14d__c FLOAT64, CA10__numCompletedTasksSum7d__c FLOAT64, Id STRING >, snapshotTime TIMESTAMP ) RETURNS STRUCT DETERMINISTIC LANGUAGE js AS r""" var IsEmptyLib = new function () { this.simpleIsEmpty = function(arg) { return arg == null; }; this.simpleIsNotEmpty = function(arg) { return arg != null; }; }(); var TextLib = new function () { this.normalize = function(arg) { return arg == null ? '' : arg.replace(/\s+/g, ' ').trim().toLowerCase(); }; this.isEmpty = function(arg) { return this.normalize(arg) == ''; }; this.isNotEmpty = function(arg) { return this.normalize(arg) != ''; }; this.equal = function(left, right) { return this.normalize(left) == this.normalize(right); }; this.notEqual = function(left, right) { return this.normalize(left) != this.normalize(right); }; this.startsWith = function(arg, substring) { return this.normalize(arg).startsWith(this.normalize(substring)); }; this.endsWith = function(arg, substring) { return this.normalize(arg).endsWith(this.normalize(substring)); }; this.contains = function(arg, substring) { return this.normalize(arg).includes(this.normalize(substring)); }; this.containsAll = function(arg, substrings) { if (substrings == null || substrings.length === 0) return false; let normalizedArg = this.normalize(arg); return substrings.every(sub => normalizedArg.includes(this.normalize(sub))); }; this.containsAny = function(arg, substrings) { if (substrings == null || substrings.length === 0) return false; let normalizedArg = this.normalize(arg); return substrings.some(sub => normalizedArg.includes(this.normalize(sub))); }; }(); var todayMinus14Day = new Date(snapshotTime.toISOString().substr(0,10)+'T00:00:00.000Z').getTime() + (-14 * 86400000); var references1 = []; // condition[0], conditionIndex:[0..99] references1.push('Deleted From AWS [CA10__disappearanceTime__c]: ' + obj.CA10__disappearanceTime__c); if (obj.CA10__disappearanceTime__c != null) { return {status: 'DISAPPEARED', conditionIndex: 99, conditionText: "isDisappeared(CA10__disappearanceTime__c)", currentStateMessage: "Object is deleted in the source", currentStateReferences: references1.join('\n'), remediation: null, runtimeError: null}; } // condition[1], conditionIndex:[100..199] function fieldChecked4() { if (TextLib.isEmpty(obj.CA10__commandName__c)) { throw new Error("UNDETERMINED condition:101", {cause: {status: 'UNDETERMINED', conditionIndex: 101, conditionText: "CA10__commandName__c.isEmpty()", currentStateMessage: "The Glue job command is unavailable.", currentStateReferences: references1.join('\n'), remediation: null, runtimeError: null}}); } return obj.CA10__commandName__c; } function extract3() { if (!this.out) { this.out = fieldChecked4(); } return this.out; }; references1.push('Command: Name [obj.CA10__commandName__c]: ' + obj.CA10__commandName__c); try { if (TextLib.notEqual(extract3.call(extract3), 'glueetl')) { return {status: 'INAPPLICABLE', conditionIndex: 199, conditionText: "extract('CA10__commandName__c') != 'glueetl'", currentStateMessage: "This policy applies only to Apache Spark batch ETL jobs.", currentStateReferences: references1.join('\n'), remediation: null, runtimeError: null}; } } catch (err) { if (err.cause && err.cause.status) { return err.cause; } else { throw err; } } // condition[2], conditionIndex:[200..299] function fieldChecked7() { if (IsEmptyLib.simpleIsEmpty(obj.CA10__createdOn__c)) { throw new Error("UNDETERMINED condition:201", {cause: {status: 'UNDETERMINED', conditionIndex: 201, conditionText: "CA10__createdOn__c.isEmpty()", currentStateMessage: "The Glue job creation date is unavailable.", currentStateReferences: references1.join('\n'), remediation: null, runtimeError: null}}); } return obj.CA10__createdOn__c; } function extract6() { if (!this.out) { this.out = fieldChecked7(); } return this.out; }; references1.push('Created On [obj.CA10__createdOn__c]: ' + obj.CA10__createdOn__c); try { if (!(extract6.call(extract6) != null && extract6.call(extract6).getTime() < todayMinus14Day)) { return {status: 'INAPPLICABLE', conditionIndex: 299, conditionText: "not(extract('CA10__createdOn__c').beyondLastDays(14))", currentStateMessage: "The job was not created before UTC midnight 14 days ago.", currentStateReferences: references1.join('\n'), remediation: null, runtimeError: null}; } } catch (err) { if (err.cause && err.cause.status) { return err.cause; } else { throw err; } } // condition[3], conditionIndex:[300..399] function fieldChecked12() { if (IsEmptyLib.simpleIsEmpty(obj.CA10__numCompletedTasksSum14d__c)) { throw new Error("UNDETERMINED condition:301", {cause: {status: 'UNDETERMINED', conditionIndex: 301, conditionText: "CA10__numCompletedTasksSum14d__c.isEmpty()", currentStateMessage: "The 14-day completed-task count is unavailable.", currentStateReferences: references1.join('\n'), remediation: null, runtimeError: null}}); } return obj.CA10__numCompletedTasksSum14d__c; } function extract11() { if (!this.out) { this.out = fieldChecked12(); } return this.out; }; references1.push('CloudWatch: Num Completed Tasks 14-Day [obj.CA10__numCompletedTasksSum14d__c]: ' + obj.CA10__numCompletedTasksSum14d__c); try { if (extract11.call(extract11) != null && 0.0 != null && extract11.call(extract11) <= 0.0) { return {status: 'UNDETERMINED', conditionIndex: 399, conditionText: "extract('CA10__numCompletedTasksSum14d__c') <= number(0.0)", currentStateMessage: "No completed Spark tasks were observed; the utilization assessment is inconclusive.", currentStateReferences: references1.join('\n'), remediation: null, runtimeError: null}; } } catch (err) { if (err.cause && err.cause.status) { return err.cause; } else { throw err; } } // condition[4], conditionIndex:[400..499] function fieldChecked16() { if (IsEmptyLib.simpleIsEmpty(obj.CA10__avgAllCpuSystemLoad14d__c)) { throw new Error("UNDETERMINED condition:401", {cause: {status: 'UNDETERMINED', conditionIndex: 401, conditionText: "CA10__avgAllCpuSystemLoad14d__c.isEmpty()", currentStateMessage: "The 14-day executor CPU utilization is unavailable.", currentStateReferences: references1.join('\n'), remediation: null, runtimeError: null}}); } return obj.CA10__avgAllCpuSystemLoad14d__c; } function extract15() { if (!this.out) { this.out = fieldChecked16(); } return this.out; }; function fieldChecked22() { if (IsEmptyLib.simpleIsEmpty(obj.CA10__avgAllJvmHeapUsage14d__c)) { throw new Error("UNDETERMINED condition:402", {cause: {status: 'UNDETERMINED', conditionIndex: 402, conditionText: "CA10__avgAllJvmHeapUsage14d__c.isEmpty()", currentStateMessage: "The 14-day executor JVM heap utilization is unavailable.", currentStateReferences: references1.join('\n'), remediation: null, runtimeError: null}}); } return obj.CA10__avgAllJvmHeapUsage14d__c; } function extract21() { if (!this.out) { this.out = fieldChecked22(); } return this.out; }; function fieldChecked28() { if (IsEmptyLib.simpleIsEmpty(obj.CA10__avgDriverCpuSystemLoad14d__c)) { throw new Error("UNDETERMINED condition:403", {cause: {status: 'UNDETERMINED', conditionIndex: 403, conditionText: "CA10__avgDriverCpuSystemLoad14d__c.isEmpty()", currentStateMessage: "The 14-day driver CPU utilization is unavailable.", currentStateReferences: references1.join('\n'), remediation: null, runtimeError: null}}); } return obj.CA10__avgDriverCpuSystemLoad14d__c; } function extract27() { if (!this.out) { this.out = fieldChecked28(); } return this.out; }; function fieldChecked34() { if (IsEmptyLib.simpleIsEmpty(obj.CA10__avgDriverJvmHeapUsage14d__c)) { throw new Error("UNDETERMINED condition:404", {cause: {status: 'UNDETERMINED', conditionIndex: 404, conditionText: "CA10__avgDriverJvmHeapUsage14d__c.isEmpty()", currentStateMessage: "The 14-day driver JVM heap utilization is unavailable.", currentStateReferences: references1.join('\n'), remediation: null, runtimeError: null}}); } return obj.CA10__avgDriverJvmHeapUsage14d__c; } function extract33() { if (!this.out) { this.out = fieldChecked34(); } return this.out; }; references1.push('CloudWatch: All CPU System Load 14-Day [obj.CA10__avgAllCpuSystemLoad14d__c]: ' + obj.CA10__avgAllCpuSystemLoad14d__c); references1.push('CloudWatch: All JVM Heap Usage 14-Day [obj.CA10__avgAllJvmHeapUsage14d__c]: ' + obj.CA10__avgAllJvmHeapUsage14d__c); references1.push('CloudWatch: Driver CPU SystemLoad 14-Day [obj.CA10__avgDriverCpuSystemLoad14d__c]: ' + obj.CA10__avgDriverCpuSystemLoad14d__c); references1.push('CloudWatch: Driver JVM Heap Usage 14-Day [obj.CA10__avgDriverJvmHeapUsage14d__c]: ' + obj.CA10__avgDriverJvmHeapUsage14d__c); try { if ((extract15.call(extract15) != null && 0.0 != null && extract15.call(extract15) <= 0.0) || (extract15.call(extract15) != null && 100.0 != null && extract15.call(extract15) > 100.0) || (extract21.call(extract21) != null && 0.0 != null && extract21.call(extract21) <= 0.0) || (extract21.call(extract21) != null && 100.0 != null && extract21.call(extract21) > 100.0) || (extract27.call(extract27) != null && 0.0 != null && extract27.call(extract27) <= 0.0) || (extract27.call(extract27) != null && 100.0 != null && extract27.call(extract27) > 100.0) || (extract33.call(extract33) != null && 0.0 != null && extract33.call(extract33) <= 0.0) || (extract33.call(extract33) != null && 100.0 != null && extract33.call(extract33) > 100.0)) { return {status: 'UNDETERMINED', conditionIndex: 499, conditionText: "extract('CA10__avgAllCpuSystemLoad14d__c') <= number(0.0) || extract('CA10__avgAllCpuSystemLoad14d__c') > number(100.0) || extract('CA10__avgAllJvmHeapUsage14d__c') <= number(0.0) || extract('CA10__avgAllJvmHeapUsage14d__c') > number(100.0) || extract('CA10__avgDriverCpuSystemLoad14d__c') <= number(0.0) || extract('CA10__avgDriverCpuSystemLoad14d__c') > number(100.0) || extract('CA10__avgDriverJvmHeapUsage14d__c') <= number(0.0) || extract('CA10__avgDriverJvmHeapUsage14d__c') > number(100.0)", currentStateMessage: "At least one 14-day utilization percentage is zero or outside the valid 0 to 100 range; positive utilization evidence is required.", currentStateReferences: references1.join('\n'), remediation: null, runtimeError: null}; } } catch (err) { if (err.cause && err.cause.status) { return err.cause; } else { throw err; } } // condition[5], conditionIndex:[500..599] function fieldChecked40() { if (IsEmptyLib.simpleIsEmpty(obj.CA10__numCompletedTasksSum7d__c)) { throw new Error("UNDETERMINED condition:501", {cause: {status: 'UNDETERMINED', conditionIndex: 501, conditionText: "CA10__numCompletedTasksSum7d__c.isEmpty()", currentStateMessage: "The 7-day completed-task count is unavailable.", currentStateReferences: references1.join('\n'), remediation: null, runtimeError: null}}); } return obj.CA10__numCompletedTasksSum7d__c; } function extract39() { if (!this.out) { this.out = fieldChecked40(); } return this.out; }; function fieldChecked44() { if (IsEmptyLib.simpleIsEmpty(obj.CA10__numCompletedTasksSum14d__c)) { throw new Error("UNDETERMINED condition:502", {cause: {status: 'UNDETERMINED', conditionIndex: 502, conditionText: "CA10__numCompletedTasksSum14d__c.isEmpty()", currentStateMessage: "The 14-day completed-task count is unavailable.", currentStateReferences: references1.join('\n'), remediation: null, runtimeError: null}}); } return obj.CA10__numCompletedTasksSum14d__c; } function extract43() { if (!this.out) { this.out = fieldChecked44(); } return this.out; }; references1.push('CloudWatch: Num Completed Tasks 7-Day [obj.CA10__numCompletedTasksSum7d__c]: ' + obj.CA10__numCompletedTasksSum7d__c); try { if ((extract39.call(extract39) != null && 0.0 != null && extract39.call(extract39) <= 0.0) || (extract43.call(extract43) != null && extract39.call(extract39) != null && extract43.call(extract43) <= extract39.call(extract39))) { return {status: 'UNDETERMINED', conditionIndex: 599, conditionText: "extract('CA10__numCompletedTasksSum7d__c') <= number(0.0) || extract('CA10__numCompletedTasksSum14d__c') <= extract('CA10__numCompletedTasksSum7d__c')", currentStateMessage: "Completed-task totals do not establish activity in both halves of the 14-day period, or the totals are inconsistent.", currentStateReferences: references1.join('\n'), remediation: null, runtimeError: null}; } } catch (err) { if (err.cause && err.cause.status) { return err.cause; } else { throw err; } } // condition[6], conditionIndex:[600..699] function fieldChecked49() { if (IsEmptyLib.simpleIsEmpty(obj.CA10__avgAllCpuSystemLoad14d__c)) { throw new Error("UNDETERMINED condition:601", {cause: {status: 'UNDETERMINED', conditionIndex: 601, conditionText: "CA10__avgAllCpuSystemLoad14d__c.isEmpty()", currentStateMessage: "The 14-day executor CPU utilization is unavailable.", currentStateReferences: references1.join('\n'), remediation: null, runtimeError: null}}); } return obj.CA10__avgAllCpuSystemLoad14d__c; } function extract48() { if (!this.out) { this.out = fieldChecked49(); } return this.out; }; function fieldChecked53() { if (IsEmptyLib.simpleIsEmpty(obj.CA10__avgAllJvmHeapUsage14d__c)) { throw new Error("UNDETERMINED condition:602", {cause: {status: 'UNDETERMINED', conditionIndex: 602, conditionText: "CA10__avgAllJvmHeapUsage14d__c.isEmpty()", currentStateMessage: "The 14-day executor JVM heap utilization is unavailable.", currentStateReferences: references1.join('\n'), remediation: null, runtimeError: null}}); } return obj.CA10__avgAllJvmHeapUsage14d__c; } function extract52() { if (!this.out) { this.out = fieldChecked53(); } return this.out; }; function fieldChecked57() { if (IsEmptyLib.simpleIsEmpty(obj.CA10__avgDriverCpuSystemLoad14d__c)) { throw new Error("UNDETERMINED condition:603", {cause: {status: 'UNDETERMINED', conditionIndex: 603, conditionText: "CA10__avgDriverCpuSystemLoad14d__c.isEmpty()", currentStateMessage: "The 14-day driver CPU utilization is unavailable.", currentStateReferences: references1.join('\n'), remediation: null, runtimeError: null}}); } return obj.CA10__avgDriverCpuSystemLoad14d__c; } function extract56() { if (!this.out) { this.out = fieldChecked57(); } return this.out; }; function fieldChecked61() { if (IsEmptyLib.simpleIsEmpty(obj.CA10__avgDriverJvmHeapUsage14d__c)) { throw new Error("UNDETERMINED condition:604", {cause: {status: 'UNDETERMINED', conditionIndex: 604, conditionText: "CA10__avgDriverJvmHeapUsage14d__c.isEmpty()", currentStateMessage: "The 14-day driver JVM heap utilization is unavailable.", currentStateReferences: references1.join('\n'), remediation: null, runtimeError: null}}); } return obj.CA10__avgDriverJvmHeapUsage14d__c; } function extract60() { if (!this.out) { this.out = fieldChecked61(); } return this.out; }; try { if ((extract48.call(extract48) != null && 20.0 != null && extract48.call(extract48) < 20.0) && (extract52.call(extract52) != null && 20.0 != null && extract52.call(extract52) < 20.0) && (extract56.call(extract56) != null && 20.0 != null && extract56.call(extract56) < 20.0) && (extract60.call(extract60) != null && 20.0 != null && extract60.call(extract60) < 20.0)) { return {status: 'INCOMPLIANT', conditionIndex: 699, conditionText: "extract('CA10__avgAllCpuSystemLoad14d__c') < number(20.0) && extract('CA10__avgAllJvmHeapUsage14d__c') < number(20.0) && extract('CA10__avgDriverCpuSystemLoad14d__c') < number(20.0) && extract('CA10__avgDriverJvmHeapUsage14d__c') < number(20.0)", currentStateMessage: "The job completed tasks in both halves of the 14-day period, and average driver and executor CPU and JVM heap utilization are all positive and below 20%.", currentStateReferences: references1.join('\n'), remediation: "Review worker sizing, parallelism, peak demand, disk usage, and actual Auto Scaling allocation. Benchmark changes before reducing capacity.", runtimeError: null}; } } catch (err) { if (err.cause && err.cause.status) { return err.cause; } else { throw err; } } return {status: 'COMPLIANT', conditionIndex: 700, conditionText: "otherwise", currentStateMessage: "At least one driver or executor CPU or JVM heap average is 20% or higher; the low-average criterion is not met. This does not establish appropriate job sizing.", currentStateReferences: references1.join('\n'), remediation: null, runtimeError: null}; """; SELECT expectedResult.Id as Id, IF ( IFNULL(expectedResult.expectedResult.status, '') = IFNULL(sObject.result.status, '') AND IFNULL(expectedResult.expectedResult.conditionIndex, -1) = IFNULL(sObject.result.conditionIndex, -1) AND IFNULL(expectedResult.expectedResult.conditionText, '') = IFNULL(sObject.result.conditionText, '') AND IFNULL(expectedResult.expectedResult.runtimeError, '') = IFNULL(sObject.result.runtimeError, ''), "MATCH", "FAIL" ) as match, expectedResult.expectedResult.status as expectedStatus, sObject.result.status as actualStatus, expectedResult.expectedResult.conditionIndex as expectedConditionIndex, sObject.result.conditionIndex as actualConditionIndex, expectedResult.expectedResult.conditionText as expectedConditionText, sObject.result.conditionText as actualConditionText, expectedResult.expectedResult.runtimeError as expectedRuntimeError, sObject.result.runtimeError as actualRuntimeError FROM UNNEST(mock_ExpectedResult()) expectedResult LEFT JOIN ( SELECT sObject.CA10__disappearanceTime__c AS CA10__disappearanceTime__c, sObject.CA10__commandName__c AS CA10__commandName__c, sObject.CA10__createdOn__c AS CA10__createdOn__c, sObject.CA10__numCompletedTasksSum14d__c AS CA10__numCompletedTasksSum14d__c, sObject.CA10__avgAllCpuSystemLoad14d__c AS CA10__avgAllCpuSystemLoad14d__c, sObject.CA10__avgAllJvmHeapUsage14d__c AS CA10__avgAllJvmHeapUsage14d__c, sObject.CA10__avgDriverCpuSystemLoad14d__c AS CA10__avgDriverCpuSystemLoad14d__c, sObject.CA10__avgDriverJvmHeapUsage14d__c AS CA10__avgDriverJvmHeapUsage14d__c, sObject.CA10__numCompletedTasksSum7d__c AS CA10__numCompletedTasksSum7d__c, sObject.Id AS Id, process_CA10__CaAwsGlueJob__c( STRUCT( sObject.CA10__disappearanceTime__c AS CA10__disappearanceTime__c, sObject.CA10__commandName__c AS CA10__commandName__c, sObject.CA10__createdOn__c AS CA10__createdOn__c, sObject.CA10__numCompletedTasksSum14d__c AS CA10__numCompletedTasksSum14d__c, sObject.CA10__avgAllCpuSystemLoad14d__c AS CA10__avgAllCpuSystemLoad14d__c, sObject.CA10__avgAllJvmHeapUsage14d__c AS CA10__avgAllJvmHeapUsage14d__c, sObject.CA10__avgDriverCpuSystemLoad14d__c AS CA10__avgDriverCpuSystemLoad14d__c, sObject.CA10__avgDriverJvmHeapUsage14d__c AS CA10__avgDriverJvmHeapUsage14d__c, sObject.CA10__numCompletedTasksSum7d__c AS CA10__numCompletedTasksSum7d__c, sObject.Id AS Id ), sObject.context.snapshotTime ) as result FROM UNNEST(mock_CA10__CaAwsGlueJob__c()) AS sObject ) sObject ON sObject.Id = expectedResult.Id;