1---
2apiVersion: apiextensions.k8s.io/v1
3kind: CustomResourceDefinition
4metadata:
5 annotations:
6 controller-gen.kubebuilder.io/version: (unknown)
7 name: bigqueryjobs.bigquery.cnrm.cloud.google.com
8spec:
9 group: bigquery.cnrm.cloud.google.com
10 names:
11 kind: BigQueryJob
12 listKind: BigQueryJobList
13 plural: bigqueryjobs
14 singular: bigqueryjob
15 scope: Namespaced
16 versions:
17 - name: v1beta1
18 schema:
19 openAPIV3Schema:
20 description: BigQueryJob is the Schema for the bigquery API
21 properties:
22 apiVersion:
23 description: |-
24 APIVersion defines the versioned schema of this representation of an object.
25 Servers should convert recognized schemas to the latest internal value, and
26 may reject unrecognized values.
27 More info: https://git.k8s.io/community/contributors/devel/sig-architecture/api-conventions.md#resources
28 type: string
29 kind:
30 description: |-
31 Kind is a string value representing the REST resource this object represents.
32 Servers may infer this from the endpoint the client submits requests to.
33 Cannot be updated.
34 In CamelCase.
35 More info: https://git.k8s.io/community/contributors/devel/sig-architecture/api-conventions.md#types-kinds
36 type: string
37 metadata:
38 type: object
39 spec:
40 properties:
41 copy:
42 description: Immutable. Copies a table.
43 properties:
44 createDisposition:
45 description: |-
46 Immutable. Specifies whether the job is allowed to create new tables. The following values are supported:
47 CREATE_IF_NEEDED: If the table does not exist, BigQuery creates the table.
48 CREATE_NEVER: The table must already exist. If it does not, a 'notFound' error is returned in the job result.
49 Creation, truncation and append actions occur as one atomic update upon job completion Default value: "CREATE_NEVER" Possible values: ["CREATE_IF_NEEDED", "CREATE_NEVER"].
50 type: string
51 destinationEncryptionConfiguration:
52 description: Immutable. Custom encryption configuration (e.g.,
53 Cloud KMS keys).
54 properties:
55 kmsKeyRef:
56 description: |-
57 Describes the Cloud KMS encryption key that will be used to protect
58 destination BigQuery table. The BigQuery Service Account associated
59 with your project requires access to this encryption key.
60 properties:
61 external:
62 description: The external name of the referenced resource
63 type: string
64 kind:
65 description: Kind of the referent.
66 type: string
67 name:
68 description: 'Name of the referent. More info: https://kubernetes.io/docs/concepts/overview/working-with-objects/names/#names'
69 type: string
70 namespace:
71 description: 'Namespace of the referent. More info: https://kubernetes.io/docs/concepts/overview/working-with-objects/namespaces/'
72 type: string
73 type: object
74 kmsKeyVersion:
75 description: Describes the Cloud KMS encryption key version
76 used to protect destination BigQuery table.
77 type: string
78 required:
79 - kmsKeyRef
80 type: object
81 destinationTable:
82 description: Immutable. The destination table.
83 properties:
84 tableRef:
85 description: A reference to the table.
86 properties:
87 external:
88 description: The external name of the referenced resource
89 type: string
90 kind:
91 description: Kind of the referent.
92 type: string
93 name:
94 description: 'Name of the referent. More info: https://kubernetes.io/docs/concepts/overview/working-with-objects/names/#names'
95 type: string
96 namespace:
97 description: 'Namespace of the referent. More info: https://kubernetes.io/docs/concepts/overview/working-with-objects/namespaces/'
98 type: string
99 type: object
100 required:
101 - tableRef
102 type: object
103 sourceTables:
104 description: Immutable. Source tables to copy.
105 items:
106 properties:
107 tableRef:
108 description: A reference to the table.
109 properties:
110 external:
111 description: The external name of the referenced resource
112 type: string
113 kind:
114 description: Kind of the referent.
115 type: string
116 name:
117 description: 'Name of the referent. More info: https://kubernetes.io/docs/concepts/overview/working-with-objects/names/#names'
118 type: string
119 namespace:
120 description: 'Namespace of the referent. More info:
121 https://kubernetes.io/docs/concepts/overview/working-with-objects/namespaces/'
122 type: string
123 type: object
124 required:
125 - tableRef
126 type: object
127 type: array
128 writeDisposition:
129 description: |-
130 Immutable. Specifies the action that occurs if the destination table already exists. The following values are supported:
131 WRITE_TRUNCATE: If the table already exists, BigQuery overwrites the table data and uses the schema from the query result.
132 WRITE_APPEND: If the table already exists, BigQuery appends the data to the table.
133 WRITE_EMPTY: If the table already exists and contains data, a 'duplicate' error is returned in the job result.
134 Each action is atomic and only occurs if BigQuery is able to complete the job successfully.
135 Creation, truncation and append actions occur as one atomic update upon job completion. Default value: "WRITE_EMPTY" Possible values: ["WRITE_TRUNCATE", "WRITE_APPEND", "WRITE_EMPTY"].
136 type: string
137 required:
138 - sourceTables
139 type: object
140 extract:
141 description: Immutable. Configures an extract job.
142 properties:
143 compression:
144 description: |-
145 Immutable. The compression type to use for exported files. Possible values include GZIP, DEFLATE, SNAPPY, and NONE.
146 The default value is NONE. DEFLATE and SNAPPY are only supported for Avro.
147 type: string
148 destinationFormat:
149 description: |-
150 Immutable. The exported file format. Possible values include CSV, NEWLINE_DELIMITED_JSON and AVRO for tables and SAVED_MODEL for models.
151 The default value for tables is CSV. Tables with nested or repeated fields cannot be exported as CSV.
152 The default value for models is SAVED_MODEL.
153 type: string
154 destinationUris:
155 description: Immutable. A list of fully-qualified Google Cloud
156 Storage URIs where the extracted table should be written.
157 items:
158 type: string
159 type: array
160 fieldDelimiter:
161 description: |-
162 Immutable. When extracting data in CSV format, this defines the delimiter to use between fields in the exported data.
163 Default is ','.
164 type: string
165 printHeader:
166 description: Immutable. Whether to print out a header row in the
167 results. Default is true.
168 type: boolean
169 sourceTable:
170 description: Immutable. A reference to the table being exported.
171 properties:
172 tableRef:
173 description: A reference to the table.
174 properties:
175 external:
176 description: The external name of the referenced resource
177 type: string
178 kind:
179 description: Kind of the referent.
180 type: string
181 name:
182 description: 'Name of the referent. More info: https://kubernetes.io/docs/concepts/overview/working-with-objects/names/#names'
183 type: string
184 namespace:
185 description: 'Namespace of the referent. More info: https://kubernetes.io/docs/concepts/overview/working-with-objects/namespaces/'
186 type: string
187 type: object
188 required:
189 - tableRef
190 type: object
191 useAvroLogicalTypes:
192 description: Immutable. Whether to use logical types when extracting
193 to AVRO format.
194 type: boolean
195 required:
196 - destinationUris
197 type: object
198 jobTimeoutMs:
199 description: Immutable. Job timeout in milliseconds. If this time
200 limit is exceeded, BigQuery may attempt to terminate the job.
201 type: string
202 load:
203 description: Immutable. Configures a load job.
204 properties:
205 allowJaggedRows:
206 description: |-
207 Immutable. Accept rows that are missing trailing optional columns. The missing values are treated as nulls.
208 If false, records with missing trailing columns are treated as bad records, and if there are too many bad records,
209 an invalid error is returned in the job result. The default value is false. Only applicable to CSV, ignored for other formats.
210 type: boolean
211 allowQuotedNewlines:
212 description: |-
213 Immutable. Indicates if BigQuery should allow quoted data sections that contain newline characters in a CSV file.
214 The default value is false.
215 type: boolean
216 autodetect:
217 description: Immutable. Indicates if we should automatically infer
218 the options and schema for CSV and JSON sources.
219 type: boolean
220 createDisposition:
221 description: |-
222 Immutable. Specifies whether the job is allowed to create new tables. The following values are supported:
223 CREATE_IF_NEEDED: If the table does not exist, BigQuery creates the table.
224 CREATE_NEVER: The table must already exist. If it does not, a 'notFound' error is returned in the job result.
225 Creation, truncation and append actions occur as one atomic update upon job completion Default value: "CREATE_NEVER" Possible values: ["CREATE_IF_NEEDED", "CREATE_NEVER"].
226 type: string
227 destinationEncryptionConfiguration:
228 description: Immutable. Custom encryption configuration (e.g.,
229 Cloud KMS keys).
230 properties:
231 kmsKeyRef:
232 description: |-
233 Describes the Cloud KMS encryption key that will be used to protect
234 destination BigQuery table. The BigQuery Service Account associated
235 with your project requires access to this encryption key.
236 properties:
237 external:
238 description: The external name of the referenced resource
239 type: string
240 kind:
241 description: Kind of the referent.
242 type: string
243 name:
244 description: 'Name of the referent. More info: https://kubernetes.io/docs/concepts/overview/working-with-objects/names/#names'
245 type: string
246 namespace:
247 description: 'Namespace of the referent. More info: https://kubernetes.io/docs/concepts/overview/working-with-objects/namespaces/'
248 type: string
249 type: object
250 kmsKeyVersion:
251 description: Describes the Cloud KMS encryption key version
252 used to protect destination BigQuery table.
253 type: string
254 required:
255 - kmsKeyRef
256 type: object
257 destinationTable:
258 description: Immutable. The destination table to load the data
259 into.
260 properties:
261 tableRef:
262 description: A reference to the table.
263 properties:
264 external:
265 description: The external name of the referenced resource
266 type: string
267 kind:
268 description: Kind of the referent.
269 type: string
270 name:
271 description: 'Name of the referent. More info: https://kubernetes.io/docs/concepts/overview/working-with-objects/names/#names'
272 type: string
273 namespace:
274 description: 'Namespace of the referent. More info: https://kubernetes.io/docs/concepts/overview/working-with-objects/namespaces/'
275 type: string
276 type: object
277 required:
278 - tableRef
279 type: object
280 encoding:
281 description: |-
282 Immutable. The character encoding of the data. The supported values are UTF-8 or ISO-8859-1.
283 The default value is UTF-8. BigQuery decodes the data after the raw, binary data
284 has been split using the values of the quote and fieldDelimiter properties.
285 type: string
286 fieldDelimiter:
287 description: |-
288 Immutable. The separator for fields in a CSV file. The separator can be any ISO-8859-1 single-byte character.
289 To use a character in the range 128-255, you must encode the character as UTF8. BigQuery converts
290 the string to ISO-8859-1 encoding, and then uses the first byte of the encoded string to split the
291 data in its raw, binary state. BigQuery also supports the escape sequence "\t" to specify a tab separator.
292 The default value is a comma (',').
293 type: string
294 ignoreUnknownValues:
295 description: |-
296 Immutable. Indicates if BigQuery should allow extra values that are not represented in the table schema.
297 If true, the extra values are ignored. If false, records with extra columns are treated as bad records,
298 and if there are too many bad records, an invalid error is returned in the job result.
299 The default value is false. The sourceFormat property determines what BigQuery treats as an extra value:
300 CSV: Trailing columns
301 JSON: Named values that don't match any column names.
302 type: boolean
303 jsonExtension:
304 description: |-
305 Immutable. If sourceFormat is set to newline-delimited JSON, indicates whether it should be processed as a JSON variant such as GeoJSON.
306 For a sourceFormat other than JSON, omit this field. If the sourceFormat is newline-delimited JSON: - for newline-delimited
307 GeoJSON: set to GEOJSON.
308 type: string
309 maxBadRecords:
310 description: |-
311 Immutable. The maximum number of bad records that BigQuery can ignore when running the job. If the number of bad records exceeds this value,
312 an invalid error is returned in the job result. The default value is 0, which requires that all records are valid.
313 type: integer
314 nullMarker:
315 description: |-
316 Immutable. Specifies a string that represents a null value in a CSV file. For example, if you specify "\N", BigQuery interprets "\N" as a null value
317 when loading a CSV file. The default value is the empty string. If you set this property to a custom value, BigQuery throws an error if an
318 empty string is present for all data types except for STRING and BYTE. For STRING and BYTE columns, BigQuery interprets the empty string as
319 an empty value.
320 type: string
321 parquetOptions:
322 description: Immutable. Parquet Options for load and make external
323 tables.
324 properties:
325 enableListInference:
326 description: Immutable. If sourceFormat is set to PARQUET,
327 indicates whether to use schema inference specifically for
328 Parquet LIST logical type.
329 type: boolean
330 enumAsString:
331 description: Immutable. If sourceFormat is set to PARQUET,
332 indicates whether to infer Parquet ENUM logical type as
333 STRING instead of BYTES by default.
334 type: boolean
335 type: object
336 projectionFields:
337 description: |-
338 Immutable. If sourceFormat is set to "DATASTORE_BACKUP", indicates which entity properties to load into BigQuery from a Cloud Datastore backup.
339 Property names are case sensitive and must be top-level properties. If no properties are specified, BigQuery loads all properties.
340 If any named property isn't found in the Cloud Datastore backup, an invalid error is returned in the job result.
341 items:
342 type: string
343 type: array
344 quote:
345 description: |-
346 Immutable. The value that is used to quote data sections in a CSV file. BigQuery converts the string to ISO-8859-1 encoding,
347 and then uses the first byte of the encoded string to split the data in its raw, binary state.
348 The default value is a double-quote ('"'). If your data does not contain quoted sections, set the property value to an empty string.
349 If your data contains quoted newline characters, you must also set the allowQuotedNewlines property to true.
350 type: string
351 schemaUpdateOptions:
352 description: |-
353 Immutable. Allows the schema of the destination table to be updated as a side effect of the load job if a schema is autodetected or
354 supplied in the job configuration. Schema update options are supported in two cases: when writeDisposition is WRITE_APPEND;
355 when writeDisposition is WRITE_TRUNCATE and the destination table is a partition of a table, specified by partition decorators.
356 For normal tables, WRITE_TRUNCATE will always overwrite the schema. One or more of the following values are specified:
357 ALLOW_FIELD_ADDITION: allow adding a nullable field to the schema.
358 ALLOW_FIELD_RELAXATION: allow relaxing a required field in the original schema to nullable.
359 items:
360 type: string
361 type: array
362 skipLeadingRows:
363 description: |-
364 Immutable. The number of rows at the top of a CSV file that BigQuery will skip when loading the data.
365 The default value is 0. This property is useful if you have header rows in the file that should be skipped.
366 When autodetect is on, the behavior is the following:
367 skipLeadingRows unspecified - Autodetect tries to detect headers in the first row. If they are not detected,
368 the row is read as data. Otherwise data is read starting from the second row.
369 skipLeadingRows is 0 - Instructs autodetect that there are no headers and data should be read starting from the first row.
370 skipLeadingRows = N > 0 - Autodetect skips N-1 rows and tries to detect headers in row N. If headers are not detected,
371 row N is just skipped. Otherwise row N is used to extract column names for the detected schema.
372 type: integer
373 sourceFormat:
374 description: |-
375 Immutable. The format of the data files. For CSV files, specify "CSV". For datastore backups, specify "DATASTORE_BACKUP".
376 For newline-delimited JSON, specify "NEWLINE_DELIMITED_JSON". For Avro, specify "AVRO". For parquet, specify "PARQUET".
377 For orc, specify "ORC". [Beta] For Bigtable, specify "BIGTABLE".
378 The default value is CSV.
379 type: string
380 sourceUris:
381 description: |-
382 Immutable. The fully-qualified URIs that point to your data in Google Cloud.
383 For Google Cloud Storage URIs: Each URI can contain one '\*' wildcard character
384 and it must come after the 'bucket' name. Size limits related to load jobs apply
385 to external data sources. For Google Cloud Bigtable URIs: Exactly one URI can be
386 specified and it has be a fully specified and valid HTTPS URL for a Google Cloud Bigtable table.
387 For Google Cloud Datastore backups: Exactly one URI can be specified. Also, the '\*' wildcard character is not allowed.
388 items:
389 type: string
390 type: array
391 timePartitioning:
392 description: Immutable. Time-based partitioning specification
393 for the destination table.
394 properties:
395 expirationMs:
396 description: Immutable. Number of milliseconds for which to
397 keep the storage for a partition. A wrapper is used here
398 because 0 is an invalid value.
399 type: string
400 field:
401 description: |-
402 Immutable. If not set, the table is partitioned by pseudo column '_PARTITIONTIME'; if set, the table is partitioned by this field.
403 The field must be a top-level TIMESTAMP or DATE field. Its mode must be NULLABLE or REQUIRED.
404 A wrapper is used here because an empty string is an invalid value.
405 type: string
406 type:
407 description: |-
408 Immutable. The only type supported is DAY, which will generate one partition per day. Providing an empty string used to cause an error,
409 but in OnePlatform the field will be treated as unset.
410 type: string
411 required:
412 - type
413 type: object
414 writeDisposition:
415 description: |-
416 Immutable. Specifies the action that occurs if the destination table already exists. The following values are supported:
417 WRITE_TRUNCATE: If the table already exists, BigQuery overwrites the table data and uses the schema from the query result.
418 WRITE_APPEND: If the table already exists, BigQuery appends the data to the table.
419 WRITE_EMPTY: If the table already exists and contains data, a 'duplicate' error is returned in the job result.
420 Each action is atomic and only occurs if BigQuery is able to complete the job successfully.
421 Creation, truncation and append actions occur as one atomic update upon job completion. Default value: "WRITE_EMPTY" Possible values: ["WRITE_TRUNCATE", "WRITE_APPEND", "WRITE_EMPTY"].
422 type: string
423 required:
424 - destinationTable
425 - sourceUris
426 type: object
427 location:
428 description: Immutable. The geographic location of the job. The default
429 value is US.
430 type: string
431 query:
432 description: Immutable. Configures a query job.
433 properties:
434 allowLargeResults:
435 description: |-
436 Immutable. If true and query uses legacy SQL dialect, allows the query to produce arbitrarily large result tables at a slight cost in performance.
437 Requires destinationTable to be set. For standard SQL queries, this flag is ignored and large results are always allowed.
438 However, you must still set destinationTable when result size exceeds the allowed maximum response size.
439 type: boolean
440 createDisposition:
441 description: |-
442 Immutable. Specifies whether the job is allowed to create new tables. The following values are supported:
443 CREATE_IF_NEEDED: If the table does not exist, BigQuery creates the table.
444 CREATE_NEVER: The table must already exist. If it does not, a 'notFound' error is returned in the job result.
445 Creation, truncation and append actions occur as one atomic update upon job completion Default value: "CREATE_NEVER" Possible values: ["CREATE_IF_NEEDED", "CREATE_NEVER"].
446 type: string
447 defaultDataset:
448 description: Immutable. Specifies the default dataset to use for
449 unqualified table names in the query. Note that this does not
450 alter behavior of unqualified dataset names.
451 properties:
452 datasetRef:
453 description: A reference to the dataset.
454 properties:
455 external:
456 description: The external name of the referenced resource
457 type: string
458 kind:
459 description: Kind of the referent.
460 type: string
461 name:
462 description: 'Name of the referent. More info: https://kubernetes.io/docs/concepts/overview/working-with-objects/names/#names'
463 type: string
464 namespace:
465 description: 'Namespace of the referent. More info: https://kubernetes.io/docs/concepts/overview/working-with-objects/namespaces/'
466 type: string
467 type: object
468 required:
469 - datasetRef
470 type: object
471 destinationEncryptionConfiguration:
472 description: Immutable. Custom encryption configuration (e.g.,
473 Cloud KMS keys).
474 properties:
475 kmsKeyRef:
476 description: |-
477 Describes the Cloud KMS encryption key that will be used to protect
478 destination BigQuery table. The BigQuery Service Account associated
479 with your project requires access to this encryption key.
480 properties:
481 external:
482 description: The external name of the referenced resource
483 type: string
484 kind:
485 description: Kind of the referent.
486 type: string
487 name:
488 description: 'Name of the referent. More info: https://kubernetes.io/docs/concepts/overview/working-with-objects/names/#names'
489 type: string
490 namespace:
491 description: 'Namespace of the referent. More info: https://kubernetes.io/docs/concepts/overview/working-with-objects/namespaces/'
492 type: string
493 type: object
494 kmsKeyVersion:
495 description: Describes the Cloud KMS encryption key version
496 used to protect destination BigQuery table.
497 type: string
498 required:
499 - kmsKeyRef
500 type: object
501 destinationTable:
502 description: |-
503 Immutable. Describes the table where the query results should be stored.
504 This property must be set for large results that exceed the maximum response size.
505 For queries that produce anonymous (cached) results, this field will be populated by BigQuery.
506 properties:
507 tableRef:
508 description: A reference to the table.
509 properties:
510 external:
511 description: The external name of the referenced resource
512 type: string
513 kind:
514 description: Kind of the referent.
515 type: string
516 name:
517 description: 'Name of the referent. More info: https://kubernetes.io/docs/concepts/overview/working-with-objects/names/#names'
518 type: string
519 namespace:
520 description: 'Namespace of the referent. More info: https://kubernetes.io/docs/concepts/overview/working-with-objects/namespaces/'
521 type: string
522 type: object
523 required:
524 - tableRef
525 type: object
526 flattenResults:
527 description: |-
528 Immutable. If true and query uses legacy SQL dialect, flattens all nested and repeated fields in the query results.
529 allowLargeResults must be true if this is set to false. For standard SQL queries, this flag is ignored and results are never flattened.
530 type: boolean
531 maximumBillingTier:
532 description: |-
533 Immutable. Limits the billing tier for this job. Queries that have resource usage beyond this tier will fail (without incurring a charge).
534 If unspecified, this will be set to your project default.
535 type: integer
536 maximumBytesBilled:
537 description: |-
538 Immutable. Limits the bytes billed for this job. Queries that will have bytes billed beyond this limit will fail (without incurring a charge).
539 If unspecified, this will be set to your project default.
540 type: string
541 parameterMode:
542 description: Immutable. Standard SQL only. Set to POSITIONAL to
543 use positional (?) query parameters or to NAMED to use named
544 (@myparam) query parameters in this query.
545 type: string
546 priority:
547 description: 'Immutable. Specifies a priority for the query. Default
548 value: "INTERACTIVE" Possible values: ["INTERACTIVE", "BATCH"].'
549 type: string
550 query:
551 description: |-
552 Immutable. SQL query text to execute. The useLegacySql field can be used to indicate whether the query uses legacy SQL or standard SQL.
553 *NOTE*: queries containing [DML language](https://cloud.google.com/bigquery/docs/reference/standard-sql/data-manipulation-language)
554 ('DELETE', 'UPDATE', 'MERGE', 'INSERT') must specify 'create_disposition = ""' and 'write_disposition = ""'.
555 type: string
556 schemaUpdateOptions:
557 description: |-
558 Immutable. Allows the schema of the destination table to be updated as a side effect of the query job.
559 Schema update options are supported in two cases: when writeDisposition is WRITE_APPEND;
560 when writeDisposition is WRITE_TRUNCATE and the destination table is a partition of a table,
561 specified by partition decorators. For normal tables, WRITE_TRUNCATE will always overwrite the schema.
562 One or more of the following values are specified:
563 ALLOW_FIELD_ADDITION: allow adding a nullable field to the schema.
564 ALLOW_FIELD_RELAXATION: allow relaxing a required field in the original schema to nullable.
565 items:
566 type: string
567 type: array
568 scriptOptions:
569 description: Immutable. Options controlling the execution of scripts.
570 properties:
571 keyResultStatement:
572 description: |-
573 Immutable. Determines which statement in the script represents the "key result",
574 used to populate the schema and query results of the script job. Possible values: ["LAST", "FIRST_SELECT"].
575 type: string
576 statementByteBudget:
577 description: Immutable. Limit on the number of bytes billed
578 per statement. Exceeding this budget results in an error.
579 type: string
580 statementTimeoutMs:
581 description: Immutable. Timeout period for each statement
582 in a script.
583 type: string
584 type: object
585 useLegacySql:
586 description: |-
587 Immutable. Specifies whether to use BigQuery's legacy SQL dialect for this query. The default value is true.
588 If set to false, the query will use BigQuery's standard SQL.
589 type: boolean
590 useQueryCache:
591 description: |-
592 Immutable. Whether to look for the result in the query cache. The query cache is a best-effort cache that will be flushed whenever
593 tables in the query are modified. Moreover, the query cache is only available when a query does not have a destination table specified.
594 The default value is true.
595 type: boolean
596 userDefinedFunctionResources:
597 description: Immutable. Describes user-defined function resources
598 used in the query.
599 items:
600 properties:
601 inlineCode:
602 description: |-
603 Immutable. An inline resource that contains code for a user-defined function (UDF).
604 Providing a inline code resource is equivalent to providing a URI for a file containing the same code.
605 type: string
606 resourceUri:
607 description: Immutable. A code resource to load from a Google
608 Cloud Storage URI (gs://bucket/path).
609 type: string
610 type: object
611 type: array
612 writeDisposition:
613 description: |-
614 Immutable. Specifies the action that occurs if the destination table already exists. The following values are supported:
615 WRITE_TRUNCATE: If the table already exists, BigQuery overwrites the table data and uses the schema from the query result.
616 WRITE_APPEND: If the table already exists, BigQuery appends the data to the table.
617 WRITE_EMPTY: If the table already exists and contains data, a 'duplicate' error is returned in the job result.
618 Each action is atomic and only occurs if BigQuery is able to complete the job successfully.
619 Creation, truncation and append actions occur as one atomic update upon job completion. Default value: "WRITE_EMPTY" Possible values: ["WRITE_TRUNCATE", "WRITE_APPEND", "WRITE_EMPTY"].
620 type: string
621 required:
622 - query
623 type: object
624 resourceID:
625 description: Immutable. Optional. The jobId of the resource. Used
626 for creation and acquisition. When unset, the value of `metadata.name`
627 is used as the default.
628 type: string
629 type: object
630 status:
631 properties:
632 conditions:
633 description: |-
634 Conditions represent the latest available observations of the
635 BigQueryJob's current state.
636 items:
637 properties:
638 lastTransitionTime:
639 description: Last time the condition transitioned from one status
640 to another.
641 type: string
642 message:
643 description: Human-readable message indicating details about
644 last transition.
645 type: string
646 reason:
647 description: |-
648 Unique, one-word, CamelCase reason for the condition's last
649 transition.
650 type: string
651 status:
652 description: Status is the status of the condition. Can be True,
653 False, Unknown.
654 type: string
655 type:
656 description: Type is the type of the condition.
657 type: string
658 type: object
659 type: array
660 jobType:
661 description: The type of the job.
662 type: string
663 observedGeneration:
664 description: ObservedGeneration is the generation of the resource
665 that was most recently observed by the Config Connector controller.
666 If this is equal to metadata.generation, then that means that the
667 current reported status reflects the most recent desired state of
668 the resource.
669 type: integer
670 status:
671 description: The status of this job. Examine this value when polling
672 an asynchronous job to see if the job is complete.
673 items:
674 properties:
675 errorResult:
676 description: Final error result of the job. If present, indicates
677 that the job has completed and was unsuccessful.
678 items:
679 properties:
680 location:
681 description: Specifies where the error occurred, if present.
682 type: string
683 message:
684 description: A human-readable description of the error.
685 type: string
686 reason:
687 description: A short error code that summarizes the error.
688 type: string
689 type: object
690 type: array
691 errors:
692 description: |-
693 The first errors encountered during the running of the job. The final message
694 includes the number of errors that caused the process to stop. Errors here do
695 not necessarily mean that the job has not completed or was unsuccessful.
696 items:
697 properties:
698 location:
699 description: Specifies where the error occurred, if present.
700 type: string
701 message:
702 description: A human-readable description of the error.
703 type: string
704 reason:
705 description: A short error code that summarizes the error.
706 type: string
707 type: object
708 type: array
709 state:
710 description: Running state of the job. Valid states include
711 'PENDING', 'RUNNING', and 'DONE'.
712 type: string
713 type: object
714 type: array
715 userEmail:
716 description: Email address of the user who ran the job.
717 type: string
718 type: object
719 type: object
720 served: true
721 storage: true
View as plain text