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: bigquery.cnrm.cloud.google.com/v1beta1
16kind: BigQueryJob
17metadata:
18 labels:
19 label-one: "value-one"
20 # BigQueryJobs cannot be deleted from GCP, so you must use a new unique name
21 # if you want to create a new job, otherwise Config Connector will try to
22 # acquire the job with the given name.
23 name: bigqueryjob-sample-query
24spec:
25 location: "US"
26 jobTimeoutMs: "600000"
27 query:
28 query: "SELECT state FROM [lookerdata:cdc.project_tycho_reports]"
29 useLegacySql: true
30 defaultDataset:
31 datasetRef:
32 name: bigqueryjobdep1query
33 destinationTable:
34 tableRef:
35 name: bigqueryjobdepquery
36 allowLargeResults: true
37 flattenResults: true
38 useQueryCache: true
39 priority: "INTERACTIVE"
40 writeDisposition: "WRITE_APPEND"
41 schemaUpdateOptions:
42 - "ALLOW_FIELD_ADDITION"
43 - "ALLOW_FIELD_RELAXATION"
44 scriptOptions:
45 statementTimeoutMs: "300000"
46 keyResultStatement: "LAST"View as plain text