API documentation for bigquery.job
package.
The compression type to use for exported files. The default value is NONE
.
DEFLATE
and SNAPPY
are only supported for Avro.
Asynchronous job: copy data into a table from other tables.
CopyJobConfigConfiguration options for copy jobs.
All properties in this class are optional. Values which are :data:None
-> server defaults. Set properties on the constructed configuration by using the property name as the name of a keyword argument.
Specifies whether the job is allowed to create new tables. The default value is CREATE_IF_NEEDED
.
Creation, truncation and append actions occur as one atomic update upon job completion.
DestinationFormatThe exported file format. The default value is CSV
.
Tables with nested or repeated fields cannot be exported as CSV.
DmlStatsDetailed statistics for DML statements.
https://cloud.google.com/bigquery/docs/reference/rest/v2/DmlStats
EncodingThe character encoding of the data. The default is UTF_8
.
BigQuery decodes the data after the raw, binary data has been split using the values of the quote and fieldDelimiter properties.
Asynchronous job: extract data from a table into Cloud Storage.
Configuration options for extract jobs.
All properties in this class are optional. Values which are :data:None
-> server defaults. Set properties on the constructed configuration by using the property name as the name of a keyword argument.
Asynchronous job for loading data into a table.
Can load from Google Cloud Storage URIs or from a file.
LoadJobConfigConfiguration options for load jobs.
Set properties on the constructed configuration by using the property name as the name of a keyword argument. Values which are unset or :data:None
use the BigQuery REST API default values. See the BigQuery REST API reference documentation <https://cloud.google.com/bigquery/docs/reference/rest/v2/Job#JobConfigurationLoad>
_ for a list of default values.
Required options differ based on the source_format value. For example, the BigQuery API's default value for source_format is "CSV"
. When loading a CSV file, either schema must be set or autodetect must be set to :data:True
.
Different operation types supported in table copy job.
https://cloud.google.com/bigquery/docs/reference/rest/v2/Job#operationtype
QueryJobAsynchronous job: query tables.
QueryJobConfigConfiguration options for query jobs.
All properties in this class are optional. Values which are :data:None
-> server defaults. Set properties on the constructed configuration by using the property name as the name of a keyword argument.
QueryPlanEntry represents a single stage of a query execution plan.
See https://cloud.google.com/bigquery/docs/reference/rest/v2/Job#ExplainQueryStage for the underlying API representation within query statistics.
QueryPlanEntryStepMap a single step in a query plan entry.
QueryPrioritySpecifies a priority for the query. The default value is INTERACTIVE
.
Job resource usage for a reservation.
SchemaUpdateOptionSpecifies an update to the destination table schema as a side effect of a load job.
ScriptOptionsOptions controlling the execution of scripts.
https://cloud.google.com/bigquery/docs/reference/rest/v2/Job#ScriptOptions
ScriptStackFrameStack frame showing the line/column/procedure name where the current evaluation happened.
ScriptStatisticsStatistics for a child job of a script.
SourceFormatThe format of the data files. The default value is CSV
.
Note that the set of allowed values for loading data is different than the set used for external data sources (see ExternalSourceFormat).
TimelineEntryTimelineEntry represents progress of a query job at a particular point in time.
See https://cloud.google.com/bigquery/docs/reference/rest/v2/Job#querytimelinesample for the underlying API representation within query statistics.
TransactionInfo[Alpha] Information of a multi-statement transaction.
https://cloud.google.com/bigquery/docs/reference/rest/v2/Job#TransactionInfo
.. versionadded:: 2.24.0
UnknownJobA job whose type cannot be determined.
WriteDispositionSpecifies the action that occurs if destination table already exists.
The default value is WRITE_APPEND
.
Each action is atomic and only occurs if BigQuery is able to complete the job successfully. Creation, truncation and append actions occur as one atomic update upon job completion.
RetroSearch is an open source project built by @garambo | Open a GitHub Issue
Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo
HTML:
3.2
| Encoding:
UTF-8
| Version:
0.7.4