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
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
|
<html><body>
<style>
body, h1, h2, h3, div, span, p, pre, a {
margin: 0;
padding: 0;
border: 0;
font-weight: inherit;
font-style: inherit;
font-size: 100%;
font-family: inherit;
vertical-align: baseline;
}
body {
font-size: 13px;
padding: 1em;
}
h1 {
font-size: 26px;
margin-bottom: 1em;
}
h2 {
font-size: 24px;
margin-bottom: 1em;
}
h3 {
font-size: 20px;
margin-bottom: 1em;
margin-top: 1em;
}
pre, code {
line-height: 1.5;
font-family: Monaco, 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Lucida Console', monospace;
}
pre {
margin-top: 0.5em;
}
h1, h2, h3, p {
font-family: Arial, sans serif;
}
h1, h2, h3 {
border-bottom: solid #CCC 1px;
}
.toc_element {
margin-top: 0.5em;
}
.firstline {
margin-left: 2 em;
}
.method {
margin-top: 1em;
border: solid 1px #CCC;
padding: 1em;
background: #EEE;
}
.details {
font-weight: bold;
font-size: 14px;
}
</style>
<h1><a href="bigquery_v2.html">BigQuery API</a> . <a href="bigquery_v2.tabledata.html">tabledata</a></h1>
<h2>Instance Methods</h2>
<p class="toc_element">
<code><a href="#close">close()</a></code></p>
<p class="firstline">Close httplib2 connections.</p>
<p class="toc_element">
<code><a href="#insertAll">insertAll(projectId, datasetId, tableId, body=None, x__xgafv=None)</a></code></p>
<p class="firstline">Streams data into BigQuery one record at a time without needing to run a load job.</p>
<p class="toc_element">
<code><a href="#list">list(projectId, datasetId, tableId, formatOptions_timestampOutputFormat=None, formatOptions_useInt64Timestamp=None, maxResults=None, pageToken=None, selectedFields=None, startIndex=None, x__xgafv=None)</a></code></p>
<p class="firstline">List the content of a table in rows.</p>
<p class="toc_element">
<code><a href="#list_next">list_next()</a></code></p>
<p class="firstline">Retrieves the next page of results.</p>
<h3>Method Details</h3>
<div class="method">
<code class="details" id="close">close()</code>
<pre>Close httplib2 connections.</pre>
</div>
<div class="method">
<code class="details" id="insertAll">insertAll(projectId, datasetId, tableId, body=None, x__xgafv=None)</code>
<pre>Streams data into BigQuery one record at a time without needing to run a load job.
Args:
projectId: string, Required. Project ID of the destination. (required)
datasetId: string, Required. Dataset ID of the destination. (required)
tableId: string, Required. Table ID of the destination. (required)
body: object, The request body.
The object takes the form of:
{ # Request for sending a single streaming insert.
"ignoreUnknownValues": True or False, # Optional. Accept rows that contain values that do not match the schema. The unknown values are ignored. Default is false, which treats unknown values as errors.
"kind": "bigquery#tableDataInsertAllRequest", # Optional. The resource type of the response. The value is not checked at the backend. Historically, it has been set to "bigquery#tableDataInsertAllRequest" but you are not required to set it.
"rows": [
{ # Data for a single insertion row.
"insertId": "A String", # Insertion ID for best-effort deduplication. This feature is not recommended, and users seeking stronger insertion semantics are encouraged to use other mechanisms such as the BigQuery Write API.
"json": { # Represents a single JSON object. # Data for a single row.
"a_key": "",
},
},
],
"skipInvalidRows": True or False, # Optional. Insert all valid rows of a request, even if invalid rows exist. The default value is false, which causes the entire request to fail if any invalid rows exist.
"templateSuffix": "A String", # Optional. If specified, treats the destination table as a base template, and inserts the rows into an instance table named "{destination}{templateSuffix}". BigQuery will manage creation of the instance table, using the schema of the base template table. See https://cloud.google.com/bigquery/streaming-data-into-bigquery#template-tables for considerations when working with templates tables.
"traceId": "A String", # Optional. Unique request trace id. Used for debugging purposes only. It is case-sensitive, limited to up to 36 ASCII characters. A UUID is recommended.
}
x__xgafv: string, V1 error format.
Allowed values
1 - v1 error format
2 - v2 error format
Returns:
An object of the form:
{ # Describes the format of a streaming insert response.
"insertErrors": [ # Describes specific errors encountered while processing the request.
{ # Error details about a single row's insertion.
"errors": [ # Error information for the row indicated by the index property.
{ # Error details.
"debugInfo": "A String", # Debugging information. This property is internal to Google and should not be used.
"location": "A String", # Specifies where the error occurred, if present.
"message": "A String", # A human-readable description of the error.
"reason": "A String", # A short error code that summarizes the error.
},
],
"index": 42, # The index of the row that error applies to.
},
],
"kind": "bigquery#tableDataInsertAllResponse", # Returns "bigquery#tableDataInsertAllResponse".
}</pre>
</div>
<div class="method">
<code class="details" id="list">list(projectId, datasetId, tableId, formatOptions_timestampOutputFormat=None, formatOptions_useInt64Timestamp=None, maxResults=None, pageToken=None, selectedFields=None, startIndex=None, x__xgafv=None)</code>
<pre>List the content of a table in rows.
Args:
projectId: string, Required. Project id of the table to list. (required)
datasetId: string, Required. Dataset id of the table to list. (required)
tableId: string, Required. Table id of the table to list. (required)
formatOptions_timestampOutputFormat: string, Optional. The API output format for a timestamp. This offers more explicit control over the timestamp output format as compared to the existing `use_int64_timestamp` option.
Allowed values
TIMESTAMP_OUTPUT_FORMAT_UNSPECIFIED - Corresponds to default API output behavior, which is FLOAT64.
FLOAT64 - Timestamp is output as float64 seconds since Unix epoch.
INT64 - Timestamp is output as int64 microseconds since Unix epoch.
ISO8601_STRING - Timestamp is output as ISO 8601 String ("YYYY-MM-DDTHH:MM:SS.FFFFFFFFFFFFZ").
formatOptions_useInt64Timestamp: boolean, Optional. Output timestamp as usec int64. Default is false.
maxResults: integer, Row limit of the table.
pageToken: string, To retrieve the next page of table data, set this field to the string provided in the pageToken field of the response body from your previous call to tabledata.list.
selectedFields: string, Subset of fields to return, supports select into sub fields. Example: selected_fields = "a,e.d.f";
startIndex: string, Start row index of the table.
x__xgafv: string, V1 error format.
Allowed values
1 - v1 error format
2 - v2 error format
Returns:
An object of the form:
{
"etag": "A String", # A hash of this page of results.
"kind": "bigquery#tableDataList", # The resource type of the response.
"pageToken": "A String", # A token used for paging results. Providing this token instead of the startIndex parameter can help you retrieve stable results when an underlying table is changing.
"rows": [ # Rows of results.
{
"f": [ # Represents a single row in the result set, consisting of one or more fields.
{
"v": "",
},
],
},
],
"totalRows": "A String", # Total rows of the entire table. In order to show default value 0 we have to present it as string.
}</pre>
</div>
<div class="method">
<code class="details" id="list_next">list_next()</code>
<pre>Retrieves the next page of results.
Args:
previous_request: The request for the previous page. (required)
previous_response: The response from the request for the previous page. (required)
Returns:
A request object that you can call 'execute()' on to request the next
page. Returns None if there are no more items in the collection.
</pre>
</div>
</body></html>
|
