supported_database_flags

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

Overview

Name	supported_database_flags
Type	Resource
Id	google.alloydb.supported_database_flags

Fields

The following fields are returned by SELECT queries:

list

Name	Datatype	Description
name	string	The name of the flag resource, following Google Cloud conventions, e.g.: * projects/{project}/locations/{location}/flags/{flag} This field currently has no semantic meaning.
acceptsMultipleValues	boolean	Whether the database flag accepts multiple values. If true, a comma-separated list of stringified values may be specified.
flagName	string	The name of the database flag, e.g. "max_allowed_packets". The is a possibly key for the Instance.database_flags map field.
integerRestrictions	object	Restriction on INTEGER type value. (id: IntegerRestrictions)
recommendedIntegerValue	string (int64)	The recommended value for an INTEGER flag.
recommendedStringValue	string	The recommended value for a STRING flag.
requiresDbRestart	boolean	Whether setting or updating this flag on an Instance requires a database restart. If a flag that requires database restart is set, the backend will automatically restart the database (making sure to satisfy any availability SLO's).
scope	string	The scope of the flag. (SCOPE_UNSPECIFIED, DATABASE, CONNECTION_POOL)
stringRestrictions	object	Restriction on STRING type value. (id: StringRestrictions)
supportedDbVersions	array	Major database engine versions for which this flag is supported.
valueType	string	(VALUE_TYPE_UNSPECIFIED, STRING, INTEGER, FLOAT, NONE)

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
list	select	projectsId, locationsId	scope, pageToken, pageSize	Lists SupportedDatabaseFlags for a given project and location.

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
locationsId	string
projectsId	string
pageSize	integer (int32)
pageToken	string
scope	string

SELECT examples

list

Lists SupportedDatabaseFlags for a given project and location.

SELECT
name,
acceptsMultipleValues,
flagName,
integerRestrictions,
recommendedIntegerValue,
recommendedStringValue,
requiresDbRestart,
scope,
stringRestrictions,
supportedDbVersions,
valueType
FROM google.alloydb.supported_database_flags
WHERE projectsId = '{{ projectsId }}' -- required
AND locationsId = '{{ locationsId }}' -- required
AND scope = '{{ scope }}'
AND pageToken = '{{ pageToken }}'
AND pageSize = '{{ pageSize }}'
;