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:

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
;