BatchJob
A list of mutates being processed asynchronously. The mutates are uploaded by the user. The mutates themselves aren't readable and the results of the job can only be read using BatchJobService.ListBatchJobResults.
Columns
| Name | Type | Behavior | Description |
| BatchJobId | Long | ATTRIBUTE | Output only. ID of this batch job. |
| BatchJobLongRunningOperation | String | ATTRIBUTE | Output only. The resource name of the long-running operation that can be used to poll for completion. Only set when the batch job status is RUNNING or DONE. |
| BatchJobMetadataCompletionDateTime | Datetime | ATTRIBUTE | Output only. The time when this batch job was completed. Formatted as yyyy-MM-dd HH:mm:ss. Example: '2018-03-05 09:16:00' |
| BatchJobMetadataCreationDateTime | Datetime | ATTRIBUTE | Output only. The time when this batch job was created. Formatted as yyyy-mm-dd hh:mm:ss. Example: '2018-03-05 09:15:00' |
| BatchJobMetadataEstimatedCompletionRatio | Double | ATTRIBUTE | Output only. The fraction (between 0.0 and 1.0) of mutates that have been processed. This is empty if the job hasn't started running yet. |
| BatchJobMetadataExecutedOperationCount | Long | ATTRIBUTE | Output only. The number of mutate operations executed by the batch job. Present only if the job has started running. |
| BatchJobMetadataExecutionLimitSeconds | Int | ATTRIBUTE | Immutable. The approximate upper bound for how long a batch job can be executed, in seconds. If the job runs more than the given upper bound, the job will be canceled. |
| BatchJobMetadataOperationCount | Long | ATTRIBUTE | Output only. The number of mutate operations in the batch job. |
| BatchJobMetadataStartDateTime | Datetime | ATTRIBUTE | Output only. The time when this batch job started running. Formatted as yyyy-mm-dd hh:mm:ss. Example: '2018-03-05 09:15:30' |
| BatchJobNextAddSequenceToken | String | ATTRIBUTE | Output only. The next sequence token to use when adding operations. Only set when the batch job status is PENDING. |
| BatchJobResourceName | String | ATTRIBUTE | Immutable. The resource name of the batch job. Batch job resource names have the form: customers/{customer_id}/batchJobs/{batch_job_id} |
| BatchJobStatus | String | ATTRIBUTE | Output only. Status of this batch job.
使用できる値は次のとおりです。DONE, PENDING, RUNNING, UNKNOWN, UNSPECIFIED |
| CustomerId | Long | ATTRIBUTE | Output only. The ID of the customer. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似列フィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| ManagerId | Long | Id of the manager account on behalf of which you are requesting customer data. |