Class: Google::Apis::BigqueryV2::TableFieldSchema

Inherits:
Object
  • Object
show all
Includes:
Core::Hashable, Core::JsonObjectSupport
Defined in:
lib/google/apis/bigquery_v2/classes.rb,
lib/google/apis/bigquery_v2/representations.rb,
lib/google/apis/bigquery_v2/representations.rb

Defined Under Namespace

Classes: Categories, PolicyTags

Instance Attribute Summary collapse

Instance Method Summary collapse

Constructor Details

#initialize(**args) ⇒ TableFieldSchema

Returns a new instance of TableFieldSchema.



7879
7880
7881
# File 'lib/google/apis/bigquery_v2/classes.rb', line 7879

def initialize(**args)
   update!(**args)
end

Instance Attribute Details

#categoriesGoogle::Apis::BigqueryV2::TableFieldSchema::Categories

[Optional] The categories attached to this field, used for field-level access control. Corresponds to the JSON property categories



7786
7787
7788
# File 'lib/google/apis/bigquery_v2/classes.rb', line 7786

def categories
  @categories
end

#collationString

Optional. Collation specification of the field. It only can be set on string type field. Corresponds to the JSON property collation

Returns:

  • (String)


7792
7793
7794
# File 'lib/google/apis/bigquery_v2/classes.rb', line 7792

def collation
  @collation
end

#default_value_expressionString

Optional. A SQL expression to specify the default value for this field. It can only be set for top level fields (columns). You can use struct or array expression to specify default value for the entire struct or array. The valid SQL expressions are: - Literals for all data types, including STRUCT and ARRAY.

  • Following functions: - CURRENT_TIMESTAMP - CURRENT_TIME - CURRENT_DATE - CURRENT_DATETIME - GENERATE_UUID - RAND - SESSION_USER - ST_GEOGPOINT - Struct or array composed with the above allowed functions, for example, [CURRENT_DATE( ), DATE '2020-01-01'] Corresponds to the JSON property defaultValueExpression

Returns:

  • (String)


7804
7805
7806
# File 'lib/google/apis/bigquery_v2/classes.rb', line 7804

def default_value_expression
  @default_value_expression
end

#descriptionString

[Optional] The field description. The maximum length is 1,024 characters. Corresponds to the JSON property description

Returns:

  • (String)


7809
7810
7811
# File 'lib/google/apis/bigquery_v2/classes.rb', line 7809

def description
  @description
end

#fieldsArray<Google::Apis::BigqueryV2::TableFieldSchema>

[Optional] Describes the nested schema fields if the type property is set to RECORD. Corresponds to the JSON property fields



7815
7816
7817
# File 'lib/google/apis/bigquery_v2/classes.rb', line 7815

def fields
  @fields
end

#max_lengthFixnum

[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 ≠ "STRING" and ≠ "BYTES". Corresponds to the JSON property maxLength

Returns:

  • (Fixnum)


7825
7826
7827
# File 'lib/google/apis/bigquery_v2/classes.rb', line 7825

def max_length
  @max_length
end

#modeString

[Optional] The field mode. Possible values include NULLABLE, REQUIRED and REPEATED. The default value is NULLABLE. Corresponds to the JSON property mode

Returns:

  • (String)


7831
7832
7833
# File 'lib/google/apis/bigquery_v2/classes.rb', line 7831

def mode
  @mode
end

#nameString

[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 300 characters. Corresponds to the JSON property name

Returns:

  • (String)


7838
7839
7840
# File 'lib/google/apis/bigquery_v2/classes.rb', line 7838

def name
  @name
end

#policy_tagsGoogle::Apis::BigqueryV2::TableFieldSchema::PolicyTags

Corresponds to the JSON property policyTags



7843
7844
7845
# File 'lib/google/apis/bigquery_v2/classes.rb', line 7843

def policy_tags
  @policy_tags
end

#precisionFixnum

[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 ≠ "NUMERIC" and ≠ "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: [-10P- S + 10-S, 10P-S - 10-S] - Precision (P) is specified but not scale (and thus scale is interpreted to be equal to zero): [-10P + 1, 10P - 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. Corresponds to the JSON property precision

Returns:

  • (Fixnum)


7863
7864
7865
# File 'lib/google/apis/bigquery_v2/classes.rb', line 7863

def precision
  @precision
end

#scaleFixnum

[Optional] See documentation for precision. Corresponds to the JSON property scale

Returns:

  • (Fixnum)


7868
7869
7870
# File 'lib/google/apis/bigquery_v2/classes.rb', line 7868

def scale
  @scale
end

#typeString

[Required] The field data type. Possible values include STRING, BYTES, INTEGER, INT64 (same as INTEGER), FLOAT, FLOAT64 (same as FLOAT), NUMERIC, BIGNUMERIC, BOOLEAN, BOOL (same as BOOLEAN), TIMESTAMP, DATE, TIME, DATETIME, INTERVAL, RECORD (where RECORD indicates that the field contains a nested schema) or STRUCT (same as RECORD). Corresponds to the JSON property type

Returns:

  • (String)


7877
7878
7879
# File 'lib/google/apis/bigquery_v2/classes.rb', line 7877

def type
  @type
end

Instance Method Details

#update!(**args) ⇒ Object

Update properties of this object



7884
7885
7886
7887
7888
7889
7890
7891
7892
7893
7894
7895
7896
7897
# File 'lib/google/apis/bigquery_v2/classes.rb', line 7884

def update!(**args)
  @categories = args[:categories] if args.key?(:categories)
  @collation = args[:collation] if args.key?(:collation)
  @default_value_expression = args[:default_value_expression] if args.key?(:default_value_expression)
  @description = args[:description] if args.key?(:description)
  @fields = args[:fields] if args.key?(:fields)
  @max_length = args[:max_length] if args.key?(:max_length)
  @mode = args[:mode] if args.key?(:mode)
  @name = args[:name] if args.key?(:name)
  @policy_tags = args[:policy_tags] if args.key?(:policy_tags)
  @precision = args[:precision] if args.key?(:precision)
  @scale = args[:scale] if args.key?(:scale)
  @type = args[:type] if args.key?(:type)
end