SQLDatabase

Property	Value
Google Cloud Service Name	Cloud SQL
Google Cloud Service Documentation	/sql/docs/
Google Cloud REST Resource Name	v1beta4.database
Google Cloud REST Resource Documentation	/sql/docs/postgres/admin-api/v1beta4/databases
Config Connector Resource Short Names	gcpsqldatabase gcpsqldatabases sqldatabase
Config Connector Service Name	sqladmin.googleapis.com
Config Connector Resource Fully Qualified Name	sqldatabases.sql.cnrm.cloud.google.com
Can Be Referenced by IAMPolicy/IAMPolicyMember	No

Custom Resource Definition Properties

Annotations

Fields
cnrm.cloud.google.com/project-id

Spec

Schema

  charset: string
  collation: string
  instanceRef:
    external: string
    name: string
    namespace: string
  resourceID: string

Fields
charset Optional	string The charset value. See MySQL's [Supported Character Sets and Collations](https://dev.mysql.com/doc/refman/5.7/en/charset-charsets.html) and Postgres' [Character Set Support](https://www.postgresql.org/docs/9.6/static/multibyte.html) for more details and supported values. Postgres databases only support a value of 'UTF8' at creation time.
collation Optional	string The collation value. See MySQL's [Supported Character Sets and Collations](https://dev.mysql.com/doc/refman/5.7/en/charset-charsets.html) and Postgres' [Collation Support](https://www.postgresql.org/docs/9.6/static/collation.html) for more details and supported values. Postgres databases only support a value of 'en_US.UTF8' at creation time.
instanceRef Required	object The Cloud SQL instance.
instanceRef.external Optional	string The name of a SQLInstance.
instanceRef.name Optional	string Name of the referent. More info: https://kubernetes.io/docs/concepts/overview/working-with-objects/names/#names
instanceRef.namespace Optional	string Namespace of the referent. More info: https://kubernetes.io/docs/concepts/overview/working-with-objects/namespaces/
resourceID Optional	string Immutable. Optional. The name of the resource. Used for creation and acquisition. When unset, the value of `metadata.name` is used as the default.

Status

Schema

  conditions:
  - lastTransitionTime: string
    message: string
    reason: string
    status: string
    type: string
  selfLink: string

Fields
conditions	list (object) Conditions represent the latest available observation of the resource's current state.
conditions.[]	object
conditions.[].lastTransitionTime	string Last time the condition transitioned from one status to another.
conditions.[].message	string Human-readable message indicating details about last transition.
conditions.[].reason	string Unique, one-word, CamelCase reason for the condition's last transition.
conditions.[].status	string Status is the status of the condition. Can be True, False, Unknown.
conditions.[].type	string Type is the type of the condition.
selfLink	string

Sample YAML(s)

Typical Use Case

  # Copyright 2020 Google LLC
  #
  # Licensed under the Apache License, Version 2.0 (the "License");
  # you may not use this file except in compliance with the License.
  # You may obtain a copy of the License at
  #
  #     http://www.apache.org/licenses/LICENSE-2.0
  #
  # Unless required by applicable law or agreed to in writing, software
  # distributed under the License is distributed on an "AS IS" BASIS,
  # WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
  # See the License for the specific language governing permissions and
  # limitations under the License.
  
  apiVersion: sql.cnrm.cloud.google.com/v1beta1
  kind: SQLDatabase
  metadata:
    labels:
      label-one: "value-one"
    name: sqldatabase-sample
  spec:
    charset: utf8mb4
    collation: utf8mb4_bin
    instanceRef:
      name: sqldatabase-dep
  ---
  apiVersion: sql.cnrm.cloud.google.com/v1beta1
  kind: SQLInstance
  metadata:
    name: sqldatabase-dep
  spec:
    region: us-central1
    databaseVersion: MYSQL_5_7
    settings:
      tier: db-n1-standard-1