이 페이지는 아직 한국어로 제공되지 않으며 번역 작업 중입니다. 번역에 관한 질문이나 의견이 있으시면 언제든지 저희에게 연락해 주십시오.

gcp_sql_database_instance

`ancestors`

Type: UNORDERED_LIST_STRING

`available_maintenance_versions`

Type: UNORDERED_LIST_STRING
Provider name: availableMaintenanceVersions
Description: Output only. List all maintenance versions applicable on the instance

`backend_type`

Type: STRING
Provider name: backendType
Description: The backend type. SECOND_GEN: Cloud SQL database instance. EXTERNAL: A database server that is not managed by Google. This property is read-only; use the tier property in the settings object to determine the database type.
Possible values:

SQL_BACKEND_TYPE_UNSPECIFIED - This is an unknown backend type for instance.
FIRST_GEN - V1 speckle instance.
SECOND_GEN - V2 speckle instance.
EXTERNAL - On premises instance.

`connection_name`

Type: STRING
Provider name: connectionName
Description: Connection name of the Cloud SQL instance used in connection strings.

`create_time`

Type: TIMESTAMP
Provider name: createTime
Description: Output only. The time when the instance was created in RFC 3339 format, for example 2012-11-15T16:19:00.094Z.

`current_disk_size`

Type: INT64
Provider name: currentDiskSize
Description: The current disk usage of the instance in bytes. This property has been deprecated. Use the “cloudsql.googleapis.com/database/disk/bytes_used” metric in Cloud Monitoring API instead. Please see this announcement for details.

`database_installed_version`

Type: STRING
Provider name: databaseInstalledVersion
Description: Output only. Stores the current database version running on the instance including minor version such as MYSQL_8_0_18.

`database_version`

Type: STRING
Provider name: databaseVersion
Description: The database engine type and version. The databaseVersion field cannot be changed after instance creation.
Possible values:

SQL_DATABASE_VERSION_UNSPECIFIED - This is an unknown database version.
MYSQL_5_1 - The database version is MySQL 5.1.
MYSQL_5_5 - The database version is MySQL 5.5.
MYSQL_5_6 - The database version is MySQL 5.6.
MYSQL_5_7 - The database version is MySQL 5.7.
SQLSERVER_2017_STANDARD - The database version is SQL Server 2017 Standard.
SQLSERVER_2017_ENTERPRISE - The database version is SQL Server 2017 Enterprise.
SQLSERVER_2017_EXPRESS - The database version is SQL Server 2017 Express.
SQLSERVER_2017_WEB - The database version is SQL Server 2017 Web.
POSTGRES_9_6 - The database version is PostgreSQL 9.6.
POSTGRES_10 - The database version is PostgreSQL 10.
POSTGRES_11 - The database version is PostgreSQL 11.
POSTGRES_12 - The database version is PostgreSQL 12.
POSTGRES_13 - The database version is PostgreSQL 13.
POSTGRES_14 - The database version is PostgreSQL 14.
POSTGRES_15 - The database version is PostgreSQL 15.
MYSQL_8_0 - The database version is MySQL 8.
MYSQL_8_0_18 - The database major version is MySQL 8.0 and the minor version is 18.
MYSQL_8_0_26 - The database major version is MySQL 8.0 and the minor version is 26.
MYSQL_8_0_27 - The database major version is MySQL 8.0 and the minor version is 27.
MYSQL_8_0_28 - The database major version is MySQL 8.0 and the minor version is 28.
MYSQL_8_0_29 - The database major version is MySQL 8.0 and the minor version is 29.
MYSQL_8_0_30 - The database major version is MySQL 8.0 and the minor version is 30.
MYSQL_8_0_31 - The database major version is MySQL 8.0 and the minor version is 31.
MYSQL_8_0_32 - The database major version is MySQL 8.0 and the minor version is 32.
MYSQL_8_0_33 - The database major version is MySQL 8.0 and the minor version is 33.
MYSQL_8_0_34 - The database major version is MySQL 8.0 and the minor version is 34.
MYSQL_8_0_35 - The database major version is MySQL 8.0 and the minor version is 35.
MYSQL_8_0_36 - The database major version is MySQL 8.0 and the minor version is 36.
SQLSERVER_2019_STANDARD - The database version is SQL Server 2019 Standard.
SQLSERVER_2019_ENTERPRISE - The database version is SQL Server 2019 Enterprise.
SQLSERVER_2019_EXPRESS - The database version is SQL Server 2019 Express.
SQLSERVER_2019_WEB - The database version is SQL Server 2019 Web.
SQLSERVER_2022_STANDARD - The database version is SQL Server 2022 Standard.
SQLSERVER_2022_ENTERPRISE - The database version is SQL Server 2022 Enterprise.
SQLSERVER_2022_EXPRESS - The database version is SQL Server 2022 Express.
SQLSERVER_2022_WEB - The database version is SQL Server 2022 Web.

`disk_encryption_configuration`

Type: STRUCT
Provider name: diskEncryptionConfiguration
Description: Disk encryption configuration specific to an instance.

kind
Type: STRING
Provider name: kind
Description: This is always sql#diskEncryptionConfiguration.
kms_key_name
Type: STRING
Provider name: kmsKeyName
Description: Resource name of KMS key for disk encryption

`disk_encryption_status`

Type: STRUCT
Provider name: diskEncryptionStatus
Description: Disk encryption status specific to an instance.

kind
Type: STRING
Provider name: kind
Description: This is always sql#diskEncryptionStatus.
kms_key_version_name
Type: STRING
Provider name: kmsKeyVersionName
Description: KMS key version used to encrypt the Cloud SQL instance resource

`etag`

Type: STRING
Provider name: etag
Description: This field is deprecated and will be removed from a future version of the API. Use the settings.settingsVersion field instead.

`failover_replica`

Type: STRUCT
Provider name: failoverReplica
Description: The name and status of the failover replica.

available
Type: BOOLEAN
Provider name: available
Description: The availability status of the failover replica. A false status indicates that the failover replica is out of sync. The primary instance can only failover to the failover replica when the status is true.
name
Type: STRING
Provider name: name
Description: The name of the failover replica. If specified at instance creation, a failover replica is created for the instance. The name doesn’t include the project ID.

`gce_zone`

Type: STRING
Provider name: gceZone
Description: The Compute Engine zone that the instance is currently serving from. This value could be different from the zone that was specified when the instance was created if the instance has failed over to its secondary zone. WARNING: Changing this might restart the instance.

`instance_type`

Type: STRING
Provider name: instanceType
Description: The instance type.
Possible values:

SQL_INSTANCE_TYPE_UNSPECIFIED - This is an unknown Cloud SQL instance type.
CLOUD_SQL_INSTANCE - A regular Cloud SQL instance that is not replicating from a primary instance.
ON_PREMISES_INSTANCE - An instance running on the customer’s premises that is not managed by Cloud SQL.
READ_REPLICA_INSTANCE - A Cloud SQL instance acting as a read-replica.

`ip_addresses`

Type: UNORDERED_LIST_STRUCT
Provider name: ipAddresses
Description: The assigned IP addresses for the instance.

ip_address
Type: STRING
Provider name: ipAddress
Description: The IP address assigned.
time_to_retire
Type: TIMESTAMP
Provider name: timeToRetire
Description: The due time for this IP to be retired in RFC 3339 format, for example 2012-11-15T16:19:00.094Z. This field is only available when the IP is scheduled to be retired.
type
Type: STRING
Provider name: type
Description: The type of this IP address. A PRIMARY address is a public address that can accept incoming connections. A PRIVATE address is a private address that can accept incoming connections. An OUTGOING address is the source address of connections originating from the instance, if supported.
Possible values:
- SQL_IP_ADDRESS_TYPE_UNSPECIFIED - This is an unknown IP address type.
- PRIMARY - IP address the customer is supposed to connect to. Usually this is the load balancer’s IP address
- OUTGOING - Source IP address of the connection a read replica establishes to its external primary instance. This IP address can be allowlisted by the customer in case it has a firewall that filters incoming connection to its on premises primary instance.
- PRIVATE - Private IP used when using private IPs and network peering.
- MIGRATED_1ST_GEN - V1 IP of a migrated instance. We want the user to decommission this IP as soon as the migration is complete. Note: V1 instances with V1 ip addresses will be counted as PRIMARY.

`ipv6_address`

Type: STRING
Provider name: ipv6Address
Description: The IPv6 address assigned to the instance. (Deprecated) This property was applicable only to First Generation instances.

`kind`

Type: STRING
Provider name: kind
Description: This is always sql#instance.

`labels`

Type: UNORDERED_LIST_STRING

`maintenance_version`

Type: STRING
Provider name: maintenanceVersion
Description: The current software version on the instance.

`master_instance_name`

Type: STRING
Provider name: masterInstanceName
Description: The name of the instance which will act as primary in the replication setup.

`max_disk_size`

Type: INT64
Provider name: maxDiskSize
Description: The maximum disk size of the instance in bytes.

`name`

Type: STRING
Provider name: name
Description: Name of the Cloud SQL instance. This does not include the project ID.

`on_premises_configuration`

Type: STRUCT
Provider name: onPremisesConfiguration
Description: Configuration specific to on-premises instances.

ca_certificate
Type: STRING
Provider name: caCertificate
Description: PEM representation of the trusted CA’s x509 certificate.
client_certificate
Type: STRING
Provider name: clientCertificate
Description: PEM representation of the replica’s x509 certificate.
client_key
Type: STRING
Provider name: clientKey
Description: PEM representation of the replica’s private key. The corresponsing public key is encoded in the client’s certificate.
dump_file_path
Type: STRING
Provider name: dumpFilePath
Description: The dump file to create the Cloud SQL replica.
host_port
Type: STRING
Provider name: hostPort
Description: The host and port of the on-premises instance in host:port format
kind
Type: STRING
Provider name: kind
Description: This is always sql#onPremisesConfiguration.
source_instance
Type: STRUCT
Provider name: sourceInstance
Description: The reference to Cloud SQL instance if the source is Cloud SQL.
- name
  Type: STRING
  Provider name: name
  Description: The name of the Cloud SQL instance being referenced. This does not include the project ID.
- project
  Type: STRING
  Provider name: project
  Description: The project ID of the Cloud SQL instance being referenced. The default is the same project ID as the instance references it.
- region
  Type: STRING
  Provider name: region
  Description: The region of the Cloud SQL instance being referenced.
username
Type: STRING
Provider name: username
Description: The username for connecting to on-premises instance.

`organization_id`

Type: STRING

`out_of_disk_report`

Type: STRUCT
Provider name: outOfDiskReport
Description: This field represents the report generated by the proactive database wellness job for OutOfDisk issues. * Writers: * the proactive database wellness job for OOD. * Readers: * the proactive database wellness job

sql_min_recommended_increase_size_gb
Type: INT32
Provider name: sqlMinRecommendedIncreaseSizeGb
Description: The minimum recommended increase size in GigaBytes This field is consumed by the frontend * Writers: * the proactive database wellness job for OOD. * Readers:
sql_out_of_disk_state
Type: STRING
Provider name: sqlOutOfDiskState
Description: This field represents the state generated by the proactive database wellness job for OutOfDisk issues. * Writers: * the proactive database wellness job for OOD. * Readers: * the proactive database wellness job
Possible values:
- SQL_OUT_OF_DISK_STATE_UNSPECIFIED - Unspecified state
- NORMAL - The instance has plenty space on data disk
- SOFT_SHUTDOWN - Data disk is almost used up. It is shutdown to prevent data corruption.

`parent`

Type: STRING

`project`

Type: STRING
Provider name: project
Description: The project ID of the project containing the Cloud SQL instance. The Google apps domain is prefixed if applicable.

`project_id`

Type: STRING

`project_number`

Type: STRING

`region`

Type: STRING
Provider name: region
Description: The geographical region. Can be: * us-central (FIRST_GEN instances only) * us-central1 (SECOND_GEN instances only) * asia-east1 or europe-west1. Defaults to us-central or us-central1 depending on the instance type. The region cannot be changed after instance creation.

`replica_configuration`

Type: STRUCT
Provider name: replicaConfiguration
Description: Configuration specific to failover replicas and read replicas.

failover_target
Type: BOOLEAN
Provider name: failoverTarget
Description: Specifies if the replica is the failover target. If the field is set to true the replica will be designated as a failover replica. In case the primary instance fails, the replica instance will be promoted as the new primary instance. Only one replica can be specified as failover target, and the replica has to be in different zone with the primary instance.
kind
Type: STRING
Provider name: kind
Description: This is always sql#replicaConfiguration.
mysql_replica_configuration
Type: STRUCT
Provider name: mysqlReplicaConfiguration
Description: MySQL specific configuration when replicating from a MySQL on-premises primary instance. Replication configuration information such as the username, password, certificates, and keys are not stored in the instance metadata. The configuration information is used only to set up the replication connection and is stored by MySQL in a file named master.info in the data directory.
- ca_certificate
  Type: STRING
  Provider name: caCertificate
  Description: PEM representation of the trusted CA’s x509 certificate.
- client_certificate
  Type: STRING
  Provider name: clientCertificate
  Description: PEM representation of the replica’s x509 certificate.
- client_key
  Type: STRING
  Provider name: clientKey
  Description: PEM representation of the replica’s private key. The corresponsing public key is encoded in the client’s certificate.
- connect_retry_interval
  Type: INT32
  Provider name: connectRetryInterval
  Description: Seconds to wait between connect retries. MySQL’s default is 60 seconds.
- dump_file_path
  Type: STRING
  Provider name: dumpFilePath
  Description: Path to a SQL dump file in Google Cloud Storage from which the replica instance is to be created. The URI is in the form gs://bucketName/fileName. Compressed gzip files (.gz) are also supported. Dumps have the binlog co-ordinates from which replication begins. This can be accomplished by setting –master-data to 1 when using mysqldump.
- kind
  Type: STRING
  Provider name: kind
  Description: This is always sql#mysqlReplicaConfiguration.
- master_heartbeat_period
  Type: INT64
  Provider name: masterHeartbeatPeriod
  Description: Interval in milliseconds between replication heartbeats.
- ssl_cipher
  Type: STRING
  Provider name: sslCipher
  Description: A list of permissible ciphers to use for SSL encryption.
- username
  Type: STRING
  Provider name: username
  Description: The username for the replication connection.
- verify_server_certificate
  Type: BOOLEAN
  Provider name: verifyServerCertificate
  Description: Whether or not to check the primary instance’s Common Name value in the certificate that it sends during the SSL handshake.

`replica_names`

Type: UNORDERED_LIST_STRING
Provider name: replicaNames
Description: The replicas of the instance.

`resource_name`

Type: STRING

`satisfies_pzs`

Type: BOOLEAN
Provider name: satisfiesPzs
Description: The status indicating if instance satisfiesPzs. Reserved for future use.

`scheduled_maintenance`

Type: STRUCT
Provider name: scheduledMaintenance
Description: The start time of any upcoming scheduled maintenance for this instance.

can_defer
Type: BOOLEAN
Provider name: canDefer
can_reschedule
Type: BOOLEAN
Provider name: canReschedule
Description: If the scheduled maintenance can be rescheduled.
schedule_deadline_time
Type: TIMESTAMP
Provider name: scheduleDeadlineTime
Description: Maintenance cannot be rescheduled to start beyond this deadline.
start_time
Type: TIMESTAMP
Provider name: startTime
Description: The start time of any upcoming scheduled maintenance for this instance.

`secondary_gce_zone`

Type: STRING
Provider name: secondaryGceZone
Description: The Compute Engine zone that the failover instance is currently serving from for a regional instance. This value could be different from the zone that was specified when the instance was created if the instance has failed over to its secondary/failover zone.

`self_link`

Type: STRING
Provider name: selfLink
Description: The URI of this resource.

`server_ca_cert`

Type: STRUCT
Provider name: serverCaCert
Description: SSL configuration.

cert
Type: STRING
Provider name: cert
Description: PEM representation.
cert_serial_number
Type: STRING
Provider name: certSerialNumber
Description: Serial number, as extracted from the certificate.
common_name
Type: STRING
Provider name: commonName
Description: User supplied name. Constrained to [a-zA-Z.-_ ]+.
create_time
Type: TIMESTAMP
Provider name: createTime
Description: The time when the certificate was created in RFC 3339 format, for example 2012-11-15T16:19:00.094Z.
expiration_time
Type: TIMESTAMP
Provider name: expirationTime
Description: The time when the certificate expires in RFC 3339 format, for example 2012-11-15T16:19:00.094Z.
instance
Type: STRING
Provider name: instance
Description: Name of the database instance.
kind
Type: STRING
Provider name: kind
Description: This is always sql#sslCert.
self_link
Type: STRING
Provider name: selfLink
Description: The URI of this resource.
sha1_fingerprint
Type: STRING
Provider name: sha1Fingerprint
Description: Sha1 Fingerprint.

`service_account_email_address`

Type: STRING
Provider name: serviceAccountEmailAddress
Description: The service account email address assigned to the instance. \This property is read-only.

`settings`

Type: STRUCT
Provider name: settings
Description: The user settings.

activation_policy
Type: STRING
Provider name: activationPolicy
Description: The activation policy specifies when the instance is activated; it is applicable only when the instance state is RUNNABLE. Valid values: * ALWAYS: The instance is on, and remains so even in the absence of connection requests. * NEVER: The instance is off; it is not activated, even if a connection request arrives.
Possible values:
- SQL_ACTIVATION_POLICY_UNSPECIFIED - Unknown activation plan.
- ALWAYS - The instance is always up and running.
- NEVER - The instance never starts.
- ON_DEMAND - The instance starts upon receiving requests.
active_directory_config
Type: STRUCT
Provider name: activeDirectoryConfig
Description: Active Directory configuration, relevant only for Cloud SQL for SQL Server.
- domain
  Type: STRING
  Provider name: domain
  Description: The name of the domain (e.g., mydomain.com).
- kind
  Type: STRING
  Provider name: kind
  Description: This is always sql#activeDirectoryConfig.
advanced_machine_features
Type: STRUCT
Provider name: advancedMachineFeatures
Description: Specifies advance machine configuration for the instance relevant only for SQL Server.
- threads_per_core
  Type: INT32
  Provider name: threadsPerCore
  Description: The number of threads per physical core.
authorized_gae_applications
Type: UNORDERED_LIST_STRING
Provider name: authorizedGaeApplications
Description: The App Engine app IDs that can access this instance. (Deprecated) Applied to First Generation instances only.
availability_type
Type: STRING
Provider name: availabilityType
Description: Availability type. Potential values: * ZONAL: The instance serves data from only one zone. Outages in that zone affect data accessibility. * REGIONAL: The instance can serve data from more than one zone in a region (it is highly available)./ For more information, see Overview of the High Availability Configuration.
Possible values:
- SQL_AVAILABILITY_TYPE_UNSPECIFIED - This is an unknown Availability type.
- ZONAL - Zonal available instance.
- REGIONAL - Regional available instance.
backup_configuration
Type: STRUCT
Provider name: backupConfiguration
Description: The daily backup configuration for the instance.
- backup_retention_settings
  Type: STRUCT
  Provider name: backupRetentionSettings
  Description: Backup retention settings.
  - retained_backups
    Type: INT32
    Provider name: retainedBackups
    Description: Depending on the value of retention_unit, this is used to determine if a backup needs to be deleted. If retention_unit is ‘COUNT’, we will retain this many backups.
  - retention_unit
    Type: STRING
    Provider name: retentionUnit
    Description: The unit that ‘retained_backups’ represents.
    Possible values:
    - RETENTION_UNIT_UNSPECIFIED - Backup retention unit is unspecified, will be treated as COUNT.
    - COUNT - Retention will be by count, eg. ‘retain the most recent 7 backups’.
- binary_log_enabled
  Type: BOOLEAN
  Provider name: binaryLogEnabled
  Description: (MySQL only) Whether binary log is enabled. If backup configuration is disabled, binarylog must be disabled as well.
- enabled
  Type: BOOLEAN
  Provider name: enabled
  Description: Whether this configuration is enabled.
- kind
  Type: STRING
  Provider name: kind
  Description: This is always sql#backupConfiguration.
- location
  Type: STRING
  Provider name: location
  Description: Location of the backup
- point_in_time_recovery_enabled
  Type: BOOLEAN
  Provider name: pointInTimeRecoveryEnabled
  Description: Whether point in time recovery is enabled.
- replication_log_archiving_enabled
  Type: BOOLEAN
  Provider name: replicationLogArchivingEnabled
  Description: Reserved for future use.
- start_time
  Type: STRING
  Provider name: startTime
  Description: Start time for the daily backup configuration in UTC timezone in the 24 hour format - HH:MM.
- transaction_log_retention_days
  Type: INT32
  Provider name: transactionLogRetentionDays
  Description: The number of days of transaction logs we retain for point in time restore, from 1-7.
collation
Type: STRING
Provider name: collation
Description: The name of server Instance collation.
connector_enforcement
Type: STRING
Provider name: connectorEnforcement
Description: Specifies if connections must use Cloud SQL connectors. Option values include the following: NOT_REQUIRED (Cloud SQL instances can be connected without Cloud SQL Connectors) and REQUIRED (Only allow connections that use Cloud SQL Connectors) Note that using REQUIRED disables all existing authorized networks. If this field is not specified when creating a new instance, NOT_REQUIRED is used. If this field is not specified when patching or updating an existing instance, it is left unchanged in the instance.
Possible values:
- CONNECTOR_ENFORCEMENT_UNSPECIFIED - The requirement for Cloud SQL connectors is unknown.
- NOT_REQUIRED - Do not require Cloud SQL connectors.
- REQUIRED - Require all connections to use Cloud SQL connectors, including the Cloud SQL Auth Proxy and Cloud SQL Java, Python, and Go connectors. Note: This disables all existing authorized networks.
crash_safe_replication_enabled
Type: BOOLEAN
Provider name: crashSafeReplicationEnabled
Description: Configuration specific to read replica instances. Indicates whether database flags for crash-safe replication are enabled. This property was only applicable to First Generation instances.
data_cache_config
Type: STRUCT
Provider name: dataCacheConfig
Description: Configuration for data cache.
- data_cache_enabled
  Type: BOOLEAN
  Provider name: dataCacheEnabled
  Description: Whether data cache is enabled for the instance.
data_disk_size_gb
Type: INT64
Provider name: dataDiskSizeGb
Description: The size of data disk, in GB. The data disk size minimum is 10GB.
data_disk_type
Type: STRING
Provider name: dataDiskType
Description: The type of data disk: PD_SSD (default) or PD_HDD. Not used for First Generation instances.
Possible values:
- SQL_DATA_DISK_TYPE_UNSPECIFIED - This is an unknown data disk type.
- PD_SSD - An SSD data disk.
- PD_HDD - An HDD data disk.
- OBSOLETE_LOCAL_SSD - This field is deprecated and will be removed from a future version of the API.
database_flags
Type: UNORDERED_LIST_STRUCT
Provider name: databaseFlags
Description: The database flags passed to the instance at startup.
- name
  Type: STRING
  Provider name: name
  Description: The name of the flag. These flags are passed at instance startup, so include both server options and system variables. Flags are specified with underscores, not hyphens. For more information, see Configuring Database Flags in the Cloud SQL documentation.
- value
  Type: STRING
  Provider name: value
  Description: The value of the flag. Boolean flags are set to on for true and off for false. This field must be omitted if the flag doesn’t take a value.
database_replication_enabled
Type: BOOLEAN
Provider name: databaseReplicationEnabled
Description: Configuration specific to read replica instances. Indicates whether replication is enabled or not. WARNING: Changing this restarts the instance.
deletion_protection_enabled
Type: BOOLEAN
Provider name: deletionProtectionEnabled
Description: Configuration to protect against accidental instance deletion.
deny_maintenance_periods
Type: UNORDERED_LIST_STRUCT
Provider name: denyMaintenancePeriods
Description: Deny maintenance periods
- end_date
  Type: STRING
  Provider name: endDate
  Description: “deny maintenance period” end date. If the year of the end date is empty, the year of the start date also must be empty. In this case, it means the deny maintenance period recurs every year. The date is in format yyyy-mm-dd i.e., 2020-11-01, or mm-dd, i.e., 11-01
- start_date
  Type: STRING
  Provider name: startDate
  Description: “deny maintenance period” start date. If the year of the start date is empty, the year of the end date also must be empty. In this case, it means the deny maintenance period recurs every year. The date is in format yyyy-mm-dd i.e., 2020-11-01, or mm-dd, i.e., 11-01
- time
  Type: STRING
  Provider name: time
  Description: Time in UTC when the “deny maintenance period” starts on start_date and ends on end_date. The time is in format: HH:mm:SS, i.e., 00:00:00
edition
Type: STRING
Provider name: edition
Description: Optional. The edition of the instance.
Possible values:
- EDITION_UNSPECIFIED - The instance did not specify the edition.
- ENTERPRISE - The instance is an enterprise edition.
- ENTERPRISE_PLUS - The instance is an Enterprise Plus edition.
insights_config
Type: STRUCT
Provider name: insightsConfig
Description: Insights configuration, for now relevant only for Postgres.
- query_insights_enabled
  Type: BOOLEAN
  Provider name: queryInsightsEnabled
  Description: Whether Query Insights feature is enabled.
- query_plans_per_minute
  Type: INT32
  Provider name: queryPlansPerMinute
  Description: Number of query execution plans captured by Insights per minute for all queries combined. Default is 5.
- query_string_length
  Type: INT32
  Provider name: queryStringLength
  Description: Maximum query length stored in bytes. Default value: 1024 bytes. Range: 256-4500 bytes. Query length more than this field value will be truncated to this value. When unset, query length will be the default value. Changing query length will restart the database.
- record_application_tags
  Type: BOOLEAN
  Provider name: recordApplicationTags
  Description: Whether Query Insights will record application tags from query when enabled.
- record_client_address
  Type: BOOLEAN
  Provider name: recordClientAddress
  Description: Whether Query Insights will record client address when enabled.
ip_configuration
Type: STRUCT
Provider name: ipConfiguration
Description: The settings for IP Management. This allows to enable or disable the instance IP and manage which external networks can connect to the instance. The IPv4 address cannot be disabled for Second Generation instances.
- allocated_ip_range
  Type: STRING
  Provider name: allocatedIpRange
  Description: The name of the allocated ip range for the private ip Cloud SQL instance. For example: “google-managed-services-default”. If set, the instance ip will be created in the allocated range. The range name must comply with RFC 1035. Specifically, the name must be 1-63 characters long and match the regular expression [a-z]([-a-z0-9]*[a-z0-9])?.
- authorized_networks
  Type: UNORDERED_LIST_STRUCT
  Provider name: authorizedNetworks
  Description: The list of external networks that are allowed to connect to the instance using the IP. In ‘CIDR’ notation, also known as ‘slash’ notation (for example: 157.197.200.0/24).
  - expiration_time
    Type: TIMESTAMP
    Provider name: expirationTime
    Description: The time when this access control entry expires in RFC 3339 format, for example 2012-11-15T16:19:00.094Z.
  - kind
    Type: STRING
    Provider name: kind
    Description: This is always sql#aclEntry.
  - name
    Type: STRING
    Provider name: name
    Description: Optional. A label to identify this entry.
  - value
    Type: STRING
    Provider name: value
    Description: The allowlisted value for the access control list.
- enable_private_path_for_google_cloud_services
  Type: BOOLEAN
  Provider name: enablePrivatePathForGoogleCloudServices
  Description: Controls connectivity to private IP instances from Google services, such as BigQuery.
- ipv4_enabled
  Type: BOOLEAN
  Provider name: ipv4Enabled
  Description: Whether the instance is assigned a public IP address or not.
- private_network
  Type: STRING
  Provider name: privateNetwork
  Description: The resource link for the VPC network from which the Cloud SQL instance is accessible for private IP. For example, /projects/myProject/global/networks/default. This setting can be updated, but it cannot be removed after it is set.
- require_ssl
  Type: BOOLEAN
  Provider name: requireSsl
  Description: Whether SSL connections over IP are enforced or not.
kind
Type: STRING
Provider name: kind
Description: This is always sql#settings.
location_preference
Type: STRUCT
Provider name: locationPreference
Description: The location preference settings. This allows the instance to be located as near as possible to either an App Engine app or Compute Engine zone for better performance. App Engine co-location was only applicable to First Generation instances.
- follow_gae_application
  Type: STRING
  Provider name: followGaeApplication
  Description: The App Engine application to follow, it must be in the same region as the Cloud SQL instance. WARNING: Changing this might restart the instance.
- kind
  Type: STRING
  Provider name: kind
  Description: This is always sql#locationPreference.
- secondary_zone
  Type: STRING
  Provider name: secondaryZone
  Description: The preferred Compute Engine zone for the secondary/failover (for example: us-central1-a, us-central1-b, etc.).
- zone
  Type: STRING
  Provider name: zone
  Description: The preferred Compute Engine zone (for example: us-central1-a, us-central1-b, etc.). WARNING: Changing this might restart the instance.
maintenance_window
Type: STRUCT
Provider name: maintenanceWindow
Description: The maintenance window for this instance. This specifies when the instance can be restarted for maintenance purposes.
- day
  Type: INT32
  Provider name: day
  Description: day of week (1-7), starting on Monday.
- hour
  Type: INT32
  Provider name: hour
  Description: hour of day - 0 to 23.
- kind
  Type: STRING
  Provider name: kind
  Description: This is always sql#maintenanceWindow.
- update_track
  Type: STRING
  Provider name: updateTrack
  Description: Maintenance timing setting: canary (Earlier) or stable (Later). Learn more.
  Possible values:
  - SQL_UPDATE_TRACK_UNSPECIFIED - This is an unknown maintenance timing preference.
  - canary - For instance update that requires a restart, this update track indicates your instance prefer to restart for new version early in maintenance window.
  - stable - For instance update that requires a restart, this update track indicates your instance prefer to let Cloud SQL choose the timing of restart (within its Maintenance window, if applicable).
password_validation_policy
Type: STRUCT
Provider name: passwordValidationPolicy
Description: The local user password validation policy of the instance.
- complexity
  Type: STRING
  Provider name: complexity
  Description: The complexity of the password.
  Possible values:
  - COMPLEXITY_UNSPECIFIED - Complexity check is not specified.
  - COMPLEXITY_DEFAULT - A combination of lowercase, uppercase, numeric, and non-alphanumeric characters.
- disallow_username_substring
  Type: BOOLEAN
  Provider name: disallowUsernameSubstring
  Description: Disallow username as a part of the password.
- enable_password_policy
  Type: BOOLEAN
  Provider name: enablePasswordPolicy
  Description: Whether the password policy is enabled or not.
- min_length
  Type: INT32
  Provider name: minLength
  Description: Minimum number of characters allowed.
- password_change_interval
  Type: STRING
  Provider name: passwordChangeInterval
  Description: Minimum interval after which the password can be changed. This flag is only supported for PostgreSQL.
- reuse_interval
  Type: INT32
  Provider name: reuseInterval
  Description: Number of previous passwords that cannot be reused.
pricing_plan
Type: STRING
Provider name: pricingPlan
Description: The pricing plan for this instance. This can be either PER_USE or PACKAGE. Only PER_USE is supported for Second Generation instances.
Possible values:
- SQL_PRICING_PLAN_UNSPECIFIED - This is an unknown pricing plan for this instance.
- PACKAGE - The instance is billed at a monthly flat rate.
- PER_USE - The instance is billed per usage.
replication_type
Type: STRING
Provider name: replicationType
Description: The type of replication this instance uses. This can be either ASYNCHRONOUS or SYNCHRONOUS. (Deprecated) This property was only applicable to First Generation instances.
Possible values:
- SQL_REPLICATION_TYPE_UNSPECIFIED - This is an unknown replication type for a Cloud SQL instance.
- SYNCHRONOUS - The synchronous replication mode for First Generation instances. It is the default value.
- ASYNCHRONOUS - The asynchronous replication mode for First Generation instances. It provides a slight performance gain, but if an outage occurs while this option is set to asynchronous, you can lose up to a few seconds of updates to your data.
settings_version
Type: INT64
Provider name: settingsVersion
Description: The version of instance settings. This is a required field for update method to make sure concurrent updates are handled properly. During update, use the most recent settingsVersion value for this instance and do not try to update this value.
sql_server_audit_config
Type: STRUCT
Provider name: sqlServerAuditConfig
Description: SQL Server specific audit configuration.
- bucket
  Type: STRING
  Provider name: bucket
  Description: The name of the destination bucket (e.g., gs://mybucket).
- kind
  Type: STRING
  Provider name: kind
  Description: This is always sql#sqlServerAuditConfig
- retention_interval
  Type: STRING
  Provider name: retentionInterval
  Description: How long to keep generated audit files.
- upload_interval
  Type: STRING
  Provider name: uploadInterval
  Description: How often to upload generated audit files.
storage_auto_resize
Type: BOOLEAN
Provider name: storageAutoResize
Description: Configuration to increase storage size automatically. The default value is true.
storage_auto_resize_limit
Type: INT64
Provider name: storageAutoResizeLimit
Description: The maximum size to which storage capacity can be automatically increased. The default value is 0, which specifies that there is no limit.
tier
Type: STRING
Provider name: tier
Description: The tier (or machine type) for this instance, for example db-custom-1-3840. WARNING: Changing this restarts the instance.
time_zone
Type: STRING
Provider name: timeZone
Description: Server timezone, relevant only for Cloud SQL for SQL Server.
user_labels
Type: UNORDERED_LIST_STRING
Provider name: userLabels
Description: User-provided labels, represented as a dictionary where each label is a single key value pair.

`state`

Type: STRING
Provider name: state
Description: The current serving state of the Cloud SQL instance.
Possible values:

SQL_INSTANCE_STATE_UNSPECIFIED - The state of the instance is unknown.
RUNNABLE - The instance is running, or has been stopped by owner.
SUSPENDED - The instance is not available, for example due to problems with billing.
PENDING_DELETE - The instance is being deleted.
PENDING_CREATE - The instance is being created.
MAINTENANCE - The instance is down for maintenance.
FAILED - The creation of the instance failed or a fatal error occurred during maintenance.
ONLINE_MAINTENANCE - Deprecated

`suspension_reason`

Type: UNORDERED_LIST_STRING
Provider name: suspensionReason
Description: If the instance state is SUSPENDED, the reason for the suspension.

`tags`

Type: UNORDERED_LIST_STRING