Class: Google::Apis::BigqueryV2::GoogleSheetsOptions

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

Instance Attribute Summary collapse

Instance Method Summary collapse

Methods included from Core::JsonObjectSupport

#to_json

Methods included from Core::Hashable

process_value, #to_h

Constructor Details

#initialize(**args) ⇒ GoogleSheetsOptions

Returns a new instance of GoogleSheetsOptions



1140
1141
1142
# File 'generated/google/apis/bigquery_v2/classes.rb', line 1140

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

Instance Attribute Details

#rangeString

[Experimental] [Optional] Range of a sheet to query from. Only used when non- empty. Typical format: !: Corresponds to the JSON property range

Returns:

  • (String)


1123
1124
1125
# File 'generated/google/apis/bigquery_v2/classes.rb', line 1123

def range
  @range
end

#skip_leading_rowsFixnum

[Optional] The number of rows at the top of a sheet that BigQuery will skip when reading the data. The default value is 0. This property is useful if you have header rows that should be skipped. When autodetect is on, behavior is the following: * skipLeadingRows unspecified - Autodetect tries to detect headers in the first row. If they are not detected, the row is read as data. Otherwise data is read starting from the second row. * skipLeadingRows is 0 - Instructs autodetect that there are no headers and data should be read starting from the first row. * skipLeadingRows = N > 0 - Autodetect skips N-1 rows and tries to detect headers in row N. If headers are not detected, row N is just skipped. Otherwise row N is used to extract column names for the detected schema. Corresponds to the JSON property skipLeadingRows

Returns:

  • (Fixnum)


1138
1139
1140
# File 'generated/google/apis/bigquery_v2/classes.rb', line 1138

def skip_leading_rows
  @skip_leading_rows
end

Instance Method Details

#update!(**args) ⇒ Object

Update properties of this object



1145
1146
1147
1148
# File 'generated/google/apis/bigquery_v2/classes.rb', line 1145

def update!(**args)
  @range = args[:range] if args.key?(:range)
  @skip_leading_rows = args[:skip_leading_rows] if args.key?(:skip_leading_rows)
end