TableFieldSchema(mapping=None, *, ignore_unknown_fields=False, **kwargs)TableFieldSchema defines a single field/column within a table schema.
Attributes |
|
|---|---|
| Name | Description |
name |
str
Required. The field name. The name must contain only letters (a-z, A-Z), numbers (0-9), or underscores (_), and must start with a letter or underscore. The maximum length is 128 characters. |
type_ |
google.cloud.bigquery_storage_v1.types.TableFieldSchema.Type
Required. The field data type. |
mode |
google.cloud.bigquery_storage_v1.types.TableFieldSchema.Mode
Optional. The field mode. The default value is NULLABLE. |
fields |
MutableSequence[google.cloud.bigquery_storage_v1.types.TableFieldSchema]
Optional. Describes the nested schema fields if the type property is set to STRUCT. |
description |
str
Optional. The field description. The maximum length is 1,024 characters. |
max_length |
int
Optional. Maximum length of values of this field for STRINGS or BYTES. If max_length is not specified, no maximum length constraint is imposed on this field. If type = "STRING", then max_length represents the maximum UTF-8 length of strings in this field. If type = "BYTES", then max_length represents the maximum number of bytes in this field. It is invalid to set this field if type is not "STRING" or "BYTES". |
precision |
int
Optional. Precision (maximum number of total digits in base 10) and scale (maximum number of digits in the fractional part in base 10) constraints for values of this field for NUMERIC or BIGNUMERIC. It is invalid to set precision or scale if type is not "NUMERIC" or "BIGNUMERIC". If precision and scale are not specified, no value range constraint is imposed on this field insofar as values are permitted by the type. Values of this NUMERIC or BIGNUMERIC field must be in this range when: - Precision (P) and scale (S) are specified: [-10^(P-S) + 10^(-S), 10^(P-S) - 10^(-S)] - Precision (P) is specified but not scale (and thus scale is interpreted to be equal to zero): [-10^P + 1, 10^P - 1]. Acceptable values for precision and scale if both are specified: - If type = "NUMERIC": 1 <= precision="" -="" scale=""><= 29="" and="" 0=""><= scale=""><= 9.="" -="" if="" type="BIGNUMERIC" :="" 1=""><= precision="" -="" scale=""><= 38="" and="" 0=""><= scale=""><= 38.="" acceptable="" values="" for="" precision="" if="" only="" precision="" is="" specified="" but="" not="" scale="" (and="" thus="" scale="" is="" interpreted="" to="" be="" equal="" to="" zero):="" -="" if="" type="NUMERIC" :="" 1=""><= precision=""><= 29.="" -="" if="" type="BIGNUMERIC" :="" 1=""><= precision=""><= 38.="" if="" scale="" is="" specified="" but="" not="" precision,="" then="" it="" is="" invalid.=""> |
scale |
int
Optional. See documentation for precision. |
default_value_expression |
str
Optional. A SQL expression to specify the [default value] (https://cloud.google.com/bigquery/docs/default-values) for this field. |
range_element_type |
google.cloud.bigquery_storage_v1.types.TableFieldSchema.FieldElementType
Optional. The subtype of the RANGE, if the type of this field is RANGE. If the type is RANGE, this field is required. Possible values for the field element type of a RANGE include: - DATE - DATETIME - TIMESTAMP |
Classes
FieldElementType
FieldElementType(mapping=None, *, ignore_unknown_fields=False, **kwargs)Represents the type of a field element.
Mode
Mode(value)Enum values:
MODE_UNSPECIFIED (0):
Illegal value
NULLABLE (1):
No description available.
REQUIRED (2):
No description available.
REPEATED (3):
No description available.
Type
Type(value)Enum values:
TYPE_UNSPECIFIED (0):
Illegal value
STRING (1):
64K, UTF8
INT64 (2):
64-bit signed
DOUBLE (3):
64-bit IEEE floating point
STRUCT (4):
Aggregate type
BYTES (5):
64K, Binary
BOOL (6):
2-valued
TIMESTAMP (7):
64-bit signed usec since UTC epoch
DATE (8):
Civil date - Year, Month, Day
TIME (9):
Civil time - Hour, Minute, Second,
Microseconds
DATETIME (10):
Combination of civil date and civil time
GEOGRAPHY (11):
Geography object
NUMERIC (12):
Numeric value
BIGNUMERIC (13):
BigNumeric value
INTERVAL (14):
Interval
JSON (15):
JSON, String
RANGE (16):
RANGE