Mondoo Docs

Google Cloud (GCP) SQL instance settings

gcp.project.sqlService.instance.settings MQL resource for querying Google Cloud infrastructure with cnquery and cnspec.

Google CloudPrivate Resource

Google Cloud (GCP) SQL instance settings

Min version: latest

Relationships

Mini Map
Google Cloud
8 resources · 9 relationshipsClick to select, expand fields to see properties.

Fields (31)

FieldTypeDescription
activationPolicyrequired
stringWhen the instance is activated
activeDirectoryConfigrequired
dictEntra ID (formerly Active Directory) configuration (relevant only for Cloud SQL for SQL Server)
availabilityTyperequired
stringAvailability type
backupconfigurationprivate
gcp.project.sqlService.instance.settings.backupconfigurationGoogle Cloud (GCP) SQL instance settings backup configuration
backupConfigurationrequired
gcp.project.sqlService.instance.settings.backupconfigurationDaily backup configuration for the instance
collationrequired
stringName of the server collation
connectorEnforcementrequired
stringWhether connections must use Cloud SQL connectors
crashSafeReplicationEnabledrequired
intWhether database flags for crash-safe replication are enabled
databaseFlagsrequired
map[string]stringDatabase flags passed to the instance at startup
databaseReplicationEnabledrequired
intWhether replication is enabled
dataDiskSizeGbrequired
intSize of the data disk, in GB
dataDiskTyperequired
stringType of the data disk
deletionProtectionEnabledrequired
intWhether to protect against accidental instance deletion
denyMaintenancePeriodprivate
gcp.project.sqlService.instance.settings.denyMaintenancePeriodGoogle Cloud (GCP) SQL instance settings deny maintenance period
denyMaintenancePeriodsrequired
[]gcp.project.sqlService.instance.settings.denyMaintenancePeriodDeny maintenance periods
insightsConfigrequired
dictInsights configuration
instanceNamerequired
stringInstance name
ipConfigurationrequired
gcp.project.sqlService.instance.settings.ipConfigurationIP management settings
locationPreferencerequired
dictLocation preference settings
maintenanceWindowrequired
gcp.project.sqlService.instance.settings.maintenanceWindowMaintenance window
passwordValidationPolicyrequired
gcp.project.sqlService.instance.settings.passwordValidationPolicyLocal user password validation policy
pricingPlanrequired
stringPricing plan
projectIdrequired
stringProject ID
replicationTyperequired
stringReplication type
settingsVersionrequired
intInstance settings version
sqlServerAuditConfigrequired
dictSQL-server-specific audit configuration
storageAutoResizerequired
intWhether to increase storage size automatically
storageAutoResizeLimitrequired
intMaximum size to which storage capacity can be automatically increased
tierrequired
stringService tier for this instance
timeZonerequired
stringServer timezone
userLabelsrequired
map[string]stringUser-provided labels