Skip to main content

environments_database_properties

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

Overview

Nameenvironments_database_properties
TypeResource
Idgoogle.composer.environments_database_properties

Fields

NameDatatypeDescription
isFailoverReplicaAvailablebooleanThe availability status of the failover replica. A false status indicates that the failover replica is out of sync. The primary instance can only fail over to the failover replica when the status is true.
primaryGceZonestringThe Compute Engine zone that the instance is currently serving from.
secondaryGceZonestringThe Compute Engine zone that the failover instance is currently serving from for a regional Cloud SQL instance.

Methods

NameAccessible byRequired ParamsDescription
fetch_database_propertiesSELECTenvironmentsId, locationsId, projectsIdFetches database properties.

SELECT examples

Fetches database properties.

SELECT
isFailoverReplicaAvailable,
primaryGceZone,
secondaryGceZone
FROM google.composer.environments_database_properties
WHERE environmentsId = '{{ environmentsId }}'
AND locationsId = '{{ locationsId }}'
AND projectsId = '{{ projectsId }}';