Class: Google::Apis::BigqueryV2::GoogleSheetsOptions
- Inherits:
-
Object
- Object
- Google::Apis::BigqueryV2::GoogleSheetsOptions
- 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
-
#range ⇒ String
[Beta] [Optional] Range of a sheet to query from.
-
#skip_leading_rows ⇒ Fixnum
[Optional] The number of rows at the top of a sheet that BigQuery will skip when reading the data.
Instance Method Summary collapse
-
#initialize(**args) ⇒ GoogleSheetsOptions
constructor
A new instance of GoogleSheetsOptions.
-
#update!(**args) ⇒ Object
Update properties of this object.
Methods included from Core::JsonObjectSupport
Methods included from Core::Hashable
Constructor Details
#initialize(**args) ⇒ GoogleSheetsOptions
Returns a new instance of GoogleSheetsOptions
1687 1688 1689 |
# File 'generated/google/apis/bigquery_v2/classes.rb', line 1687 def initialize(**args) update!(**args) end |
Instance Attribute Details
#range ⇒ String
[Beta] [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
1670 1671 1672 |
# File 'generated/google/apis/bigquery_v2/classes.rb', line 1670 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, 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
1685 1686 1687 |
# File 'generated/google/apis/bigquery_v2/classes.rb', line 1685 def skip_leading_rows @skip_leading_rows end |
Instance Method Details
#update!(**args) ⇒ Object
Update properties of this object
1692 1693 1694 1695 |
# File 'generated/google/apis/bigquery_v2/classes.rb', line 1692 def update!(**args) @range = args[:range] if args.key?(:range) @skip_leading_rows = args[:skip_leading_rows] if args.key?(:skip_leading_rows) end |