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

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.

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