Skip to main content

ca_pools

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

Overview

Nameca_pools
TypeResource
Idgoogle.privateca.ca_pools

Fields

NameDatatypeDescription
namestringOutput only. The resource name for this CaPool in the format projects/*/locations/*/caPools/*.
issuancePolicyobjectDefines controls over all certificate issuance within a CaPool.
labelsobjectOptional. Labels with user-defined metadata.
publishingOptionsobjectOptions relating to the publication of each CertificateAuthority's CA certificate and CRLs and their inclusion as extensions in issued Certificates. The options set here apply to certificates issued by any CertificateAuthority in the CaPool.
tierstringRequired. Immutable. The Tier of this CaPool.

Methods

NameAccessible byRequired ParamsDescription
getSELECTcaPoolsId, locationsId, projectsIdReturns a CaPool.
listSELECTlocationsId, projectsIdLists CaPools.
createINSERTlocationsId, projectsIdCreate a CaPool.
deleteDELETEcaPoolsId, locationsId, projectsIdDelete a CaPool.
patchUPDATEcaPoolsId, locationsId, projectsIdUpdate a CaPool.

SELECT examples

Lists CaPools.

SELECT
name,
issuancePolicy,
labels,
publishingOptions,
tier
FROM google.privateca.ca_pools
WHERE locationsId = '{{ locationsId }}'
AND projectsId = '{{ projectsId }}';

INSERT example

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

/*+ create */
INSERT INTO google.privateca.ca_pools (
locationsId,
projectsId,
tier,
issuancePolicy,
publishingOptions,
labels
)
SELECT
'{{ locationsId }}',
'{{ projectsId }}',
'{{ tier }}',
'{{ issuancePolicy }}',
'{{ publishingOptions }}',
'{{ labels }}'
;

UPDATE example

Updates a ca_pools resource.

/*+ update */
UPDATE google.privateca.ca_pools
SET
tier = '{{ tier }}',
issuancePolicy = '{{ issuancePolicy }}',
publishingOptions = '{{ publishingOptions }}',
labels = '{{ labels }}'
WHERE
caPoolsId = '{{ caPoolsId }}'
AND locationsId = '{{ locationsId }}'
AND projectsId = '{{ projectsId }}';

DELETE example

Deletes the specified ca_pools resource.

/*+ delete */
DELETE FROM google.privateca.ca_pools
WHERE caPoolsId = '{{ caPoolsId }}'
AND locationsId = '{{ locationsId }}'
AND projectsId = '{{ projectsId }}';