Home Guides Reference Samples Support Policies Vendors

Column

Defines a Table column.

JSON representation 
{
  "columnId": string,
  "columnType": {
    object(FieldType)
  }
}
Fields
columnId

string

Column identifier.

columnType

object(FieldType)

Column type.

FieldType

Defines a BigQuery field type.

JSON representation 
{

  // Union field field_type can be only one of the following:
  "type": string,
  "arrayType": {
    object(FieldType)
  },
  "structType": {
    object(StructType)
  }
  // End of list of possible types for union field field_type.
}
Fields
Union field field_type. Field type. field_type can be only one of the following:
type

string

BigQuery simple type, e.g. 'STRING' or 'INT64'. See https://cloud.google.com/bigquery/docs/reference/standard-sql/data-types.

arrayType

object(FieldType)

Type of the array's elements, if this is an 'ARRAY' type.

structType

object(StructType)

Struct field type, if this is a 'STRUCT' type.

StructType

Defines a struct type.

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

object(StructField)

An ordered list of fields for a given struct.

StructField

A key-value pair that defines a single struct field.

JSON representation 
{
  "fieldName": string,
  "fieldType": {
    object(FieldType)
  }
}
Fields
fieldName

string

Field name.

fieldType

object(FieldType)

Field type.