bigquery  v2
Properties | List of all members
Google.Apis.Bigquery.v2.Data.ExternalDataConfiguration Class Reference
Inheritance diagram for Google.Apis.Bigquery.v2.Data.ExternalDataConfiguration:
Google::Apis::Requests::IDirectResponseSchema

Properties

virtual System.Nullable< bool > Autodetect [get, set]
 Try to detect schema and format options automatically. Any option specified explicitly will be honored. More...
 
virtual BigtableOptions BigtableOptions [get, set]
 [Optional] Additional options if sourceFormat is set to BIGTABLE. More...
 
virtual string Compression [get, set]
 [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. More...
 
virtual CsvOptions CsvOptions [get, set]
 Additional properties to set if sourceFormat is set to CSV. More...
 
virtual GoogleSheetsOptions GoogleSheetsOptions [get, set]
 [Optional] Additional options if sourceFormat is set to GOOGLE_SHEETS. More...
 
virtual string HivePartitioningMode [get, set]
 [Optional, Trusted Tester] Deprecated, do not use. Please set hivePartitioningOptions instead. More...
 
virtual HivePartitioningOptions HivePartitioningOptions [get, set]
 [Optional, Trusted Tester] Options to configure hive partitioning support. More...
 
virtual System.Nullable< bool > IgnoreUnknownValues [get, set]
 [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. More...
 
virtual System.Nullable< int > MaxBadRecords [get, set]
 [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. This is only valid for CSV, JSON, and Google Sheets. 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. More...
 
virtual TableSchema Schema [get, set]
 [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. More...
 
virtual string SourceFormat [get, set]
 [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". [Beta] For Google Cloud Bigtable, specify "BIGTABLE". More...
 
virtual System.Collections.Generic.IList< string > SourceUris [get, set]
 [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. Also, the '*' wildcard character is not allowed. More...
 
virtual string ETag [get, set]
 The ETag of the item. More...
 
- Properties inherited from Google::Apis::Requests::IDirectResponseSchema
string ETag
 

Property Documentation

◆ Autodetect

virtual System.Nullable<bool> Google.Apis.Bigquery.v2.Data.ExternalDataConfiguration.Autodetect
getset

Try to detect schema and format options automatically. Any option specified explicitly will be honored.

◆ BigtableOptions

virtual BigtableOptions Google.Apis.Bigquery.v2.Data.ExternalDataConfiguration.BigtableOptions
getset

[Optional] Additional options if sourceFormat is set to BIGTABLE.

◆ Compression

virtual string Google.Apis.Bigquery.v2.Data.ExternalDataConfiguration.Compression
getset

[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.

◆ CsvOptions

virtual CsvOptions Google.Apis.Bigquery.v2.Data.ExternalDataConfiguration.CsvOptions
getset

Additional properties to set if sourceFormat is set to CSV.

◆ ETag

virtual string Google.Apis.Bigquery.v2.Data.ExternalDataConfiguration.ETag
getset

The ETag of the item.

◆ GoogleSheetsOptions

virtual GoogleSheetsOptions Google.Apis.Bigquery.v2.Data.ExternalDataConfiguration.GoogleSheetsOptions
getset

[Optional] Additional options if sourceFormat is set to GOOGLE_SHEETS.

◆ HivePartitioningMode

virtual string Google.Apis.Bigquery.v2.Data.ExternalDataConfiguration.HivePartitioningMode
getset

[Optional, Trusted Tester] Deprecated, do not use. Please set hivePartitioningOptions instead.

◆ HivePartitioningOptions

virtual HivePartitioningOptions Google.Apis.Bigquery.v2.Data.ExternalDataConfiguration.HivePartitioningOptions
getset

[Optional, Trusted Tester] Options to configure hive partitioning support.

◆ IgnoreUnknownValues

virtual System.Nullable<bool> Google.Apis.Bigquery.v2.Data.ExternalDataConfiguration.IgnoreUnknownValues
getset

[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.

◆ MaxBadRecords

virtual System.Nullable<int> Google.Apis.Bigquery.v2.Data.ExternalDataConfiguration.MaxBadRecords
getset

[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. This is only valid for CSV, JSON, and Google Sheets. 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.

◆ Schema

virtual TableSchema Google.Apis.Bigquery.v2.Data.ExternalDataConfiguration.Schema
getset

[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.

◆ SourceFormat

virtual string Google.Apis.Bigquery.v2.Data.ExternalDataConfiguration.SourceFormat
getset

[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". [Beta] For Google Cloud Bigtable, specify "BIGTABLE".

◆ SourceUris

virtual System.Collections.Generic.IList<string> Google.Apis.Bigquery.v2.Data.ExternalDataConfiguration.SourceUris
getset

[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. Also, the '*' wildcard character is not allowed.


The documentation for this class was generated from the following file: