1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
|
// Copyright 2023 Google LLC
//
// Licensed under the Apache License, Version 2.0 (the "License");
// you may not use this file except in compliance with the License.
// You may obtain a copy of the License at
//
// http://www.apache.org/licenses/LICENSE-2.0
//
// Unless required by applicable law or agreed to in writing, software
// distributed under the License is distributed on an "AS IS" BASIS,
// WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
// See the License for the specific language governing permissions and
// limitations under the License.
syntax = "proto3";
package google.cloud.bigquery.storage.v1;
import "google/api/field_behavior.proto";
option csharp_namespace = "Google.Cloud.BigQuery.Storage.V1";
option go_package = "cloud.google.com/go/bigquery/storage/apiv1/storagepb;storagepb";
option java_multiple_files = true;
option java_outer_classname = "TableProto";
option java_package = "com.google.cloud.bigquery.storage.v1";
option php_namespace = "Google\\Cloud\\BigQuery\\Storage\\V1";
// Schema of a table. This schema is a subset of
// google.cloud.bigquery.v2.TableSchema containing information necessary to
// generate valid message to write to BigQuery.
message TableSchema {
// Describes the fields in a table.
repeated TableFieldSchema fields = 1;
}
// TableFieldSchema defines a single field/column within a table schema.
message TableFieldSchema {
enum Type {
// Illegal value
TYPE_UNSPECIFIED = 0;
// 64K, UTF8
STRING = 1;
// 64-bit signed
INT64 = 2;
// 64-bit IEEE floating point
DOUBLE = 3;
// Aggregate type
STRUCT = 4;
// 64K, Binary
BYTES = 5;
// 2-valued
BOOL = 6;
// 64-bit signed usec since UTC epoch
TIMESTAMP = 7;
// Civil date - Year, Month, Day
DATE = 8;
// Civil time - Hour, Minute, Second, Microseconds
TIME = 9;
// Combination of civil date and civil time
DATETIME = 10;
// Geography object
GEOGRAPHY = 11;
// Numeric value
NUMERIC = 12;
// BigNumeric value
BIGNUMERIC = 13;
// Interval
INTERVAL = 14;
// JSON, String
JSON = 15;
}
enum Mode {
// Illegal value
MODE_UNSPECIFIED = 0;
NULLABLE = 1;
REQUIRED = 2;
REPEATED = 3;
}
// Required. The field name. The name must contain only letters (a-z, A-Z),
// numbers (0-9), or underscores (_), and must start with a letter or
// underscore. The maximum length is 128 characters.
string name = 1 [(google.api.field_behavior) = REQUIRED];
// Required. The field data type.
Type type = 2 [(google.api.field_behavior) = REQUIRED];
// Optional. The field mode. The default value is NULLABLE.
Mode mode = 3 [(google.api.field_behavior) = OPTIONAL];
// Optional. Describes the nested schema fields if the type property is set to
// STRUCT.
repeated TableFieldSchema fields = 4 [(google.api.field_behavior) = OPTIONAL];
// Optional. The field description. The maximum length is 1,024 characters.
string description = 6 [(google.api.field_behavior) = OPTIONAL];
// Optional. Maximum length of values of this field for STRINGS or BYTES.
//
// If max_length is not specified, no maximum length constraint is imposed
// on this field.
//
// If type = "STRING", then max_length represents the maximum UTF-8
// length of strings in this field.
//
// If type = "BYTES", then max_length represents the maximum number of
// bytes in this field.
//
// It is invalid to set this field if type is not "STRING" or "BYTES".
int64 max_length = 7 [(google.api.field_behavior) = OPTIONAL];
// Optional. Precision (maximum number of total digits in base 10) and scale
// (maximum number of digits in the fractional part in base 10) constraints
// for values of this field for NUMERIC or BIGNUMERIC.
//
// It is invalid to set precision or scale if type is not "NUMERIC" or
// "BIGNUMERIC".
//
// If precision and scale are not specified, no value range constraint is
// imposed on this field insofar as values are permitted by the type.
//
// Values of this NUMERIC or BIGNUMERIC field must be in this range when:
//
// * Precision (P) and scale (S) are specified:
// [-10^(P-S) + 10^(-S), 10^(P-S) - 10^(-S)]
// * Precision (P) is specified but not scale (and thus scale is
// interpreted to be equal to zero):
// [-10^P + 1, 10^P - 1].
//
// Acceptable values for precision and scale if both are specified:
//
// * If type = "NUMERIC":
// 1 <= precision - scale <= 29 and 0 <= scale <= 9.
// * If type = "BIGNUMERIC":
// 1 <= precision - scale <= 38 and 0 <= scale <= 38.
//
// Acceptable values for precision if only precision is specified but not
// scale (and thus scale is interpreted to be equal to zero):
//
// * If type = "NUMERIC": 1 <= precision <= 29.
// * If type = "BIGNUMERIC": 1 <= precision <= 38.
//
// If scale is specified but not precision, then it is invalid.
int64 precision = 8 [(google.api.field_behavior) = OPTIONAL];
// Optional. See documentation for precision.
int64 scale = 9 [(google.api.field_behavior) = OPTIONAL];
// Optional. A SQL expression to specify the [default value]
// (https://cloud.google.com/bigquery/docs/default-values) for this field.
string default_value_expression = 10 [(google.api.field_behavior) = OPTIONAL];
}
|
