database_properties

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

Overview

Name	database_properties
Type	Resource
Id	google.composer.database_properties

Fields

The following fields are returned by SELECT queries:

fetch_database_properties

Successful response

Name	Datatype	Description
isFailoverReplicaAvailable	boolean	The 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.
primaryGceZone	string	The Compute Engine zone that the instance is currently serving from.
secondaryGceZone	string	The Compute Engine zone that the failover instance is currently serving from for a regional Cloud SQL instance.

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
fetch_database_properties	select	projectsId, locationsId, environmentsId		Fetches database properties.

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.

Name	Datatype	Description
environmentsId	string
locationsId	string
projectsId	string

SELECT examples

fetch_database_properties

Fetches database properties.

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