Skip to main content

instances_server_cas

Creates, updates, deletes, gets or lists an instances_server_cas resource.

Overview

Nameinstances_server_cas
TypeResource
Idgoogle.sqladmin.instances_server_cas

Fields

The following fields are returned by SELECT queries:

Successful response

NameDatatypeDescription
activeVersionstring
certsarrayList of server CA certificates for the instance.
kindstringThis is always sql#instancesListServerCas.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
list_server_casselectproject, instanceLists all of the trusted Certificate Authorities (CAs) for the specified instance. There can be up to three CAs listed: the CA that was used to sign the certificate that is currently in use, a CA that has been added but not yet used to sign a certificate, and a CA used to sign a certificate that has previously rotated out.

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

NameDatatypeDescription
instancestring
projectstring

SELECT examples

Lists all of the trusted Certificate Authorities (CAs) for the specified instance. There can be up to three CAs listed: the CA that was used to sign the certificate that is currently in use, a CA that has been added but not yet used to sign a certificate, and a CA used to sign a certificate that has previously rotated out.

SELECT
activeVersion,
certs,
kind
FROM google.sqladmin.instances_server_cas
WHERE project = '{{ project }}' -- required
AND instance = '{{ instance }}' -- required;