StandardSqlDataType

The data type of a variable such as a function argument. Examples include:

  • INT64: {"typeKind": "INT64"}

  • ARRAY:

{
  "typeKind": "ARRAY",
  "arrayElementType": {"typeKind": "STRING"}
}
  • STRUCT<x STRING, y ARRAY>:
{
  "typeKind": "STRUCT",
  "structType":
  {
    "fields":
    [
      {
        "name": "x",
        "type": {"typeKind": "STRING"}
      },
      {
        "name": "y",
        "type":
        {
          "typeKind": "ARRAY",
          "arrayElementType": {"typeKind": "DATE"}
        }
      }
    ]
  }
}
  • RANGE:
{
  "typeKind": "RANGE",
  "rangeElementType": {"typeKind": "DATE"}
}
JSON representation 
{
  "typeKind": enum (TypeKind),

  // The following is a list of mutually exclusive fields. At most one of the
  // fields will be set in a response:
  "arrayElementType": {
    object (StandardSqlDataType)
  },
  "structType": {
    object (StandardSqlStructType)
  },
  "rangeElementType": {
    object (StandardSqlDataType)
  }
  // End of mutually exclusive fields.
}
Fields
typeKind

enum (TypeKind)

Required. The top level type of this field. Can be any GoogleSQL data type (e.g., "INT64", "DATE", "ARRAY").
For complex types, the sub type information. The following is a list of mutually exclusive fields. At most one of the fields will be set in a response:
arrayElementType

object (StandardSqlDataType)

The type of the array's elements, if typeKind = "ARRAY".
structType

object (StandardSqlStructType)

The fields of this struct, in order, if typeKind = "STRUCT".
rangeElementType

object (StandardSqlDataType)

The type of the range's elements, if typeKind = "RANGE".
End of mutually exclusive fields.

TypeKind

The kind of the datatype.

Enums
TYPE_KIND_UNSPECIFIED Invalid type.
INT64 Encoded as a string in decimal format.
BOOL Encoded as a boolean "false" or "true".
FLOAT64 Encoded as a number, or string "NaN", "Infinity" or "-Infinity".
STRING Encoded as a string value.
BYTES Encoded as a base64 string per RFC 4648, section 4.
TIMESTAMP Encoded as an RFC 3339 timestamp with mandatory "Z" time zone string: 1985-04-12T23:20:50.52Z
DATE Encoded as RFC 3339 full-date format string: 1985-04-12
TIME Encoded as RFC 3339 partial-time format string: 23:20:50.52
DATETIME Encoded as RFC 3339 full-date "T" partial-time: 1985-04-12T23:20:50.52
GEOGRAPHY Encoded as WKT
NUMERIC Encoded as a decimal string.
BIGNUMERIC Encoded as a decimal string.
JSON Encoded as a string.
ARRAY Encoded as a list with types matching Type.array_type.
STRUCT Encoded as a list with fields of type Type.struct_type[i]. tabledata.list is used because a JSON object cannot have duplicate field names.
RANGE Encoded as a pair with types matching rangeElementType. Pairs must begin with "[", end with ")", and be separated by ", ".

StandardSqlStructType

The representation of a SQL STRUCT type.

JSON representation 
{
  "fields": [
    {
      object (StandardSqlField)
    }
  ]
}
Fields
fields[]

object (StandardSqlField)

Fields within the struct.