flags

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

Overview

Name	flags
Type	Resource
Id	google.sqladmin.flags

Fields

Name	Datatype	Description
name	string	This is the name of the flag. Flag names always use underscores, not hyphens, for example: max_allowed_packet
allowedIntValues	array	Use this field if only certain integers are accepted. Can be combined with min_value and max_value to add additional values.
allowedStringValues	array	For STRING flags, a list of strings that the value can be set to.
appliesTo	array	The database version this flag applies to. Can be MySQL instances: MYSQL_8_0, MYSQL_8_0_18, MYSQL_8_0_26, MYSQL_5_7, or MYSQL_5_6. PostgreSQL instances: POSTGRES_9_6, POSTGRES_10, POSTGRES_11 or POSTGRES_12. SQL Server instances: SQLSERVER_2017_STANDARD, SQLSERVER_2017_ENTERPRISE, SQLSERVER_2017_EXPRESS, SQLSERVER_2017_WEB, SQLSERVER_2019_STANDARD, SQLSERVER_2019_ENTERPRISE, SQLSERVER_2019_EXPRESS, or SQLSERVER_2019_WEB. See the complete list.
inBeta	boolean	Whether or not the flag is considered in beta.
kind	string	This is always sql#flag.
maxValue	string	For INTEGER flags, the maximum allowed value.
minValue	string	For INTEGER flags, the minimum allowed value.
requiresRestart	boolean	Indicates whether changing this flag will trigger a database restart. Only applicable to Second Generation instances.
type	string	The type of the flag. Flags are typed to being BOOLEAN, STRING, INTEGER or NONE. NONE is used for flags that do not take a value, such as skip_grant_tables.

Methods

Name	Accessible by	Required Params	Description
list	SELECT		Lists all available database flags for Cloud SQL instances.

SELECT examples

Lists all available database flags for Cloud SQL instances.

SELECT
name,
allowedIntValues,
allowedStringValues,
appliesTo,
inBeta,
kind,
maxValue,
minValue,
requiresRestart,
type
FROM google.sqladmin.flags
;