GCP Cloud SQL

GCP Cloud SQL tab includes:

·         Security Risk Cards Section,

·         Filter Section,

·         Data Table that contains Table Settings Button, Export Button, Refresh Button, Account ID, Account Name, SQL Instance Name, SQL Engine Type, SQL Instance Class, Security Risks, Region (pre-selected, can be de-selected), Zone (pre-selected, can be de-selected), Backup Retention Period (is shown, if it is selected in the table settings), Host (is shown, if it is selected in the table settings), Port (is shown, if it is selected in the table settings), Service Account (is shown, if it is selected in the table settings), IAM Roles Attached (is shown, if it is selected in the table settings), Storage Size (is shown, if it is selected in the table settings), Storage Type (is shown, if it is selected in the table settings) and Info.

Once the user clicks the Details button on the security risk card, the modal window is opened. The modal window consists of risk information, risk assessment summary, and SQL Instances with severity levels, if the security risk has severity levels. If the security risk hasn’t any severity levels, the modal window only consists of risk information and risk assessment summary.

Once the Info button is clicked, the SQL Instance Information modal is opened. The modal has two subsections: the former contains either Egress or Ingress Rules, whereas the latter (SQL Instance Details) contains SQL instance details such as SQL Instance Name, Engine Type, State, Region, Zone, Host, Port, Public IP (IPv4), IAM DB Authentication, CMEK Key and lastly Service Account.