Class: Google::Apis::BigqueryV2::GoogleSheetsOptions
- Inherits:
-
Object
- Object
- Google::Apis::BigqueryV2::GoogleSheetsOptions
- 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
Overview
Options specific to Google Sheets data sources.
Instance Attribute Summary collapse
-
#range ⇒ String
Optional.
-
#skip_leading_rows ⇒ Fixnum
Optional.
Instance Method Summary collapse
-
#initialize(**args) ⇒ GoogleSheetsOptions
constructor
A new instance of GoogleSheetsOptions.
-
#update!(**args) ⇒ Object
Update properties of this object.
Constructor Details
#initialize(**args) ⇒ GoogleSheetsOptions
Returns a new instance of GoogleSheetsOptions.
3677 3678 3679 |
# File 'lib/google/apis/bigquery_v2/classes.rb', line 3677 def initialize(**args) update!(**args) end |
Instance Attribute Details
#range ⇒ String
Optional. Range of a sheet to query from. Only used when non-empty. Typical
format: sheet_name!top_left_cell_id:bottom_right_cell_id For example: sheet1!
A1:B20
Corresponds to the JSON property range
3660 3661 3662 |
# File 'lib/google/apis/bigquery_v2/classes.rb', line 3660 def range @range end |
#skip_leading_rows ⇒ Fixnum
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, the 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
3675 3676 3677 |
# File 'lib/google/apis/bigquery_v2/classes.rb', line 3675 def skip_leading_rows @skip_leading_rows end |
Instance Method Details
#update!(**args) ⇒ Object
Update properties of this object
3682 3683 3684 3685 |
# File 'lib/google/apis/bigquery_v2/classes.rb', line 3682 def update!(**args) @range = args[:range] if args.key?(:range) @skip_leading_rows = args[:skip_leading_rows] if args.key?(:skip_leading_rows) end |