REST Resource: flags

Resource: Flag

A flag resource.

JSON representation
{"name":string,"type":enum (SqlFlagType),"appliesTo":[enum (SqlDatabaseVersion)],"allowedStringValues":[string],"minValue":string,"maxValue":string,"requiresRestart":boolean,"kind":string,"inBeta":boolean,"allowedIntValues":[string]}
Fields
name

string

This is the name of the flag. Flag names always use underscores, not hyphens, for example:max_allowed_packet

type

enum (SqlFlagType)

The type of the flag. Flags are typed to beingBOOLEAN,STRING,INTEGER orNONE.NONE is used for flags which do not take a value, such asskip_grant_tables.

appliesTo[]

enum (SqlDatabaseVersion)

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, orMYSQL_5_6. PostgreSQL instances:POSTGRES_9_6,POSTGRES_10,POSTGRES_11 orPOSTGRES_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, orSQLSERVER_2019_WEB. Seethe complete list.

allowedStringValues[]

string

ForSTRING flags, a list of strings that the value can be set to.

minValue

string (Int64Value format)

ForINTEGER flags, the minimum allowed value.

maxValue

string (Int64Value format)

ForINTEGER flags, the maximum allowed value.

requiresRestart

boolean

Indicates whether changing this flag will trigger a database restart. Only applicable to Second Generation instances.

kind

string

This is alwayssql#flag.

inBeta

boolean

Whether or not the flag is considered in beta.

allowedIntValues[]

string (int64 format)

Use this field if only certain integers are accepted. Can be combined with minValue and maxValue to add additional values.

SqlFlagType

Enums
SQL_FLAG_TYPE_UNSPECIFIEDThis is an unknown flag type.
BOOLEANBoolean type flag.
STRINGString type flag.
INTEGERInteger type flag.
NONEFlag type used for a server startup option.
MYSQL_TIMEZONE_OFFSETType introduced specially for MySQL TimeZone offset. Accept a string value with the format [-12:59, 13:00].
FLOATFloat type flag.
REPEATED_STRINGComma-separated list of the strings in a SqlFlagType enum.

Methods

list

 Lists all available database flags for Cloud SQL instances.

Except as otherwise noted, the content of this page is licensed under theCreative Commons Attribution 4.0 License, and code samples are licensed under theApache 2.0 License. For details, see theGoogle Developers Site Policies. Java is a registered trademark of Oracle and/or its affiliates.

Last updated 2025-05-30 UTC.