JobConfigurationExtract configures a job that exports data from a BigQuery table into Google Cloud Storage.

Attributes

• compression (type: String.t, default: nil) - Optional. The compression type to use for exported files. Possible values include DEFLATE, GZIP, NONE, SNAPPY, and ZSTD. The default value is NONE. Not all compression formats are support for all file formats. DEFLATE is only supported for Avro. ZSTD is only supported for Parquet. Not applicable when extracting models.
• destinationFormat (type: String.t, default: nil) - Optional. The exported file format. Possible values include CSV, NEWLINE_DELIMITED_JSON, PARQUET, or AVRO for tables and ML_TF_SAVED_MODEL or ML_XGBOOST_BOOSTER for models. The default value for tables is CSV. Tables with nested or repeated fields cannot be exported as CSV. The default value for models is ML_TF_SAVED_MODEL.
• destinationUri (type: String.t, default: nil) - [Pick one] DEPRECATED: Use destinationUris instead, passing only one URI as necessary. The fully-qualified Google Cloud Storage URI where the extracted table should be written.
• destinationUris (type: list(String.t), default: nil) - [Pick one] A list of fully-qualified Google Cloud Storage URIs where the extracted table should be written.
• fieldDelimiter (type: String.t, default: nil) - Optional. When extracting data in CSV format, this defines the delimiter to use between fields in the exported data. Default is ','. Not applicable when extracting models.
• modelExtractOptions (type: GoogleApi.BigQuery.V2.Model.ModelExtractOptions.t, default: nil) - Optional. Model extract options only applicable when extracting models.
• printHeader (type: boolean(), default: true) - Optional. Whether to print out a header row in the results. Default is true. Not applicable when extracting models.
• sourceModel (type: GoogleApi.BigQuery.V2.Model.ModelReference.t, default: nil) - A reference to the model being exported.
• sourceTable (type: GoogleApi.BigQuery.V2.Model.TableReference.t, default: nil) - A reference to the table being exported.
• useAvroLogicalTypes (type: boolean(), default: nil) - Whether to use logical types when extracting to AVRO format. Not applicable when extracting models.