Class: Google::Apis::BigqueryV2::ExternalDataConfiguration
- Inherits:
-
Object
- Object
- Google::Apis::BigqueryV2::ExternalDataConfiguration
- 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
-
#autodetect ⇒ Boolean
(also: #autodetect?)
[Experimental] Try to detect schema and format options automatically.
-
#bigtable_options ⇒ Google::Apis::BigqueryV2::BigtableOptions
[Optional] Additional options if sourceFormat is set to BIGTABLE.
-
#compression ⇒ String
[Optional] The compression type of the data source.
-
#csv_options ⇒ Google::Apis::BigqueryV2::CsvOptions
Additional properties to set if sourceFormat is set to CSV.
-
#google_sheets_options ⇒ Google::Apis::BigqueryV2::GoogleSheetsOptions
[Optional] Additional options if sourceFormat is set to GOOGLE_SHEETS.
-
#ignore_unknown_values ⇒ Boolean
(also: #ignore_unknown_values?)
[Optional] Indicates if BigQuery should allow extra values that are not represented in the table schema.
-
#max_bad_records ⇒ Fixnum
[Optional] The maximum number of bad records that BigQuery can ignore when reading data.
-
#schema ⇒ Google::Apis::BigqueryV2::TableSchema
[Optional] The schema for the data.
-
#source_format ⇒ String
[Required] The data format.
-
#source_uris ⇒ Array<String>
[Required] The fully-qualified URIs that point to your data in Google Cloud.
Instance Method Summary collapse
-
#initialize(**args) ⇒ ExternalDataConfiguration
constructor
A new instance of ExternalDataConfiguration.
-
#update!(**args) ⇒ Object
Update properties of this object.
Methods included from Core::JsonObjectSupport
Methods included from Core::Hashable
Constructor Details
#initialize(**args) ⇒ ExternalDataConfiguration
Returns a new instance of ExternalDataConfiguration.
803 804 805 |
# File 'generated/google/apis/bigquery_v2/classes.rb', line 803 def initialize(**args) update!(**args) end |
Instance Attribute Details
#autodetect ⇒ Boolean Also known as: autodetect?
[Experimental] Try to detect schema and format options automatically. Any
option specified explicitly will be honored.
Corresponds to the JSON property autodetect
725 726 727 |
# File 'generated/google/apis/bigquery_v2/classes.rb', line 725 def autodetect @autodetect end |
#bigtable_options ⇒ Google::Apis::BigqueryV2::BigtableOptions
[Optional] Additional options if sourceFormat is set to BIGTABLE.
Corresponds to the JSON property bigtableOptions
731 732 733 |
# File 'generated/google/apis/bigquery_v2/classes.rb', line 731 def @bigtable_options end |
#compression ⇒ String
[Optional] The compression type of the data source. Possible values include
GZIP and NONE. The default value is NONE. This setting is ignored for Google
Cloud Bigtable, Google Cloud Datastore backups and Avro formats.
Corresponds to the JSON property compression
738 739 740 |
# File 'generated/google/apis/bigquery_v2/classes.rb', line 738 def compression @compression end |
#csv_options ⇒ Google::Apis::BigqueryV2::CsvOptions
Additional properties to set if sourceFormat is set to CSV.
Corresponds to the JSON property csvOptions
743 744 745 |
# File 'generated/google/apis/bigquery_v2/classes.rb', line 743 def @csv_options end |
#google_sheets_options ⇒ Google::Apis::BigqueryV2::GoogleSheetsOptions
[Optional] Additional options if sourceFormat is set to GOOGLE_SHEETS.
Corresponds to the JSON property googleSheetsOptions
748 749 750 |
# File 'generated/google/apis/bigquery_v2/classes.rb', line 748 def @google_sheets_options end |
#ignore_unknown_values ⇒ Boolean Also known as: ignore_unknown_values?
[Optional] Indicates if BigQuery should allow extra values that are not
represented in the table schema. If true, the extra values are ignored. If
false, records with extra columns are treated as bad records, and if there are
too many bad records, an invalid error is returned in the job result. The
default value is false. The sourceFormat property determines what BigQuery
treats as an extra value: CSV: Trailing columns JSON: Named values that don't
match any column names Google Cloud Bigtable: This setting is ignored. Google
Cloud Datastore backups: This setting is ignored. Avro: This setting is
ignored.
Corresponds to the JSON property ignoreUnknownValues
761 762 763 |
# File 'generated/google/apis/bigquery_v2/classes.rb', line 761 def ignore_unknown_values @ignore_unknown_values end |
#max_bad_records ⇒ Fixnum
[Optional] The maximum number of bad records that BigQuery can ignore when
reading data. If the number of bad records exceeds this value, an invalid
error is returned in the job result. The default value is 0, which requires
that all records are valid. This setting is ignored for Google Cloud Bigtable,
Google Cloud Datastore backups and Avro formats.
Corresponds to the JSON property maxBadRecords
771 772 773 |
# File 'generated/google/apis/bigquery_v2/classes.rb', line 771 def max_bad_records @max_bad_records end |
#schema ⇒ Google::Apis::BigqueryV2::TableSchema
[Optional] The schema for the data. Schema is required for CSV and JSON
formats. Schema is disallowed for Google Cloud Bigtable, Cloud Datastore
backups, and Avro formats.
Corresponds to the JSON property schema
778 779 780 |
# File 'generated/google/apis/bigquery_v2/classes.rb', line 778 def schema @schema end |
#source_format ⇒ String
[Required] The data format. For CSV files, specify "CSV". For Google sheets,
specify "GOOGLE_SHEETS". For newline-delimited JSON, specify "
NEWLINE_DELIMITED_JSON". For Avro files, specify "AVRO". For Google Cloud
Datastore backups, specify "DATASTORE_BACKUP". [Experimental] For Google Cloud
Bigtable, specify "BIGTABLE". Please note that reading from Google Cloud
Bigtable is experimental and has to be enabled for your project. Please
contact Google Cloud Support to enable this for your project.
Corresponds to the JSON property sourceFormat
789 790 791 |
# File 'generated/google/apis/bigquery_v2/classes.rb', line 789 def source_format @source_format end |
#source_uris ⇒ Array<String>
[Required] The fully-qualified URIs that point to your data in Google Cloud.
For Google Cloud Storage URIs: Each URI can contain one '' wildcard character
and it must come after the 'bucket' name. Size limits related to load jobs
apply to external data sources. For Google Cloud Bigtable URIs: Exactly one
URI can be specified and it has be a fully specified and valid HTTPS URL for a
Google Cloud Bigtable table. For Google Cloud Datastore backups, exactly one
URI can be specified, and it must end with '.backup_info'. Also, the ''
wildcard character is not allowed.
Corresponds to the JSON property sourceUris
801 802 803 |
# File 'generated/google/apis/bigquery_v2/classes.rb', line 801 def source_uris @source_uris end |
Instance Method Details
#update!(**args) ⇒ Object
Update properties of this object
808 809 810 811 812 813 814 815 816 817 818 819 |
# File 'generated/google/apis/bigquery_v2/classes.rb', line 808 def update!(**args) @autodetect = args[:autodetect] if args.key?(:autodetect) @bigtable_options = args[:bigtable_options] if args.key?(:bigtable_options) @compression = args[:compression] if args.key?(:compression) @csv_options = args[:csv_options] if args.key?(:csv_options) @google_sheets_options = args[:google_sheets_options] if args.key?(:google_sheets_options) @ignore_unknown_values = args[:ignore_unknown_values] if args.key?(:ignore_unknown_values) @max_bad_records = args[:max_bad_records] if args.key?(:max_bad_records) @schema = args[:schema] if args.key?(:schema) @source_format = args[:source_format] if args.key?(:source_format) @source_uris = args[:source_uris] if args.key?(:source_uris) end |