⭐ Repository → 📁 Compliance Engine → 📁 CloudAware → 📁 Google → 📁 Cloud SQL → 🛡️ Instance SSL Connections are not enforced🟢

🧠 Google Cloud SQL Instance SSL Connections are not enforced - prod.logic.yaml🟢

• Contextual name: 🧠 prod.logic.yaml🟢
• ID: /ce/ca/google/sql/instance-ssl/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:58.626764162Z Open

Result	Id	Condition Index	Condition Text	Runtime Error
🟢	a8LVU0	✔️ 200	✔️ otherwise	✔️ null
🟢	a8LVU1	✔️ 199	✔️ extract('CA10__sslMode__c') == 'ENCRYPTED_ONLY'	✔️ null

Generation Bundle

	File	MD5
Open	/ce/ca/google/sql/instance-ssl/policy.yaml	4913F7C314C2AB7C7C19D68EF6B36869
Open	/ce/ca/google/sql/instance-ssl/prod.logic.yaml	9613394DCB99811F02F46006C18B2BAA
Open	/ce/ca/google/sql/instance-ssl/test-data.json	04C28D354D4426F541AF319D6D8A2867
Open	/types/CA10__CaGoogleSqlInstance__c/object.extracts.yaml	8DD86EFB2FFA06BD1E9BC0452FF2EC8A

Available Commands

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

Content

Open File

---

inputType: "CA10__CaGoogleSqlInstance__c"
testData:
  - file: test-data.json
importExtracts:
  - file: /types/CA10__CaGoogleSqlInstance__c/object.extracts.yaml
conditions:
  - status: "COMPLIANT"
    currentStateMessage: "The SQL Instance requires all incoming connections to use SSL."
    check:
          IS_EQUAL:
            left:
              EXTRACT: "CA10__sslMode__c"
            right:
              TEXT: "ENCRYPTED_ONLY"
otherwise:
  status: "INCOMPLIANT"
  currentStateMessage: "The SQL Instance does not require incoming connections use SSL."
  remediationMessage: "Enforce all incoming connections to SQL database instance to use SSL."