1---
2apiVersion: apiextensions.k8s.io/v1
3kind: CustomResourceDefinition
4metadata:
5 annotations:
6 controller-gen.kubebuilder.io/version: (unknown)
7 name: bigqueryroutines.bigquery.cnrm.cloud.google.com
8spec:
9 group: bigquery.cnrm.cloud.google.com
10 names:
11 kind: BigQueryRoutine
12 listKind: BigQueryRoutineList
13 plural: bigqueryroutines
14 singular: bigqueryroutine
15 scope: Namespaced
16 versions:
17 - name: v1beta1
18 schema:
19 openAPIV3Schema:
20 description: BigQueryRoutine 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 arguments:
42 description: Input/output argument of a function or a stored procedure.
43 items:
44 properties:
45 argumentKind:
46 description: 'Defaults to FIXED_TYPE. Default value: "FIXED_TYPE"
47 Possible values: ["FIXED_TYPE", "ANY_TYPE"].'
48 type: string
49 dataType:
50 description: |-
51 A JSON schema for the data type. Required unless argumentKind = ANY_TYPE.
52 ~>**NOTE**: Because this field expects a JSON string, any changes to the string
53 will create a diff, even if the JSON itself hasn't changed. If the API returns
54 a different value for the same schema, e.g. it switched the order of values
55 or replaced STRUCT field type with RECORD field type, we currently cannot
56 suppress the recurring diff this causes. As a workaround, we recommend using
57 the schema as returned by the API.
58 type: string
59 mode:
60 description: 'Specifies whether the argument is input or output.
61 Can be set for procedures only. Possible values: ["IN", "OUT",
62 "INOUT"].'
63 type: string
64 name:
65 description: The name of this argument. Can be absent for function
66 return argument.
67 type: string
68 type: object
69 type: array
70 datasetRef:
71 description: The ID of the dataset containing this routine.
72 properties:
73 external:
74 description: The external name of the referenced resource
75 type: string
76 kind:
77 description: Kind of the referent.
78 type: string
79 name:
80 description: 'Name of the referent. More info: https://kubernetes.io/docs/concepts/overview/working-with-objects/names/#names'
81 type: string
82 namespace:
83 description: 'Namespace of the referent. More info: https://kubernetes.io/docs/concepts/overview/working-with-objects/namespaces/'
84 type: string
85 type: object
86 definitionBody:
87 description: |-
88 The body of the routine. For functions, this is the expression in the AS clause.
89 If language=SQL, it is the substring inside (but excluding) the parentheses.
90 type: string
91 description:
92 description: The description of the routine if defined.
93 type: string
94 determinismLevel:
95 description: 'The determinism level of the JavaScript UDF if defined.
96 Possible values: ["DETERMINISM_LEVEL_UNSPECIFIED", "DETERMINISTIC",
97 "NOT_DETERMINISTIC"].'
98 type: string
99 importedLibraries:
100 description: |-
101 Optional. If language = "JAVASCRIPT", this field stores the path of the
102 imported JAVASCRIPT libraries.
103 items:
104 type: string
105 type: array
106 language:
107 description: 'The language of the routine. Possible values: ["SQL",
108 "JAVASCRIPT"].'
109 type: string
110 projectRef:
111 description: The project that this resource belongs to.
112 properties:
113 external:
114 description: The external name of the referenced resource
115 type: string
116 kind:
117 description: Kind of the referent.
118 type: string
119 name:
120 description: 'Name of the referent. More info: https://kubernetes.io/docs/concepts/overview/working-with-objects/names/#names'
121 type: string
122 namespace:
123 description: 'Namespace of the referent. More info: https://kubernetes.io/docs/concepts/overview/working-with-objects/namespaces/'
124 type: string
125 type: object
126 resourceID:
127 description: Immutable. Optional. The routineId of the resource. Used
128 for creation and acquisition. When unset, the value of `metadata.name`
129 is used as the default.
130 type: string
131 returnTableType:
132 description: |-
133 Optional. Can be set only if routineType = "TABLE_VALUED_FUNCTION".
134
135
136 If absent, the return table type is inferred from definitionBody at query time in each query
137 that references this routine. If present, then the columns in the evaluated table result will
138 be cast to match the column types specificed in return table type, at query time.
139 type: string
140 returnType:
141 description: |-
142 A JSON schema for the return type. Optional if language = "SQL"; required otherwise.
143 If absent, the return type is inferred from definitionBody at query time in each query
144 that references this routine. If present, then the evaluated result will be cast to
145 the specified returned type at query time. ~>**NOTE**: Because this field expects a JSON
146 string, any changes to the string will create a diff, even if the JSON itself hasn't
147 changed. If the API returns a different value for the same schema, e.g. it switche
148 d the order of values or replaced STRUCT field type with RECORD field type, we currently
149 cannot suppress the recurring diff this causes. As a workaround, we recommend using
150 the schema as returned by the API.
151 type: string
152 routineType:
153 description: 'Immutable. The type of routine. Possible values: ["SCALAR_FUNCTION",
154 "PROCEDURE", "TABLE_VALUED_FUNCTION"].'
155 type: string
156 required:
157 - datasetRef
158 - definitionBody
159 - projectRef
160 type: object
161 status:
162 properties:
163 conditions:
164 description: |-
165 Conditions represent the latest available observations of the
166 BigQueryRoutine's current state.
167 items:
168 properties:
169 lastTransitionTime:
170 description: Last time the condition transitioned from one status
171 to another.
172 type: string
173 message:
174 description: Human-readable message indicating details about
175 last transition.
176 type: string
177 reason:
178 description: |-
179 Unique, one-word, CamelCase reason for the condition's last
180 transition.
181 type: string
182 status:
183 description: Status is the status of the condition. Can be True,
184 False, Unknown.
185 type: string
186 type:
187 description: Type is the type of the condition.
188 type: string
189 type: object
190 type: array
191 creationTime:
192 description: |-
193 The time when this routine was created, in milliseconds since the
194 epoch.
195 type: integer
196 lastModifiedTime:
197 description: |-
198 The time when this routine was modified, in milliseconds since the
199 epoch.
200 type: integer
201 observedGeneration:
202 description: ObservedGeneration is the generation of the resource
203 that was most recently observed by the Config Connector controller.
204 If this is equal to metadata.generation, then that means that the
205 current reported status reflects the most recent desired state of
206 the resource.
207 type: integer
208 type: object
209 type: object
210 served: true
211 storage: true
View as plain text