instance_configs

Creates, updates, deletes, gets or lists a instance_configs resource.

Overview

Name	instance_configs
Type	Resource
Id	google.spanner.instance_configs

Fields

Name	Datatype	Description
name	string	A unique identifier for the instance configuration. Values are of the form projects//instanceConfigs/a-z*. User instance configuration must start with custom-.
baseConfig	string	Base configuration name, e.g. projects//instanceConfigs/nam3, based on which this configuration is created. Only set for user-managed configurations. base_config must refer to a configuration of type GOOGLE_MANAGED in the same project as this configuration.
configType	string	Output only. Whether this instance configuration is a Google-managed or user-managed configuration.
displayName	string	The name of this instance configuration as it appears in UIs.
etag	string	etag is used for optimistic concurrency control as a way to help prevent simultaneous updates of a instance configuration from overwriting each other. It is strongly suggested that systems make use of the etag in the read-modify-write cycle to perform instance configuration updates in order to avoid race conditions: An etag is returned in the response which contains instance configurations, and systems are expected to put that etag in the request to update instance configuration to ensure that their change is applied to the same version of the instance configuration. If no etag is provided in the call to update the instance configuration, then the existing instance configuration is overwritten blindly.
freeInstanceAvailability	string	Output only. Describes whether free instances are available to be created in this instance configuration.
labels	object	Cloud Labels are a flexible and lightweight mechanism for organizing cloud resources into groups that reflect a customer's organizational needs and deployment strategies. Cloud Labels can be used to filter collections of resources. They can be used to control how resource metrics are aggregated. And they can be used as arguments to policy management rules (e.g. route, firewall, load balancing, etc.). Label keys must be between 1 and 63 characters long and must conform to the following regular expression: a-z{0,62}. Label values must be between 0 and 63 characters long and must conform to the regular expression [a-z0-9_-]{0,63}. * No more than 64 labels can be associated with a given resource. See https://goo.gl/xmQnxf for more information on and examples of labels. If you plan to use labels in your own code, please note that additional characters may be allowed in the future. Therefore, you are advised to use an internal label representation, such as JSON, which doesn't rely upon specific characters being disallowed. For example, representing labels as the string: name + "" + value would prove problematic if we were to allow "" in a future release.
leaderOptions	array	Allowed values of the "default_leader" schema option for databases in instances that use this instance configuration.
optionalReplicas	array	Output only. The available optional replicas to choose from for user-managed configurations. Populated for Google-managed configurations.
quorumType	string	Output only. The QuorumType of the instance configuration.
reconciling	boolean	Output only. If true, the instance configuration is being created or updated. If false, there are no ongoing operations for the instance configuration.
replicas	array	The geographic placement of nodes in this instance configuration and their replication properties. To create user-managed configurations, input replicas must include all replicas in replicas of the base_config and include one or more replicas in the optional_replicas of the base_config.
state	string	Output only. The current instance configuration state. Applicable only for USER_MANAGED configurations.
storageLimitPerProcessingUnit	string	Output only. The storage limit in bytes per processing unit.

Methods

Name	Accessible by	Required Params	Description
projects_instance_configs_get	SELECT	instanceConfigsId, projectsId	Gets information about a particular instance configuration.
projects_instance_configs_list	SELECT	projectsId	Lists the supported instance configurations for a given project. Returns both Google-managed configurations and user-managed configurations.
projects_instance_configs_create	INSERT	projectsId	Creates an instance configuration and begins preparing it to be used. The returned long-running operation can be used to track the progress of preparing the new instance configuration. The instance configuration name is assigned by the caller. If the named instance configuration already exists, CreateInstanceConfig returns ALREADY_EXISTS. Immediately after the request returns: The instance configuration is readable via the API, with all requested attributes. The instance configuration's reconciling field is set to true. Its state is CREATING. While the operation is pending: Cancelling the operation renders the instance configuration immediately unreadable via the API. Except for deleting the creating resource, all other attempts to modify the instance configuration are rejected. Upon completion of the returned operation: Instances can be created using the instance configuration. * The instance configuration's reconciling field becomes false. Its state becomes READY. The returned long-running operation will have a name of the format /operations/ and can be used to track creation of the instance configuration. The metadata field type is CreateInstanceConfigMetadata. The response field type is InstanceConfig, if successful. Authorization requires spanner.instanceConfigs.create permission on the resource parent.
projects_instance_configs_delete	DELETE	instanceConfigsId, projectsId	Deletes the instance configuration. Deletion is only allowed when no instances are using the configuration. If any instances are using the configuration, returns FAILED_PRECONDITION. Only user-managed configurations can be deleted. Authorization requires spanner.instanceConfigs.delete permission on the resource name.
projects_instance_configs_patch	UPDATE	instanceConfigsId, projectsId	Updates an instance configuration. The returned long-running operation can be used to track the progress of updating the instance. If the named instance configuration does not exist, returns NOT_FOUND. Only user-managed configurations can be updated. Immediately after the request returns: The instance configuration's reconciling field is set to true. While the operation is pending: Cancelling the operation sets its metadata's cancel_time. The operation is guaranteed to succeed at undoing all changes, after which point it terminates with a CANCELLED status. All other attempts to modify the instance configuration are rejected. Reading the instance configuration via the API continues to give the pre-request values. Upon completion of the returned operation: Creating instances using the instance configuration uses the new values. The new values of the instance configuration are readable via the API. * The instance configuration's reconciling field becomes false. The returned long-running operation will have a name of the format /operations/ and can be used to track the instance configuration modification. The metadata field type is UpdateInstanceConfigMetadata. The response field type is InstanceConfig, if successful. Authorization requires spanner.instanceConfigs.update permission on the resource name.

SELECT examples

Lists the supported instance configurations for a given project. Returns both Google-managed configurations and user-managed configurations.

SELECT
name,
baseConfig,
configType,
displayName,
etag,
freeInstanceAvailability,
labels,
leaderOptions,
optionalReplicas,
quorumType,
reconciling,
replicas,
state,
storageLimitPerProcessingUnit
FROM google.spanner.instance_configs
WHERE projectsId = '{{ projectsId }}';

INSERT example

Use the following StackQL query and manifest file to create a new instance_configs resource.

All Properties

/*+ create */
INSERT INTO google.spanner.instance_configs (
projectsId,
instanceConfigId,
instanceConfig,
validateOnly
)
SELECT 
'{{ projectsId }}',
'{{ instanceConfigId }}',
'{{ instanceConfig }}',
{{ validateOnly }}
;

Manifest

- name: your_resource_model_name
  props:
    - name: instanceConfigId
      value: string
    - name: instanceConfig
      value:
        - name: name
          value: string
        - name: displayName
          value: string
        - name: configType
          value: string
        - name: replicas
          value:
            - - name: location
                value: string
              - name: type
                value: string
              - name: defaultLeaderLocation
                value: boolean
        - name: optionalReplicas
          value:
            - - name: location
                value: string
              - name: type
                value: string
              - name: defaultLeaderLocation
                value: boolean
        - name: baseConfig
          value: string
        - name: labels
          value: object
        - name: etag
          value: string
        - name: leaderOptions
          value:
            - string
        - name: reconciling
          value: boolean
        - name: state
          value: string
        - name: freeInstanceAvailability
          value: string
        - name: quorumType
          value: string
        - name: storageLimitPerProcessingUnit
          value: string
    - name: validateOnly
      value: boolean

UPDATE example

Updates a instance_configs resource.

/*+ update */
UPDATE google.spanner.instance_configs
SET 
instanceConfig = '{{ instanceConfig }}',
updateMask = '{{ updateMask }}',
validateOnly = true|false
WHERE 
instanceConfigsId = '{{ instanceConfigsId }}'
AND projectsId = '{{ projectsId }}';

DELETE example

Deletes the specified instance_configs resource.

/*+ delete */
DELETE FROM google.spanner.instance_configs
WHERE instanceConfigsId = '{{ instanceConfigsId }}'
AND projectsId = '{{ projectsId }}';