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-load
24spec:
25 location: "US"
26 jobTimeoutMs: "600000"
27 load:
28 sourceUris:
29 - "gs://cloud-samples-data/bigquery/us-states/us-states-by-date.csv"
30 destinationTable:
31 tableRef:
32 name: bigqueryjobdepload
33 sourceFormat: "CSV"
34 encoding: "UTF-8"
35 fieldDelimiter: ","
36 quote: '"'
37 allowQuotedNewlines: false
38 maxBadRecords: 0
39 allowJaggedRows: false
40 ignoreUnknownValues: false
41 skipLeadingRows: 1
42 autodetect: true
43 writeDisposition: "WRITE_APPEND"
44 schemaUpdateOptions:
45 - "ALLOW_FIELD_ADDITION"
46 - "ALLOW_FIELD_RELAXATION"View as plain text