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