BigQuery Storage V1 API - Class Google::Cloud::Bigquery::Storage::V1::ReadSession::TableReadOptions (v0.12.0)

Reference documentation and code samples for the BigQuery Storage V1 API class Google::Cloud::Bigquery::Storage::V1::ReadSession::TableReadOptions.

Options dictating how we read a table.

Inherits

  • Object

Extended By

  • Google::Protobuf::MessageExts::ClassMethods

Includes

  • Google::Protobuf::MessageExts

Methods

#arrow_serialization_options

def arrow_serialization_options() -> ::Google::Cloud::Bigquery::Storage::V1::ArrowSerializationOptions
Returns

#arrow_serialization_options=

def arrow_serialization_options=(value) -> ::Google::Cloud::Bigquery::Storage::V1::ArrowSerializationOptions
Parameter
Returns

#row_restriction

def row_restriction() -> ::String
Returns
  • (::String) — SQL text filtering statement, similar to a WHERE clause in a query. Aggregates are not supported.

    Examples: "int_field > 5" "date_field = CAST('2014-9-27' as DATE)" "nullable_field is not NULL" "st_equals(geo_field, st_geofromtext("POINT(2, 2)"))" "numeric_field BETWEEN 1.0 AND 5.0"

    Restricted to a maximum length for 1 MB.

#row_restriction=

def row_restriction=(value) -> ::String
Parameter
  • value (::String) — SQL text filtering statement, similar to a WHERE clause in a query. Aggregates are not supported.

    Examples: "int_field > 5" "date_field = CAST('2014-9-27' as DATE)" "nullable_field is not NULL" "st_equals(geo_field, st_geofromtext("POINT(2, 2)"))" "numeric_field BETWEEN 1.0 AND 5.0"

    Restricted to a maximum length for 1 MB.

Returns
  • (::String) — SQL text filtering statement, similar to a WHERE clause in a query. Aggregates are not supported.

    Examples: "int_field > 5" "date_field = CAST('2014-9-27' as DATE)" "nullable_field is not NULL" "st_equals(geo_field, st_geofromtext("POINT(2, 2)"))" "numeric_field BETWEEN 1.0 AND 5.0"

    Restricted to a maximum length for 1 MB.

#selected_fields

def selected_fields() -> ::Array<::String>
Returns
  • (::Array<::String>) — Names of the fields in the table that should be read. If empty, all fields will be read. If the specified field is a nested field, all the sub-fields in the field will be selected. The output field order is unrelated to the order of fields in selected_fields.

#selected_fields=

def selected_fields=(value) -> ::Array<::String>
Parameter
  • value (::Array<::String>) — Names of the fields in the table that should be read. If empty, all fields will be read. If the specified field is a nested field, all the sub-fields in the field will be selected. The output field order is unrelated to the order of fields in selected_fields.
Returns
  • (::Array<::String>) — Names of the fields in the table that should be read. If empty, all fields will be read. If the specified field is a nested field, all the sub-fields in the field will be selected. The output field order is unrelated to the order of fields in selected_fields.