| |
| <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> |
| <html><head><title>Python: class Resource</title> |
| </head><body bgcolor="#f0f0f8"> |
| <p> |
| <table width="100%" cellspacing=0 cellpadding=2 border=0 summary="section"> |
| <tr bgcolor="#ffc8d8"> |
| <td colspan=3 valign=bottom> <br> |
| <font color="#000000" face="helvetica, arial"><a name="Resource">class <strong>Resource</strong></a>(<a href="__builtin__.html#object">__builtin__.object</a>)</font></td></tr> |
| |
| <tr bgcolor="#ffc8d8"><td rowspan=2><tt> </tt></td> |
| <td colspan=2><tt>A class for interacting with a resource.<br> </tt></td></tr> |
| <tr><td> </td> |
| <td width="100%">Methods defined here:<br> |
| <dl><dt><a name="Resource-__init__"><strong>__init__</strong></a>(self)</dt></dl> |
| |
| <dl><dt><a name="Resource-get"><strong>get</strong></a> = method(self, **kwargs)</dt><dd><tt>Retrieves the specified job by ID.<br> |
| <br> |
| Args:<br> |
| pp: string, A parameter<br> |
| trace: string, A parameter<br> |
| projectId: string, Project ID of the requested job (required)<br> |
| jobId: string, Job ID of the requested job (required)<br> |
| strict: string, A parameter<br> |
| userip: string, A parameter<br> |
| <br> |
| Returns:<br> |
| An object of the form<br> |
| <br> |
| {<br> |
| "status": { # [Output-only] The status of this job. Examine this value when polling an asynchronous job to see if the job is complete.<br> |
| "state": "A String", # [Output-only] Running state of the job.<br> |
| "errors": [ # [Output-only] All errors encountered during the running of the job. Errors here do not necessarily mean that the job has completed or was unsuccessful.<br> |
| {<br> |
| "debugInfo": "A String", # Debugging information for the service, if present. Should be ignored.<br> |
| "message": "A String", # A human readable explanation of the error.<br> |
| "reason": "A String", # Specifies the error reason. For example, reason will be "required" or "invalid" if some field was missing or malformed.<br> |
| "location": "A String", # Specifies where the error occurred, if present.<br> |
| },<br> |
| ],<br> |
| "errorResult": { # [Output-only] Final error result of the job. If present, indicates that the job has completed and was unsuccessful.<br> |
| "debugInfo": "A String", # Debugging information for the service, if present. Should be ignored.<br> |
| "message": "A String", # A human readable explanation of the error.<br> |
| "reason": "A String", # Specifies the error reason. For example, reason will be "required" or "invalid" if some field was missing or malformed.<br> |
| "location": "A String", # Specifies where the error occurred, if present.<br> |
| },<br> |
| },<br> |
| "kind": "bigquery#job", # [Output-only] The type of the resource.<br> |
| "statistics": { # [Output-only] Information about the job, including starting time and ending time of the job.<br> |
| "endTime": "A String", # [Output-only] End time of this job, in milliseconds since the epoch.<br> |
| "totalBytesProcessed": "A String", # [Output-only] Total bytes processed for this job.<br> |
| "startTime": "A String", # [Output-only] Start time of this job, in milliseconds since the epoch.<br> |
| },<br> |
| "jobReference": { # [Optional] Reference describing the unique-per-user name of the job.<br> |
| "projectId": "A String", # [Required] Project ID being billed for the job.<br> |
| "jobId": "A String", # [Required] ID of the job.<br> |
| },<br> |
| "etag": "A String", # [Output-only] A hash of this resource.<br> |
| "configuration": { # [Required] Describes the job configuration.<br> |
| "load": { # [Pick one] Configures a load job.<br> |
| "encoding": "A String", # [Optional] Character encoding of the input data. May be UTF-8 or ISO-8859-1. Default is UTF-8.<br> |
| "fieldDelimiter": "A String", # [Optional] Delimiter to use between fields in the import data. Default is ','<br> |
| "destinationTable": { # [Required] Table being written to.<br> |
| "projectId": "A String", # [Required] ID of the project billed for storage of the table.<br> |
| "tableId": "A String", # [Required] ID of the table.<br> |
| "datasetId": "A String", # [Required] ID of the dataset containing the table.<br> |
| },<br> |
| "maxBadRecords": 42, # [Optional] Maximum number of bad records that should be ignored before the entire job is aborted and no updates are performed.<br> |
| "writeDisposition": "A String", # [Optional] Whether to overwrite an existing table (WRITE_TRUNCATE), append to an existing table (WRITE_APPEND), or require that the the table is empty (WRITE_EMPTY). Default is WRITE_APPEND.<br> |
| "sourceUris": [ # [Required] Source URIs describing Google Cloud Storage locations of data to load.<br> |
| "A String",<br> |
| ],<br> |
| "skipLeadingRows": 42, # [Optional] Number of rows of initial data to skip in the data being imported.<br> |
| "createDisposition": "A String", # [Optional] Whether to create the table if it doesn't already exist (CREATE_IF_NEEDED) or to require the table already exist (CREATE_NEVER). Default is CREATE_IF_NEEDED.<br> |
| "schema": { # [Optional] Schema of the table being written to.<br> |
| "fields": [ # Describes the fields in a table.<br> |
| {<br> |
| "fields": [ # [Optional] Describes nested fields when type is RECORD.<br> |
| # Object with schema name: TableFieldSchema<br> |
| ],<br> |
| "type": "A String", # [Required] Data type of the field.<br> |
| "mode": "A String", # [Optional] Mode of the field (whether or not it can be null. Default is NULLABLE.<br> |
| "name": "A String", # [Required] Name of the field.<br> |
| },<br> |
| ],<br> |
| },<br> |
| },<br> |
| "link": { # [Pick one] Configures a link job.<br> |
| "createDisposition": "A String", # [Optional] Whether or not to create a new table, if none exists.<br> |
| "writeDisposition": "A String", # [Optional] Whether to overwrite an existing table (WRITE_TRUNCATE), append to an existing table (WRITE_APPEND), or require that the the table is empty (WRITE_EMPTY). Default is WRITE_APPEND.<br> |
| "destinationTable": { # [Required] The destination table of the link job.<br> |
| "projectId": "A String", # [Required] ID of the project billed for storage of the table.<br> |
| "tableId": "A String", # [Required] ID of the table.<br> |
| "datasetId": "A String", # [Required] ID of the dataset containing the table.<br> |
| },<br> |
| "sourceUri": [ # [Required] URI of source table to link.<br> |
| "A String",<br> |
| ],<br> |
| },<br> |
| "query": { # [Pick one] Configures a query job.<br> |
| "defaultDataset": { # [Optional] Specifies the default dataset to assume for unqualified table names in the query.<br> |
| "projectId": "A String", # [Optional] The ID of the container project.<br> |
| "datasetId": "A String", # [Required] A unique ID for this dataset, without the project name.<br> |
| },<br> |
| "destinationTable": { # [Optional] Describes the table where the query results should be stored. If not present, a new table will be created to store the results.<br> |
| "projectId": "A String", # [Required] ID of the project billed for storage of the table.<br> |
| "tableId": "A String", # [Required] ID of the table.<br> |
| "datasetId": "A String", # [Required] ID of the dataset containing the table.<br> |
| },<br> |
| "priority": "A String", # [Experimental] Specifies a priority for the query. Default is INTERACTIVE. Alternative is BATCH, which may be subject to looser quota restrictions.<br> |
| "writeDisposition": "A String", # [Optional] Whether to overwrite an existing table (WRITE_TRUNCATE), append to an existing table (WRITE_APPEND), or require that the the table is empty (WRITE_EMPTY). Default is WRITE_EMPTY.<br> |
| "createDisposition": "A String", # [Optional] Whether to create the table if it doesn't already exist (CREATE_IF_NEEDED) or to require the table already exist (CREATE_NEVER). Default is CREATE_IF_NEEDED.<br> |
| "query": "A String", # [Required] BigQuery SQL query to execute.<br> |
| },<br> |
| "copy": { # [Pick one] Copies a table.<br> |
| "createDisposition": "A String", # [Optional] Whether or not to create a new table, if none exists.<br> |
| "writeDisposition": "A String", # [Optional] Whether or not to append or require the table to be empty.<br> |
| "destinationTable": { # [Required] The destination table<br> |
| "projectId": "A String", # [Required] ID of the project billed for storage of the table.<br> |
| "tableId": "A String", # [Required] ID of the table.<br> |
| "datasetId": "A String", # [Required] ID of the dataset containing the table.<br> |
| },<br> |
| "sourceTable": { # [Required] Source table to copy.<br> |
| "projectId": "A String", # [Required] ID of the project billed for storage of the table.<br> |
| "tableId": "A String", # [Required] ID of the table.<br> |
| "datasetId": "A String", # [Required] ID of the dataset containing the table.<br> |
| },<br> |
| },<br> |
| "extract": { # [Pick one] Configures an extract job.<br> |
| "destinationUri": "A String", # [Required] The fully-qualified Google Cloud Storage URI where the extracted table should be written.<br> |
| "fieldDelimiter": "A String", # [Optional] Delimiter to use between fields in the exported data. Default is ','<br> |
| "sourceTable": { # [Required] A reference to the table being exported.<br> |
| "projectId": "A String", # [Required] ID of the project billed for storage of the table.<br> |
| "tableId": "A String", # [Required] ID of the table.<br> |
| "datasetId": "A String", # [Required] ID of the dataset containing the table.<br> |
| },<br> |
| "printHeader": True or False, # [Optional] Whether to print out a heder row in the results. Default is true.<br> |
| },<br> |
| "properties": { # [Optional] Properties providing extra details about how the job should be run. Not used for most jobs.<br> |
| },<br> |
| },<br> |
| "id": "A String", # [Output-only] Opaque ID field of the job<br> |
| "selfLink": "A String", # [Output-only] A URL that can be used to access this resource again.<br> |
| }</tt></dd></dl> |
| |
| <dl><dt><a name="Resource-getQueryResults"><strong>getQueryResults</strong></a> = method(self, **kwargs)</dt><dd><tt>Retrieves the results of a query job.<br> |
| <br> |
| Args:<br> |
| timeoutMs: integer, How long to wait for the query to complete, in milliseconds, before returning. Default is to return immediately. If the timeout passes before the job completes, the request will fail with a TIMEOUT error<br> |
| pp: string, A parameter<br> |
| trace: string, A parameter<br> |
| projectId: string, Project ID of the query job (required)<br> |
| maxResults: integer, Maximum number of results to read<br> |
| jobId: string, Job ID of the query job (required)<br> |
| strict: string, A parameter<br> |
| startIndex: string, Zero-based index of the starting row<br> |
| userip: string, A parameter<br> |
| <br> |
| Returns:<br> |
| An object of the form<br> |
| <br> |
| {<br> |
| "kind": "bigquery#getQueryResultsResponse", # The resource type of the response.<br> |
| "rows": [ # An object with as many results as can be contained within the maximum permitted reply size. To get any additional rows, you can call GetQueryResults and specify the jobReference returned above. Present only when the query completes successfully.<br> |
| {<br> |
| "f": [ # Represents a single row in the result set, consisting of one or more fields.<br> |
| {<br> |
| "v": "A String", # Contains the field value in this row, as a string.<br> |
| },<br> |
| ],<br> |
| },<br> |
| ],<br> |
| "jobReference": { # Reference to the Helix Job that was created to run the query. This field will be present even if the original request timed out, in which case GetQueryResults can be used to read the results once the query has completed. Since this API only returns the first page of results, subsequent pages can be fetched via the same mechanism (GetQueryResults).<br> |
| "projectId": "A String", # [Required] Project ID being billed for the job.<br> |
| "jobId": "A String", # [Required] ID of the job.<br> |
| },<br> |
| "jobComplete": True or False, # Whether the query has completed or not. If rows or totalRows are present, this will always be true. If this is false, totalRows will not be available.<br> |
| "totalRows": "A String", # The total number of rows in the complete query result set, which can be more than the number of rows in this single page of results. Present only when the query completes successfully.<br> |
| "etag": "A String", # A hash of this response.<br> |
| "schema": { # The schema of the results. Present only when the query completes successfully.<br> |
| "fields": [ # Describes the fields in a table.<br> |
| {<br> |
| "fields": [ # [Optional] Describes nested fields when type is RECORD.<br> |
| # Object with schema name: TableFieldSchema<br> |
| ],<br> |
| "type": "A String", # [Required] Data type of the field.<br> |
| "mode": "A String", # [Optional] Mode of the field (whether or not it can be null. Default is NULLABLE.<br> |
| "name": "A String", # [Required] Name of the field.<br> |
| },<br> |
| ],<br> |
| },<br> |
| }</tt></dd></dl> |
| |
| <dl><dt><a name="Resource-insert"><strong>insert</strong></a> = method(self, **kwargs)</dt><dd><tt>Starts a new asynchronous job.<br> |
| <br> |
| Args:<br> |
| body: object, The request body.<br> |
| The object takes the form of:<br> |
| <br> |
| {<br> |
| "status": { # [Output-only] The status of this job. Examine this value when polling an asynchronous job to see if the job is complete.<br> |
| "state": "A String", # [Output-only] Running state of the job.<br> |
| "errors": [ # [Output-only] All errors encountered during the running of the job. Errors here do not necessarily mean that the job has completed or was unsuccessful.<br> |
| {<br> |
| "debugInfo": "A String", # Debugging information for the service, if present. Should be ignored.<br> |
| "message": "A String", # A human readable explanation of the error.<br> |
| "reason": "A String", # Specifies the error reason. For example, reason will be "required" or "invalid" if some field was missing or malformed.<br> |
| "location": "A String", # Specifies where the error occurred, if present.<br> |
| },<br> |
| ],<br> |
| "errorResult": { # [Output-only] Final error result of the job. If present, indicates that the job has completed and was unsuccessful.<br> |
| "debugInfo": "A String", # Debugging information for the service, if present. Should be ignored.<br> |
| "message": "A String", # A human readable explanation of the error.<br> |
| "reason": "A String", # Specifies the error reason. For example, reason will be "required" or "invalid" if some field was missing or malformed.<br> |
| "location": "A String", # Specifies where the error occurred, if present.<br> |
| },<br> |
| },<br> |
| "kind": "bigquery#job", # [Output-only] The type of the resource.<br> |
| "statistics": { # [Output-only] Information about the job, including starting time and ending time of the job.<br> |
| "endTime": "A String", # [Output-only] End time of this job, in milliseconds since the epoch.<br> |
| "totalBytesProcessed": "A String", # [Output-only] Total bytes processed for this job.<br> |
| "startTime": "A String", # [Output-only] Start time of this job, in milliseconds since the epoch.<br> |
| },<br> |
| "jobReference": { # [Optional] Reference describing the unique-per-user name of the job.<br> |
| "projectId": "A String", # [Required] Project ID being billed for the job.<br> |
| "jobId": "A String", # [Required] ID of the job.<br> |
| },<br> |
| "etag": "A String", # [Output-only] A hash of this resource.<br> |
| "configuration": { # [Required] Describes the job configuration.<br> |
| "load": { # [Pick one] Configures a load job.<br> |
| "encoding": "A String", # [Optional] Character encoding of the input data. May be UTF-8 or ISO-8859-1. Default is UTF-8.<br> |
| "fieldDelimiter": "A String", # [Optional] Delimiter to use between fields in the import data. Default is ','<br> |
| "destinationTable": { # [Required] Table being written to.<br> |
| "projectId": "A String", # [Required] ID of the project billed for storage of the table.<br> |
| "tableId": "A String", # [Required] ID of the table.<br> |
| "datasetId": "A String", # [Required] ID of the dataset containing the table.<br> |
| },<br> |
| "maxBadRecords": 42, # [Optional] Maximum number of bad records that should be ignored before the entire job is aborted and no updates are performed.<br> |
| "writeDisposition": "A String", # [Optional] Whether to overwrite an existing table (WRITE_TRUNCATE), append to an existing table (WRITE_APPEND), or require that the the table is empty (WRITE_EMPTY). Default is WRITE_APPEND.<br> |
| "sourceUris": [ # [Required] Source URIs describing Google Cloud Storage locations of data to load.<br> |
| "A String",<br> |
| ],<br> |
| "skipLeadingRows": 42, # [Optional] Number of rows of initial data to skip in the data being imported.<br> |
| "createDisposition": "A String", # [Optional] Whether to create the table if it doesn't already exist (CREATE_IF_NEEDED) or to require the table already exist (CREATE_NEVER). Default is CREATE_IF_NEEDED.<br> |
| "schema": { # [Optional] Schema of the table being written to.<br> |
| "fields": [ # Describes the fields in a table.<br> |
| {<br> |
| "fields": [ # [Optional] Describes nested fields when type is RECORD.<br> |
| # Object with schema name: TableFieldSchema<br> |
| ],<br> |
| "type": "A String", # [Required] Data type of the field.<br> |
| "mode": "A String", # [Optional] Mode of the field (whether or not it can be null. Default is NULLABLE.<br> |
| "name": "A String", # [Required] Name of the field.<br> |
| },<br> |
| ],<br> |
| },<br> |
| },<br> |
| "link": { # [Pick one] Configures a link job.<br> |
| "createDisposition": "A String", # [Optional] Whether or not to create a new table, if none exists.<br> |
| "writeDisposition": "A String", # [Optional] Whether to overwrite an existing table (WRITE_TRUNCATE), append to an existing table (WRITE_APPEND), or require that the the table is empty (WRITE_EMPTY). Default is WRITE_APPEND.<br> |
| "destinationTable": { # [Required] The destination table of the link job.<br> |
| "projectId": "A String", # [Required] ID of the project billed for storage of the table.<br> |
| "tableId": "A String", # [Required] ID of the table.<br> |
| "datasetId": "A String", # [Required] ID of the dataset containing the table.<br> |
| },<br> |
| "sourceUri": [ # [Required] URI of source table to link.<br> |
| "A String",<br> |
| ],<br> |
| },<br> |
| "query": { # [Pick one] Configures a query job.<br> |
| "defaultDataset": { # [Optional] Specifies the default dataset to assume for unqualified table names in the query.<br> |
| "projectId": "A String", # [Optional] The ID of the container project.<br> |
| "datasetId": "A String", # [Required] A unique ID for this dataset, without the project name.<br> |
| },<br> |
| "destinationTable": { # [Optional] Describes the table where the query results should be stored. If not present, a new table will be created to store the results.<br> |
| "projectId": "A String", # [Required] ID of the project billed for storage of the table.<br> |
| "tableId": "A String", # [Required] ID of the table.<br> |
| "datasetId": "A String", # [Required] ID of the dataset containing the table.<br> |
| },<br> |
| "priority": "A String", # [Experimental] Specifies a priority for the query. Default is INTERACTIVE. Alternative is BATCH, which may be subject to looser quota restrictions.<br> |
| "writeDisposition": "A String", # [Optional] Whether to overwrite an existing table (WRITE_TRUNCATE), append to an existing table (WRITE_APPEND), or require that the the table is empty (WRITE_EMPTY). Default is WRITE_EMPTY.<br> |
| "createDisposition": "A String", # [Optional] Whether to create the table if it doesn't already exist (CREATE_IF_NEEDED) or to require the table already exist (CREATE_NEVER). Default is CREATE_IF_NEEDED.<br> |
| "query": "A String", # [Required] BigQuery SQL query to execute.<br> |
| },<br> |
| "copy": { # [Pick one] Copies a table.<br> |
| "createDisposition": "A String", # [Optional] Whether or not to create a new table, if none exists.<br> |
| "writeDisposition": "A String", # [Optional] Whether or not to append or require the table to be empty.<br> |
| "destinationTable": { # [Required] The destination table<br> |
| "projectId": "A String", # [Required] ID of the project billed for storage of the table.<br> |
| "tableId": "A String", # [Required] ID of the table.<br> |
| "datasetId": "A String", # [Required] ID of the dataset containing the table.<br> |
| },<br> |
| "sourceTable": { # [Required] Source table to copy.<br> |
| "projectId": "A String", # [Required] ID of the project billed for storage of the table.<br> |
| "tableId": "A String", # [Required] ID of the table.<br> |
| "datasetId": "A String", # [Required] ID of the dataset containing the table.<br> |
| },<br> |
| },<br> |
| "extract": { # [Pick one] Configures an extract job.<br> |
| "destinationUri": "A String", # [Required] The fully-qualified Google Cloud Storage URI where the extracted table should be written.<br> |
| "fieldDelimiter": "A String", # [Optional] Delimiter to use between fields in the exported data. Default is ','<br> |
| "sourceTable": { # [Required] A reference to the table being exported.<br> |
| "projectId": "A String", # [Required] ID of the project billed for storage of the table.<br> |
| "tableId": "A String", # [Required] ID of the table.<br> |
| "datasetId": "A String", # [Required] ID of the dataset containing the table.<br> |
| },<br> |
| "printHeader": True or False, # [Optional] Whether to print out a heder row in the results. Default is true.<br> |
| },<br> |
| "properties": { # [Optional] Properties providing extra details about how the job should be run. Not used for most jobs.<br> |
| },<br> |
| },<br> |
| "id": "A String", # [Output-only] Opaque ID field of the job<br> |
| "selfLink": "A String", # [Output-only] A URL that can be used to access this resource again.<br> |
| }<br> |
| <br> |
| media_body: string, The filename of the media request body.<br> |
| pp: string, A parameter<br> |
| trace: string, A parameter<br> |
| projectId: string, Project ID of the project that will be billed for the job (required)<br> |
| strict: string, A parameter<br> |
| userip: string, A parameter<br> |
| <br> |
| Returns:<br> |
| An object of the form<br> |
| <br> |
| {<br> |
| "status": { # [Output-only] The status of this job. Examine this value when polling an asynchronous job to see if the job is complete.<br> |
| "state": "A String", # [Output-only] Running state of the job.<br> |
| "errors": [ # [Output-only] All errors encountered during the running of the job. Errors here do not necessarily mean that the job has completed or was unsuccessful.<br> |
| {<br> |
| "debugInfo": "A String", # Debugging information for the service, if present. Should be ignored.<br> |
| "message": "A String", # A human readable explanation of the error.<br> |
| "reason": "A String", # Specifies the error reason. For example, reason will be "required" or "invalid" if some field was missing or malformed.<br> |
| "location": "A String", # Specifies where the error occurred, if present.<br> |
| },<br> |
| ],<br> |
| "errorResult": { # [Output-only] Final error result of the job. If present, indicates that the job has completed and was unsuccessful.<br> |
| "debugInfo": "A String", # Debugging information for the service, if present. Should be ignored.<br> |
| "message": "A String", # A human readable explanation of the error.<br> |
| "reason": "A String", # Specifies the error reason. For example, reason will be "required" or "invalid" if some field was missing or malformed.<br> |
| "location": "A String", # Specifies where the error occurred, if present.<br> |
| },<br> |
| },<br> |
| "kind": "bigquery#job", # [Output-only] The type of the resource.<br> |
| "statistics": { # [Output-only] Information about the job, including starting time and ending time of the job.<br> |
| "endTime": "A String", # [Output-only] End time of this job, in milliseconds since the epoch.<br> |
| "totalBytesProcessed": "A String", # [Output-only] Total bytes processed for this job.<br> |
| "startTime": "A String", # [Output-only] Start time of this job, in milliseconds since the epoch.<br> |
| },<br> |
| "jobReference": { # [Optional] Reference describing the unique-per-user name of the job.<br> |
| "projectId": "A String", # [Required] Project ID being billed for the job.<br> |
| "jobId": "A String", # [Required] ID of the job.<br> |
| },<br> |
| "etag": "A String", # [Output-only] A hash of this resource.<br> |
| "configuration": { # [Required] Describes the job configuration.<br> |
| "load": { # [Pick one] Configures a load job.<br> |
| "encoding": "A String", # [Optional] Character encoding of the input data. May be UTF-8 or ISO-8859-1. Default is UTF-8.<br> |
| "fieldDelimiter": "A String", # [Optional] Delimiter to use between fields in the import data. Default is ','<br> |
| "destinationTable": { # [Required] Table being written to.<br> |
| "projectId": "A String", # [Required] ID of the project billed for storage of the table.<br> |
| "tableId": "A String", # [Required] ID of the table.<br> |
| "datasetId": "A String", # [Required] ID of the dataset containing the table.<br> |
| },<br> |
| "maxBadRecords": 42, # [Optional] Maximum number of bad records that should be ignored before the entire job is aborted and no updates are performed.<br> |
| "writeDisposition": "A String", # [Optional] Whether to overwrite an existing table (WRITE_TRUNCATE), append to an existing table (WRITE_APPEND), or require that the the table is empty (WRITE_EMPTY). Default is WRITE_APPEND.<br> |
| "sourceUris": [ # [Required] Source URIs describing Google Cloud Storage locations of data to load.<br> |
| "A String",<br> |
| ],<br> |
| "skipLeadingRows": 42, # [Optional] Number of rows of initial data to skip in the data being imported.<br> |
| "createDisposition": "A String", # [Optional] Whether to create the table if it doesn't already exist (CREATE_IF_NEEDED) or to require the table already exist (CREATE_NEVER). Default is CREATE_IF_NEEDED.<br> |
| "schema": { # [Optional] Schema of the table being written to.<br> |
| "fields": [ # Describes the fields in a table.<br> |
| {<br> |
| "fields": [ # [Optional] Describes nested fields when type is RECORD.<br> |
| # Object with schema name: TableFieldSchema<br> |
| ],<br> |
| "type": "A String", # [Required] Data type of the field.<br> |
| "mode": "A String", # [Optional] Mode of the field (whether or not it can be null. Default is NULLABLE.<br> |
| "name": "A String", # [Required] Name of the field.<br> |
| },<br> |
| ],<br> |
| },<br> |
| },<br> |
| "link": { # [Pick one] Configures a link job.<br> |
| "createDisposition": "A String", # [Optional] Whether or not to create a new table, if none exists.<br> |
| "writeDisposition": "A String", # [Optional] Whether to overwrite an existing table (WRITE_TRUNCATE), append to an existing table (WRITE_APPEND), or require that the the table is empty (WRITE_EMPTY). Default is WRITE_APPEND.<br> |
| "destinationTable": { # [Required] The destination table of the link job.<br> |
| "projectId": "A String", # [Required] ID of the project billed for storage of the table.<br> |
| "tableId": "A String", # [Required] ID of the table.<br> |
| "datasetId": "A String", # [Required] ID of the dataset containing the table.<br> |
| },<br> |
| "sourceUri": [ # [Required] URI of source table to link.<br> |
| "A String",<br> |
| ],<br> |
| },<br> |
| "query": { # [Pick one] Configures a query job.<br> |
| "defaultDataset": { # [Optional] Specifies the default dataset to assume for unqualified table names in the query.<br> |
| "projectId": "A String", # [Optional] The ID of the container project.<br> |
| "datasetId": "A String", # [Required] A unique ID for this dataset, without the project name.<br> |
| },<br> |
| "destinationTable": { # [Optional] Describes the table where the query results should be stored. If not present, a new table will be created to store the results.<br> |
| "projectId": "A String", # [Required] ID of the project billed for storage of the table.<br> |
| "tableId": "A String", # [Required] ID of the table.<br> |
| "datasetId": "A String", # [Required] ID of the dataset containing the table.<br> |
| },<br> |
| "priority": "A String", # [Experimental] Specifies a priority for the query. Default is INTERACTIVE. Alternative is BATCH, which may be subject to looser quota restrictions.<br> |
| "writeDisposition": "A String", # [Optional] Whether to overwrite an existing table (WRITE_TRUNCATE), append to an existing table (WRITE_APPEND), or require that the the table is empty (WRITE_EMPTY). Default is WRITE_EMPTY.<br> |
| "createDisposition": "A String", # [Optional] Whether to create the table if it doesn't already exist (CREATE_IF_NEEDED) or to require the table already exist (CREATE_NEVER). Default is CREATE_IF_NEEDED.<br> |
| "query": "A String", # [Required] BigQuery SQL query to execute.<br> |
| },<br> |
| "copy": { # [Pick one] Copies a table.<br> |
| "createDisposition": "A String", # [Optional] Whether or not to create a new table, if none exists.<br> |
| "writeDisposition": "A String", # [Optional] Whether or not to append or require the table to be empty.<br> |
| "destinationTable": { # [Required] The destination table<br> |
| "projectId": "A String", # [Required] ID of the project billed for storage of the table.<br> |
| "tableId": "A String", # [Required] ID of the table.<br> |
| "datasetId": "A String", # [Required] ID of the dataset containing the table.<br> |
| },<br> |
| "sourceTable": { # [Required] Source table to copy.<br> |
| "projectId": "A String", # [Required] ID of the project billed for storage of the table.<br> |
| "tableId": "A String", # [Required] ID of the table.<br> |
| "datasetId": "A String", # [Required] ID of the dataset containing the table.<br> |
| },<br> |
| },<br> |
| "extract": { # [Pick one] Configures an extract job.<br> |
| "destinationUri": "A String", # [Required] The fully-qualified Google Cloud Storage URI where the extracted table should be written.<br> |
| "fieldDelimiter": "A String", # [Optional] Delimiter to use between fields in the exported data. Default is ','<br> |
| "sourceTable": { # [Required] A reference to the table being exported.<br> |
| "projectId": "A String", # [Required] ID of the project billed for storage of the table.<br> |
| "tableId": "A String", # [Required] ID of the table.<br> |
| "datasetId": "A String", # [Required] ID of the dataset containing the table.<br> |
| },<br> |
| "printHeader": True or False, # [Optional] Whether to print out a heder row in the results. Default is true.<br> |
| },<br> |
| "properties": { # [Optional] Properties providing extra details about how the job should be run. Not used for most jobs.<br> |
| },<br> |
| },<br> |
| "id": "A String", # [Output-only] Opaque ID field of the job<br> |
| "selfLink": "A String", # [Output-only] A URL that can be used to access this resource again.<br> |
| }</tt></dd></dl> |
| |
| <dl><dt><a name="Resource-list"><strong>list</strong></a> = method(self, **kwargs)</dt><dd><tt>Lists all the Jobs in the specified project that were started by the user.<br> |
| <br> |
| Args:<br> |
| pp: string, A parameter<br> |
| projection: string, Restrict information returned to a set of selected fields<br> |
| Allowed values<br> |
| full - Includes all job data<br> |
| minimal - Does not include the job configuration<br> |
| stateFilter: string, Filter for job state (repeated)<br> |
| Allowed values<br> |
| done - Finished jobs<br> |
| pending - Pending jobs<br> |
| running - Running jobs<br> |
| pageToken: string, Page token, returned by a previous call, to request the next page of results<br> |
| projectId: string, Project ID of the jobs to list (required)<br> |
| allUsers: boolean, Whether to display jobs owned by all users in the project. Default false<br> |
| maxResults: integer, Maximum number of results to return<br> |
| strict: string, A parameter<br> |
| userip: string, A parameter<br> |
| trace: string, A parameter<br> |
| <br> |
| Returns:<br> |
| An object of the form<br> |
| <br> |
| {<br> |
| "nextPageToken": "A String", # A token to request the next page of results.<br> |
| "totalItems": 42, # Total number of jobs in this collection.<br> |
| "kind": "bigquery#jobList", # The resource type of the response.<br> |
| "etag": "A String", # A hash of this page of results.<br> |
| "jobs": [ # List of jobs that were requested.<br> |
| {<br> |
| "status": { # [Full-projection-only] Describes the state of the job.<br> |
| "state": "A String", # [Output-only] Running state of the job.<br> |
| "errors": [ # [Output-only] All errors encountered during the running of the job. Errors here do not necessarily mean that the job has completed or was unsuccessful.<br> |
| {<br> |
| "debugInfo": "A String", # Debugging information for the service, if present. Should be ignored.<br> |
| "message": "A String", # A human readable explanation of the error.<br> |
| "reason": "A String", # Specifies the error reason. For example, reason will be "required" or "invalid" if some field was missing or malformed.<br> |
| "location": "A String", # Specifies where the error occurred, if present.<br> |
| },<br> |
| ],<br> |
| "errorResult": { # [Output-only] Final error result of the job. If present, indicates that the job has completed and was unsuccessful.<br> |
| "debugInfo": "A String", # Debugging information for the service, if present. Should be ignored.<br> |
| "message": "A String", # A human readable explanation of the error.<br> |
| "reason": "A String", # Specifies the error reason. For example, reason will be "required" or "invalid" if some field was missing or malformed.<br> |
| "location": "A String", # Specifies where the error occurred, if present.<br> |
| },<br> |
| },<br> |
| "kind": "bigquery#job", # The resource type.<br> |
| "statistics": { # [Output-only] Information about the job, including starting time and ending time of the job.<br> |
| "endTime": "A String", # [Output-only] End time of this job, in milliseconds since the epoch.<br> |
| "totalBytesProcessed": "A String", # [Output-only] Total bytes processed for this job.<br> |
| "startTime": "A String", # [Output-only] Start time of this job, in milliseconds since the epoch.<br> |
| },<br> |
| "jobReference": { # Job reference uniquely identifying the job.<br> |
| "projectId": "A String", # [Required] Project ID being billed for the job.<br> |
| "jobId": "A String", # [Required] ID of the job.<br> |
| },<br> |
| "state": "A String", # Running state of the job. When the state is DONE, errorResult can be checked to determine whether the job succeeded or failed.<br> |
| "configuration": { # [Full-projection-only] Specifies the job configuration.<br> |
| "load": { # [Pick one] Configures a load job.<br> |
| "encoding": "A String", # [Optional] Character encoding of the input data. May be UTF-8 or ISO-8859-1. Default is UTF-8.<br> |
| "fieldDelimiter": "A String", # [Optional] Delimiter to use between fields in the import data. Default is ','<br> |
| "destinationTable": { # [Required] Table being written to.<br> |
| "projectId": "A String", # [Required] ID of the project billed for storage of the table.<br> |
| "tableId": "A String", # [Required] ID of the table.<br> |
| "datasetId": "A String", # [Required] ID of the dataset containing the table.<br> |
| },<br> |
| "maxBadRecords": 42, # [Optional] Maximum number of bad records that should be ignored before the entire job is aborted and no updates are performed.<br> |
| "writeDisposition": "A String", # [Optional] Whether to overwrite an existing table (WRITE_TRUNCATE), append to an existing table (WRITE_APPEND), or require that the the table is empty (WRITE_EMPTY). Default is WRITE_APPEND.<br> |
| "sourceUris": [ # [Required] Source URIs describing Google Cloud Storage locations of data to load.<br> |
| "A String",<br> |
| ],<br> |
| "skipLeadingRows": 42, # [Optional] Number of rows of initial data to skip in the data being imported.<br> |
| "createDisposition": "A String", # [Optional] Whether to create the table if it doesn't already exist (CREATE_IF_NEEDED) or to require the table already exist (CREATE_NEVER). Default is CREATE_IF_NEEDED.<br> |
| "schema": { # [Optional] Schema of the table being written to.<br> |
| "fields": [ # Describes the fields in a table.<br> |
| {<br> |
| "fields": [ # [Optional] Describes nested fields when type is RECORD.<br> |
| # Object with schema name: TableFieldSchema<br> |
| ],<br> |
| "type": "A String", # [Required] Data type of the field.<br> |
| "mode": "A String", # [Optional] Mode of the field (whether or not it can be null. Default is NULLABLE.<br> |
| "name": "A String", # [Required] Name of the field.<br> |
| },<br> |
| ],<br> |
| },<br> |
| },<br> |
| "link": { # [Pick one] Configures a link job.<br> |
| "createDisposition": "A String", # [Optional] Whether or not to create a new table, if none exists.<br> |
| "writeDisposition": "A String", # [Optional] Whether to overwrite an existing table (WRITE_TRUNCATE), append to an existing table (WRITE_APPEND), or require that the the table is empty (WRITE_EMPTY). Default is WRITE_APPEND.<br> |
| "destinationTable": { # [Required] The destination table of the link job.<br> |
| "projectId": "A String", # [Required] ID of the project billed for storage of the table.<br> |
| "tableId": "A String", # [Required] ID of the table.<br> |
| "datasetId": "A String", # [Required] ID of the dataset containing the table.<br> |
| },<br> |
| "sourceUri": [ # [Required] URI of source table to link.<br> |
| "A String",<br> |
| ],<br> |
| },<br> |
| "query": { # [Pick one] Configures a query job.<br> |
| "defaultDataset": { # [Optional] Specifies the default dataset to assume for unqualified table names in the query.<br> |
| "projectId": "A String", # [Optional] The ID of the container project.<br> |
| "datasetId": "A String", # [Required] A unique ID for this dataset, without the project name.<br> |
| },<br> |
| "destinationTable": { # [Optional] Describes the table where the query results should be stored. If not present, a new table will be created to store the results.<br> |
| "projectId": "A String", # [Required] ID of the project billed for storage of the table.<br> |
| "tableId": "A String", # [Required] ID of the table.<br> |
| "datasetId": "A String", # [Required] ID of the dataset containing the table.<br> |
| },<br> |
| "priority": "A String", # [Experimental] Specifies a priority for the query. Default is INTERACTIVE. Alternative is BATCH, which may be subject to looser quota restrictions.<br> |
| "writeDisposition": "A String", # [Optional] Whether to overwrite an existing table (WRITE_TRUNCATE), append to an existing table (WRITE_APPEND), or require that the the table is empty (WRITE_EMPTY). Default is WRITE_EMPTY.<br> |
| "createDisposition": "A String", # [Optional] Whether to create the table if it doesn't already exist (CREATE_IF_NEEDED) or to require the table already exist (CREATE_NEVER). Default is CREATE_IF_NEEDED.<br> |
| "query": "A String", # [Required] BigQuery SQL query to execute.<br> |
| },<br> |
| "copy": { # [Pick one] Copies a table.<br> |
| "createDisposition": "A String", # [Optional] Whether or not to create a new table, if none exists.<br> |
| "writeDisposition": "A String", # [Optional] Whether or not to append or require the table to be empty.<br> |
| "destinationTable": { # [Required] The destination table<br> |
| "projectId": "A String", # [Required] ID of the project billed for storage of the table.<br> |
| "tableId": "A String", # [Required] ID of the table.<br> |
| "datasetId": "A String", # [Required] ID of the dataset containing the table.<br> |
| },<br> |
| "sourceTable": { # [Required] Source table to copy.<br> |
| "projectId": "A String", # [Required] ID of the project billed for storage of the table.<br> |
| "tableId": "A String", # [Required] ID of the table.<br> |
| "datasetId": "A String", # [Required] ID of the dataset containing the table.<br> |
| },<br> |
| },<br> |
| "extract": { # [Pick one] Configures an extract job.<br> |
| "destinationUri": "A String", # [Required] The fully-qualified Google Cloud Storage URI where the extracted table should be written.<br> |
| "fieldDelimiter": "A String", # [Optional] Delimiter to use between fields in the exported data. Default is ','<br> |
| "sourceTable": { # [Required] A reference to the table being exported.<br> |
| "projectId": "A String", # [Required] ID of the project billed for storage of the table.<br> |
| "tableId": "A String", # [Required] ID of the table.<br> |
| "datasetId": "A String", # [Required] ID of the dataset containing the table.<br> |
| },<br> |
| "printHeader": True or False, # [Optional] Whether to print out a heder row in the results. Default is true.<br> |
| },<br> |
| "properties": { # [Optional] Properties providing extra details about how the job should be run. Not used for most jobs.<br> |
| },<br> |
| },<br> |
| "id": "A String", # Unique opaque ID of the job.<br> |
| "errorResult": { # A result object that will be present only if the job has failed.<br> |
| "debugInfo": "A String", # Debugging information for the service, if present. Should be ignored.<br> |
| "message": "A String", # A human readable explanation of the error.<br> |
| "reason": "A String", # Specifies the error reason. For example, reason will be "required" or "invalid" if some field was missing or malformed.<br> |
| "location": "A String", # Specifies where the error occurred, if present.<br> |
| },<br> |
| },<br> |
| ],<br> |
| }</tt></dd></dl> |
| |
| <dl><dt><a name="Resource-list_next"><strong>list_next</strong></a> = methodNext(self, previous_request, previous_response)</dt><dd><tt>Retrieves the next page of results.<br> |
| <br> |
| Args:<br> |
| previous_request: The request for the previous page.<br> |
| previous_response: The response from the request for the previous page.<br> |
| <br> |
| Returns:<br> |
| A request object that you can call 'execute()' on to request the next<br> |
| page. Returns None if there are no more items in the collection.</tt></dd></dl> |
| |
| <dl><dt><a name="Resource-query"><strong>query</strong></a> = method(self, **kwargs)</dt><dd><tt>Runs a BigQuery SQL query synchronously and returns query results if the query completes within a specified timeout.<br> |
| <br> |
| Args:<br> |
| body: object, The request body. (required)<br> |
| The object takes the form of:<br> |
| <br> |
| {<br> |
| "timeoutMs": 42, # [Optional] How long to wait for the query to complete, in milliseconds, before returning. Default is to return immediately. If the timeout passes before the job completes, the request will fail with a TIMEOUT error.<br> |
| "query": "A String", # [Required] A query string, following the BigQuery query syntax of the query to execute. Table names should be qualified by dataset name in the format projectId:datasetId.tableId unless you specify the defaultDataset value. If the table is in the same project as the job, you can omit the project ID. Example: SELECT f1 FROM myProjectId:myDatasetId.myTableId.<br> |
| "kind": "bigquery#queryRequest", # The resource type of the request.<br> |
| "maxResults": 42, # [Optional] The maximum number of results to return per page of results. If the response list exceeds the maximum response size for a single response, you will have to page through the results. Default is to return the maximum response size.<br> |
| "defaultDataset": { # [Optional] Specifies the default datasetId and projectId to assume for any unqualified table names in the query. If not set, all table names in the query string must be fully-qualified in the format projectId:datasetId.tableid.<br> |
| "projectId": "A String", # [Optional] The ID of the container project.<br> |
| "datasetId": "A String", # [Required] A unique ID for this dataset, without the project name.<br> |
| },<br> |
| }<br> |
| <br> |
| pp: string, A parameter<br> |
| trace: string, A parameter<br> |
| projectId: string, Project ID of the project billed for the query (required)<br> |
| strict: string, A parameter<br> |
| userip: string, A parameter<br> |
| <br> |
| Returns:<br> |
| An object of the form<br> |
| <br> |
| {<br> |
| "kind": "bigquery#queryResponse", # The resource type.<br> |
| "rows": [ # An object with as many results as can be contained within the maximum permitted reply size. To get any additional rows, you can call GetQueryResults and specify the jobReference returned above.<br> |
| {<br> |
| "f": [ # Represents a single row in the result set, consisting of one or more fields.<br> |
| {<br> |
| "v": "A String", # Contains the field value in this row, as a string.<br> |
| },<br> |
| ],<br> |
| },<br> |
| ],<br> |
| "jobReference": { # Reference to the Job that was created to run the query. This field will be present even if the original request timed out, in which case GetQueryResults can be used to read the results once the query has completed. Since this API only returns the first page of results, subsequent pages can be fetched via the same mechanism (GetQueryResults).<br> |
| "projectId": "A String", # [Required] Project ID being billed for the job.<br> |
| "jobId": "A String", # [Required] ID of the job.<br> |
| },<br> |
| "jobComplete": True or False, # Whether the query has completed or not. If rows or totalRows are present, this will always be true. If this is false, totalRows will not be available.<br> |
| "totalRows": "A String", # The total number of rows in the complete query result set, which can be more than the number of rows in this single page of results.<br> |
| "schema": { # The schema of the results. Present only when the query completes successfully.<br> |
| "fields": [ # Describes the fields in a table.<br> |
| {<br> |
| "fields": [ # [Optional] Describes nested fields when type is RECORD.<br> |
| # Object with schema name: TableFieldSchema<br> |
| ],<br> |
| "type": "A String", # [Required] Data type of the field.<br> |
| "mode": "A String", # [Optional] Mode of the field (whether or not it can be null. Default is NULLABLE.<br> |
| "name": "A String", # [Required] Name of the field.<br> |
| },<br> |
| ],<br> |
| },<br> |
| }</tt></dd></dl> |
| |
| <hr> |
| Data descriptors defined here:<br> |
| <dl><dt><strong>__dict__</strong></dt> |
| <dd><tt>dictionary for instance variables (if defined)</tt></dd> |
| </dl> |
| <dl><dt><strong>__weakref__</strong></dt> |
| <dd><tt>list of weak references to the object (if defined)</tt></dd> |
| </dl> |
| </td></tr></table> |
| </body></html> |