1label: Config Connector BigQueryJob
2markdownDescription: Creates yaml for a BigQueryJob resource
3insertText: |
4 apiVersion: bigquery.cnrm.cloud.google.com/v1beta1
5 kind: BigQueryJob
6 metadata:
7 labels:
8 \${1:label-one}: \${2:value-one}
9 name: \${3:bigqueryjob-name}
10 spec:
11 location: \${4:US}
12 jobTimeoutMs: \${5:600000}
13 query:
14 query: \${6:SELECT state FROM [lookerdata:cdc.project_tycho_reports]}
15 useLegacySql: \${7:true}
16 defaultDataset:
17 datasetRef:
18 name: \${8:bigqueryjobdep1query}
19 destinationTable:
20 tableRef:
21 name: \${9:bigqueryjobdepquery}
22 allowLargeResults: \${10:true}
23 flattenResults: \${11:true}
24 useQueryCache: \${12:true}
25 priority: \${13:INTERACTIVE}
26 writeDisposition: \${14:WRITE_APPEND}
27 schemaUpdateOptions:
28 - \${15:ALLOW_FIELD_ADDITION}
29 - \${16:ALLOW_FIELD_RELAXATION}
30 scriptOptions:
31 statementTimeoutMs: \${17:300000}
32 keyResultStatement: \${18:LAST}
View as plain text