⭐ Repository → 📁 Compliance Engine → 📁 CloudAware → 📁 Google → 📁 Cloud SQL → 🛡️ Instance is located in a less cost-effective region🟢

🧠 Google Cloud SQL Instance is located in a less cost-effective region - prod.logic.yaml🟢

Contextual name: 🧠 prod.logic.yaml🟢
ID: /ce/ca/google/sql/instance-cost-effective-region/prod.logic.yaml
Tags:
- 🟢 Logic test success
- 🟢 Logic with extracts
- 🟢 Logic with test data

Uses

📗 Google Cloud SQL Instance
🔌 Google Cloud SQL Instance - object.extracts.yaml
🧪 test-data.json

Test Results 🟢

Generated at: 2025-10-01T12:50:55.903230671Z Open

Result	Id	Condition Index	Condition Text	Runtime Error
🟢	001	✔️ `99`	✔️ `isDisappeared(CA10__disappearanceTime__c)`	✔️ `null`
🟢	002	✔️ `1299`	✔️ `extract('CA10__regionName__c') == 'europe-west3'`	✔️ `null`
🟢	003	✔️ `1600`	✔️ `otherwise`	✔️ `null`

Generation Bundle

	File	MD5
Open	`/ce/ca/google/sql/instance-cost-effective-region/policy.yaml`	`626DB8CAD9729AD87E750C991CE7407C`
Open	`/ce/ca/google/sql/instance-cost-effective-region/prod.logic.yaml`	`00DF825415029589406CC7F8D3C85432`
Open	`/ce/ca/google/sql/instance-cost-effective-region/test-data.json`	`19D28E30904B65AA8F6061ECB7672E2F`
Open	`/types/CA10__CaGoogleSqlInstance__c/object.extracts.yaml`	`8DD86EFB2FFA06BD1E9BC0452FF2EC8A`

Available Commands

repo-manager policies generate FULL /ce/ca/google/sql/instance-cost-effective-region/prod.logic.yaml
repo-manager policies generate DEBUG /ce/ca/google/sql/instance-cost-effective-region/prod.logic.yaml
repo-manager policies generate CAPTURE_TEST_DATA /ce/ca/google/sql/instance-cost-effective-region/prod.logic.yaml
repo-manager policies generate TESTS /ce/ca/google/sql/instance-cost-effective-region/prod.logic.yaml
# Execute tests
repo-manager policies test /ce/ca/google/sql/instance-cost-effective-region/prod.logic.yaml

Content

Open File

---
inputType: "CA10__CaGoogleSqlInstance__c"
importExtracts:
  - file: "/types/CA10__CaGoogleSqlInstance__c/object.extracts.yaml"
testData:
  - file: 'test-data.json'
conditions:
  - status: "INCOMPLIANT"
    currentStateMessage: "The Instance is running in us-west2 which is more expensive than us-west1."
    remediationMessage: "Consider migrating the Instance to us-west1."
    check:
      IS_EQUAL:
        left:
          EXTRACT: CA10__regionName__c
        right:
          TEXT: "us-west2"
  - status: "INCOMPLIANT"
    currentStateMessage: "The Instance is running in us-west3 which is more expensive than us-west1."
    remediationMessage: "Consider migrating the Instance to us-west1."
    check:
      IS_EQUAL:
        left:
          EXTRACT: CA10__regionName__c
        right:
          TEXT: "us-west3"
  - status: "INCOMPLIANT"
    currentStateMessage: "The Instance is running in us-west4 which is more expensive than us-west1."
    remediationMessage: "Consider migrating the Instance to us-west1."
    check:
      IS_EQUAL:
        left:
          EXTRACT: CA10__regionName__c
        right:
          TEXT: "us-west4"
  - status: "INCOMPLIANT"
    currentStateMessage: "The Instance is running in us-south1 which is more expensive than us-east1, us-east5 or us-central1."
    remediationMessage: "Consider migrating the Instance to us-east1, us-east5 or us-central1."
    check:
      IS_EQUAL:
        left:
          EXTRACT: CA10__regionName__c
        right:
          TEXT: "us-south1"
  - status: "INCOMPLIANT"
    currentStateMessage: "The Instance is running in northamerica-northeast1 which is more expensive than us-east1, us-east5 or us-central1."
    remediationMessage: "Consider migrating the Instance to us-east1, us-east5 or us-central1."
    check:
      IS_EQUAL:
        left:
          EXTRACT: CA10__regionName__c
        right:
          TEXT: "northamerica-northeast1"
  - status: "INCOMPLIANT"
    currentStateMessage: "The Instance is running in northamerica-northeast2 which is more expensive than us-east1, us-east5 or us-central1."
    remediationMessage: "Consider migrating the Instance to us-east1, us-east5 or us-central1."
    check:
      IS_EQUAL:
        left:
          EXTRACT: CA10__regionName__c
        right:
          TEXT: "northamerica-northeast2"
  - status: "INCOMPLIANT"
    currentStateMessage: "The Instance is running in europe-north1 which is more expensive than europe-north2 or europe-west1."
    remediationMessage: "Consider migrating the Instance to europe-north2 or europe-west1."
    check:
      IS_EQUAL:
        left:
          EXTRACT: CA10__regionName__c
        right:
          TEXT: "europe-north1"
  - status: "INCOMPLIANT"
    currentStateMessage: "The Instance is running in europe-southwest1 which is more expensive than europe-north2 or europe-west1."
    remediationMessage: "Consider migrating the Instance to europe-north2 or europe-west1."
    check:
      IS_EQUAL:
        left:
          EXTRACT: CA10__regionName__c
        right:
          TEXT: "europe-southwest1"
  - status: "INCOMPLIANT"
    currentStateMessage: "The Instance is running in europe-west1 which is more expensive than europe-north2 or europe-west1."
    remediationMessage: "Consider migrating the Instance to europe-north2 or europe-west1."
    check:
      IS_EQUAL:
        left:
          EXTRACT: CA10__regionName__c
        right:
          TEXT: "europe-west4"
  - status: "INCOMPLIANT"
    currentStateMessage: "The Instance is running in europe-west12 which is more expensive than europe-north2 or europe-west1."
    remediationMessage: "Consider migrating the Instance to europe-north2 or europe-west1."
    check:
      IS_EQUAL:
        left:
          EXTRACT: CA10__regionName__c
        right:
          TEXT: "europe-west12"
  - status: "INCOMPLIANT"
    currentStateMessage: "The Instance is running in europe-west2 which is more expensive than europe-north2 or europe-west1."
    remediationMessage: "Consider migrating the Instance to europe-north2 or europe-west1."
    check:
      IS_EQUAL:
        left:
          EXTRACT: CA10__regionName__c
        right:
          TEXT: "europe-west2"
  - status: "INCOMPLIANT"
    currentStateMessage: "The Instance is running in europe-west3 which is more expensive than europe-north2 or europe-west1."
    remediationMessage: "Consider migrating the Instance to europe-north2 or europe-west1."
    check:
      IS_EQUAL:
        left:
          EXTRACT: CA10__regionName__c
        right:
          TEXT: "europe-west3"
  - status: "INCOMPLIANT"
    currentStateMessage: "The Instance is running in europe-west6 which is more expensive than europe-north2 or europe-west1."
    remediationMessage: "Consider migrating the Instance to europe-north2 or europe-west1."
    check:
      IS_EQUAL:
        left:
          EXTRACT: CA10__regionName__c
        right:
          TEXT: "europe-west6"
  - status: "INCOMPLIANT"
    currentStateMessage: "The Instance is running in europe-west8 which is more expensive than europe-north2 or europe-west1."
    remediationMessage: "Consider migrating the Instance to europe-north2 or europe-west1."
    check:
      IS_EQUAL:
        left:
          EXTRACT: CA10__regionName__c
        right:
          TEXT: "europe-west8"
  - status: "INCOMPLIANT"
    currentStateMessage: "The Instance is running in europe-west9 which is more expensive than europe-north2 or europe-west1."
    remediationMessage: "Consider migrating the Instance to europe-north2 or europe-west1."
    check:
      IS_EQUAL:
        left:
          EXTRACT: CA10__regionName__c
        right:
          TEXT: "europe-west9"
otherwise:
  status: "COMPLIANT"
  currentStateMessage: "The Instance is located in a cost-effective region."

Uses​

Test Results 🟢​

Generation Bundle​

Available Commands​

Content​

Uses

Test Results 🟢

Generation Bundle

Available Commands

Content