[SrSSKJr SSKJr SSKJr SSKJr SSKJr SSK r SSK J r SS K J r SS KJr SS KJr SSKJr SS KJ r SS KJr SS KJr "SS\R*5rg)z!The BigQuery CLI extract command.)absolute_import)division)print_function)Optional)flagsN) client_job)utils)bigquery_command)bq_cached_client) utils_flags)utils_formattingch^\rSrSrSrS\S\R4U4SjjrS\S\S\ \ 4S jr S r U=r $) Extractz)extract namefvc>[[U] X5 [R"SSSSUS9 [R "SS/SQSUS9 [R "S SS US9 [R"S SS US9 [R "S S/SQSUS9 [R"SSSUS9 [R"SSSUS9 [R"SSSSUS9 [R"US9Ul URU5 g)Nfield_delimiterzThe character that indicates the boundary between columns in the output file. "\t" and "tab" are accepted names for tab. Not applicable when extracting models.F) short_name flag_valuesdestination_format)CSVNEWLINE_DELIMITED_JSONAVROPARQUETML_TF_SAVED_MODELML_XGBOOST_BOOSTERaeThe extracted file format. Format CSV, NEWLINE_DELIMITED_JSON, PARQUET and AVRO are applicable for extracting tables. Formats ML_TF_SAVED_MODEL and ML_XGBOOST_BOOSTER are applicable for extracting 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.)rtrial_idz1-based ID of the trial to be exported from a hyperparameter tuning model. The default_trial_id will be exported if not specified. This does not apply for models not trained with hyperparameter tuning.add_serving_default_signaturezXWhether to add serving_default signature for export BigQuery ML trained tf based models. compressionNONE)GZIPDEFLATESNAPPYZSTDr"zThe compression type to use for exported files. Possible values include GZIP, DEFLATE, SNAPPY, ZSTD, and NONE. The default value is None. Not applicable when extracting models. print_headerz|Whether to print header rows for formats that have headers. Prints headers by default.Not applicable when extracting models.use_avro_logical_typesaIf destinationFormat is set to "AVRO", this flag indicates whether to enable extracting applicable column types (such as TIMESTAMP) to their corresponding AVRO logical types (timestamp-micros), instead of only using their raw types (avro-long). Not applicable when extracting models.modelFz!Extract model with this model ID.m) superr__init__r DEFINE_string DEFINE_enumDEFINE_integerDEFINE_booleanfrontend_flagsdefine_reservation_id_for_a_jobreservation_id_for_a_job_flag_ProcessCommandRc)selfrr __class__s 'platform/bq/frontend/command_extract.pyr,Extract.__init__sA '4!$+   1    1 #&   L  '  #  5 7   1     1    +  662F & 2 identifierdestination_urisreturnc n[RR5nS[R"50n[ R R(a[ R RUS'URR(aURRUS'UR(a[R"X1S9nO[R"X1S9n[R"UUU4UR ["R$"UR&5UR(UR*UR,UR.UR0S.UD6n[ R2R(a+["R4"[6R8"U55 gUR;U5 g)aPerform an extract operation of source into destination_uris. Usage: extract Use -m option to extract a source_model. Examples: bq extract ds.table gs://mybucket/table.csv bq extract -m ds.model gs://mybucket/model Arguments: source_table: Source table to extract. source_model: Source model to extract. destination_uris: One or more Google Cloud Storage URIs, separated by commas. job_idlocationreservation_id) id_fallbacksr:)r'rrrr r!r(N)r ClientGetr get_job_id_from_flagsbq_flagsLOCATIONvaluer3presentr*bq_client_utilsGetModelReferenceGetTableReferencerrr'frontend_utilsNormalizeFieldDelimiterrrrr r!r(SYNCHRONOUS_MODEPrintJobMessagesr format_job_infoPrintJobStartInfo)r5r:r;clientkwds referencejobs r7 RunWithArgsExtract.RunWithArgsrs[( $ $ ( ( *F+335 D!**00d: ))11#AAGGd  vv!33i"33i    &&&>>    22&*&H&H$$#::   C  &&%%&6&F&Fs&KL S!r9)r3)__name__ __module__ __qualname____firstlineno__usagestrr FlagValuesr,rintrV__static_attributes__ __classcell__)r6s@r7rrsK 9%R3RE$4$4Rh8"8"/28"}8"8"r9r)__doc__ __future__rrrtypingrabslrrEclientsrr rIfrontendr r r1rLr r BigqueryCmdrr9r7rjsG'&%,%%,, %O"**O"r9