Interface BigQueryRpc (2.36.0)

public interface BigQueryRpc extends ServiceRpc

Implements

com.google.cloud.ServiceRpc

Methods

cancel(String projectId, String jobId, String location)

public abstract boolean cancel(String projectId, String jobId, String location)

Sends a job cancel request. This call will return immediately, and the client will need to poll for the job status to see if the cancel completed successfully.

Parameters
NameDescription
projectIdString
jobIdString
locationString
Returns
TypeDescription
boolean

true if cancel was requested successfully, false if the job was not found

create(Dataset dataset, Map<BigQueryRpc.Option,?> options)

public abstract Dataset create(Dataset dataset, Map<BigQueryRpc.Option,?> options)

Creates a new dataset.

Parameters
NameDescription
datasetcom.google.api.services.bigquery.model.Dataset
optionsMap<Option,?>
Returns
TypeDescription
com.google.api.services.bigquery.model.Dataset

create(Job job, Map<BigQueryRpc.Option,?> options)

public abstract Job create(Job job, Map<BigQueryRpc.Option,?> options)

Creates a new job.

Parameters
NameDescription
jobcom.google.api.services.bigquery.model.Job
optionsMap<Option,?>
Returns
TypeDescription
com.google.api.services.bigquery.model.Job

create(Routine routine, Map<BigQueryRpc.Option,?> options)

public abstract Routine create(Routine routine, Map<BigQueryRpc.Option,?> options)

Creates the requested routine.

Parameters
NameDescription
routinecom.google.api.services.bigquery.model.Routine
optionsMap<Option,?>
Returns
TypeDescription
com.google.api.services.bigquery.model.Routine

create(Table table, Map<BigQueryRpc.Option,?> options)

public abstract Table create(Table table, Map<BigQueryRpc.Option,?> options)

Creates a new table.

Parameters
NameDescription
tablecom.google.api.services.bigquery.model.Table
optionsMap<Option,?>
Returns
TypeDescription
com.google.api.services.bigquery.model.Table

createJobForQuery(Job job)

public abstract Job createJobForQuery(Job job)

Creates a new query job.

Parameter
NameDescription
jobcom.google.api.services.bigquery.model.Job
Returns
TypeDescription
com.google.api.services.bigquery.model.Job

deleteDataset(String projectId, String datasetId, Map<BigQueryRpc.Option,?> options)

public abstract boolean deleteDataset(String projectId, String datasetId, Map<BigQueryRpc.Option,?> options)

Delete the requested dataset.

Parameters
NameDescription
projectIdString
datasetIdString
optionsMap<Option,?>
Returns
TypeDescription
boolean

true if dataset was deleted, false if it was not found

deleteJob(String projectId, String jobName, String location)

public abstract boolean deleteJob(String projectId, String jobName, String location)

Sends a job delete request.

Parameters
NameDescription
projectIdString
jobNameString
locationString
Returns
TypeDescription
boolean

true if delete was successful, false if the job was not found

deleteModel(String projectId, String datasetId, String modelId)

public abstract boolean deleteModel(String projectId, String datasetId, String modelId)

Delete the requested model.

Parameters
NameDescription
projectIdString
datasetIdString
modelIdString
Returns
TypeDescription
boolean

true if model was deleted, false if it was not found

deleteRoutine(String projectId, String datasetId, String routineId)

public abstract boolean deleteRoutine(String projectId, String datasetId, String routineId)

Deletes the requested routine.

Parameters
NameDescription
projectIdString
datasetIdString
routineIdString
Returns
TypeDescription
boolean

true if routine was deleted, false if it was not found

deleteTable(String projectId, String datasetId, String tableId)

public abstract boolean deleteTable(String projectId, String datasetId, String tableId)

Delete the requested table.

Parameters
NameDescription
projectIdString
datasetIdString
tableIdString
Returns
TypeDescription
boolean

true if table was deleted, false if it was not found

getDataset(String projectId, String datasetId, Map<BigQueryRpc.Option,?> options)

public abstract Dataset getDataset(String projectId, String datasetId, Map<BigQueryRpc.Option,?> options)

Returns the requested dataset or null if not found.

Parameters
NameDescription
projectIdString
datasetIdString
optionsMap<Option,?>
Returns
TypeDescription
com.google.api.services.bigquery.model.Dataset

getIamPolicy(String resourceId, Map<BigQueryRpc.Option,?> options)

public abstract Policy getIamPolicy(String resourceId, Map<BigQueryRpc.Option,?> options)

Returns the IAM Policy for the specified resource, using Policy V1.

Parameters
NameDescription
resourceIdString
optionsMap<Option,?>
Returns
TypeDescription
com.google.api.services.bigquery.model.Policy

getJob(String projectId, String jobId, String location, Map<BigQueryRpc.Option,?> options)

public abstract Job getJob(String projectId, String jobId, String location, Map<BigQueryRpc.Option,?> options)

Returns the requested job or null if not found.

Parameters
NameDescription
projectIdString
jobIdString
locationString
optionsMap<Option,?>
Returns
TypeDescription
com.google.api.services.bigquery.model.Job

getModel(String projectId, String datasetId, String modelId, Map<BigQueryRpc.Option,?> options)

public abstract Model getModel(String projectId, String datasetId, String modelId, Map<BigQueryRpc.Option,?> options)

Returns the requested model or null if not found.

Parameters
NameDescription
projectIdString
datasetIdString
modelIdString
optionsMap<Option,?>
Returns
TypeDescription
com.google.api.services.bigquery.model.Model

getQueryJob(String projectId, String jobId, String location)

public abstract Job getQueryJob(String projectId, String jobId, String location)

Returns the requested query job or null if not found.

Parameters
NameDescription
projectIdString
jobIdString
locationString
Returns
TypeDescription
com.google.api.services.bigquery.model.Job

getQueryResults(String projectId, String jobId, String location, Map<BigQueryRpc.Option,?> options)

public abstract GetQueryResultsResponse getQueryResults(String projectId, String jobId, String location, Map<BigQueryRpc.Option,?> options)

Returns results of the query associated with the provided job.

Parameters
NameDescription
projectIdString
jobIdString
locationString
optionsMap<Option,?>
Returns
TypeDescription
com.google.api.services.bigquery.model.GetQueryResultsResponse

getQueryResultsWithRowLimit(String projectId, String jobId, String location, Integer preFetchedRowLimit, Long timeoutMs)

public abstract GetQueryResultsResponse getQueryResultsWithRowLimit(String projectId, String jobId, String location, Integer preFetchedRowLimit, Long timeoutMs)

Returns results of the query with a limit on how many rows of data to pre-fetch associated with the provided job.

Parameters
NameDescription
projectIdString
jobIdString
locationString
preFetchedRowLimitInteger
timeoutMsLong
Returns
TypeDescription
com.google.api.services.bigquery.model.GetQueryResultsResponse

getRoutine(String projectId, String datasetId, String routineId, Map<BigQueryRpc.Option,?> options)

public abstract Routine getRoutine(String projectId, String datasetId, String routineId, Map<BigQueryRpc.Option,?> options)

Returns the requested routine or null if not found.

Parameters
NameDescription
projectIdString
datasetIdString
routineIdString
optionsMap<Option,?>
Returns
TypeDescription
com.google.api.services.bigquery.model.Routine

getTable(String projectId, String datasetId, String tableId, Map<BigQueryRpc.Option,?> options)

public abstract Table getTable(String projectId, String datasetId, String tableId, Map<BigQueryRpc.Option,?> options)

Returns the requested table or null if not found.

Parameters
NameDescription
projectIdString
datasetIdString
tableIdString
optionsMap<Option,?>
Returns
TypeDescription
com.google.api.services.bigquery.model.Table

insertAll(String projectId, String datasetId, String tableId, TableDataInsertAllRequest request)

public abstract TableDataInsertAllResponse insertAll(String projectId, String datasetId, String tableId, TableDataInsertAllRequest request)

Sends an insert all request.

Parameters
NameDescription
projectIdString
datasetIdString
tableIdString
requestcom.google.api.services.bigquery.model.TableDataInsertAllRequest
Returns
TypeDescription
com.google.api.services.bigquery.model.TableDataInsertAllResponse

listDatasets(String projectId, Map<BigQueryRpc.Option,?> options)

public abstract Tuple<String,Iterable<Dataset>> listDatasets(String projectId, Map<BigQueryRpc.Option,?> options)

Lists the provided project's datasets, keyed by page token. Partial information is returned on a dataset (datasetReference, friendlyName and id). To get full information use #getDataset(String, String, Map).

Parameters
NameDescription
projectIdString
optionsMap<Option,?>
Returns
TypeDescription
com.google.cloud.Tuple<String,Iterable<com.google.api.services.bigquery.model.Dataset>>

listJobs(String projectId, Map<BigQueryRpc.Option,?> options)

public abstract Tuple<String,Iterable<Job>> listJobs(String projectId, Map<BigQueryRpc.Option,?> options)

Lists the project's jobs.

Parameters
NameDescription
projectIdString
optionsMap<Option,?>
Returns
TypeDescription
com.google.cloud.Tuple<String,Iterable<com.google.api.services.bigquery.model.Job>>

listModels(String projectId, String dataset, Map<BigQueryRpc.Option,?> options)

public abstract Tuple<String,Iterable<Model>> listModels(String projectId, String dataset, Map<BigQueryRpc.Option,?> options)

Lists the dataset's models, keyed by page token.

Parameters
NameDescription
projectIdString
datasetString
optionsMap<Option,?>
Returns
TypeDescription
com.google.cloud.Tuple<String,Iterable<com.google.api.services.bigquery.model.Model>>

listRoutines(String projectId, String datasetId, Map<BigQueryRpc.Option,?> options)

public abstract Tuple<String,Iterable<Routine>> listRoutines(String projectId, String datasetId, Map<BigQueryRpc.Option,?> options)
Parameters
NameDescription
projectIdString
datasetIdString
optionsMap<Option,?>
Returns
TypeDescription
com.google.cloud.Tuple<String,Iterable<com.google.api.services.bigquery.model.Routine>>

listTableData(String projectId, String datasetId, String tableId, Map<BigQueryRpc.Option,?> options)

public abstract TableDataList listTableData(String projectId, String datasetId, String tableId, Map<BigQueryRpc.Option,?> options)

Lists the table's rows.

Parameters
NameDescription
projectIdString
datasetIdString
tableIdString
optionsMap<Option,?>
Returns
TypeDescription
com.google.api.services.bigquery.model.TableDataList

listTableDataWithRowLimit(String projectId, String datasetId, String tableId, Integer rowLimit, String pageToken)

public abstract TableDataList listTableDataWithRowLimit(String projectId, String datasetId, String tableId, Integer rowLimit, String pageToken)

Lists the table's rows with a limit on how many rows of data to pre-fetch.

Parameters
NameDescription
projectIdString
datasetIdString
tableIdString
rowLimitInteger
pageTokenString
Returns
TypeDescription
com.google.api.services.bigquery.model.TableDataList

listTables(String projectId, String dataset, Map<BigQueryRpc.Option,?> options)

public abstract Tuple<String,Iterable<Table>> listTables(String projectId, String dataset, Map<BigQueryRpc.Option,?> options)

Lists the dataset's tables, keyed by page token. Partial information is returned on a table (tableReference, friendlyName, id and type). To get full information use #getTable(String, String, String, Map).

Parameters
NameDescription
projectIdString
datasetString
optionsMap<Option,?>
Returns
TypeDescription
com.google.cloud.Tuple<String,Iterable<com.google.api.services.bigquery.model.Table>>

open(Job job)

public abstract String open(Job job)

Opens a resumable upload session to load data into a BigQuery table and returns an upload URI.

Parameter
NameDescription
jobcom.google.api.services.bigquery.model.Job

load job

Returns
TypeDescription
String

patch(Dataset dataset, Map<BigQueryRpc.Option,?> options)

public abstract Dataset patch(Dataset dataset, Map<BigQueryRpc.Option,?> options)

Updates dataset information.

Parameters
NameDescription
datasetcom.google.api.services.bigquery.model.Dataset
optionsMap<Option,?>
Returns
TypeDescription
com.google.api.services.bigquery.model.Dataset

patch(Model model, Map<BigQueryRpc.Option,?> options)

public abstract Model patch(Model model, Map<BigQueryRpc.Option,?> options)

Updates model information.

Parameters
NameDescription
modelcom.google.api.services.bigquery.model.Model
optionsMap<Option,?>
Returns
TypeDescription
com.google.api.services.bigquery.model.Model

patch(Table table, Map<BigQueryRpc.Option,?> options)

public abstract Table patch(Table table, Map<BigQueryRpc.Option,?> options)

Updates table information.

Parameters
NameDescription
tablecom.google.api.services.bigquery.model.Table
optionsMap<Option,?>
Returns
TypeDescription
com.google.api.services.bigquery.model.Table

queryRpc(String projectId, QueryRequest content)

public abstract QueryResponse queryRpc(String projectId, QueryRequest content)

Runs a BigQuery SQL query synchronously and returns query results if the query completes within a specified timeout.

Create a request for the method "jobs.query".

This request holds the parameters needed by the bigquery server. After setting any optional parameters, call the Query#execute() method to invoke the remote operation.

Parameters
NameDescription
projectIdString

Project ID of the project billed for the query

contentcom.google.api.services.bigquery.model.QueryRequest

the com.google.api.services.bigquery.model.QueryRequest

Returns
TypeDescription
com.google.api.services.bigquery.model.QueryResponse

the request

setIamPolicy(String resourceId, Policy policy, Map<BigQueryRpc.Option,?> options)

public abstract Policy setIamPolicy(String resourceId, Policy policy, Map<BigQueryRpc.Option,?> options)

Updates the IAM policy for the specified resource.

Parameters
NameDescription
resourceIdString
policycom.google.api.services.bigquery.model.Policy
optionsMap<Option,?>
Returns
TypeDescription
com.google.api.services.bigquery.model.Policy

testIamPermissions(String resourceId, List<String> permissions, Map<BigQueryRpc.Option,?> options)

public abstract TestIamPermissionsResponse testIamPermissions(String resourceId, List<String> permissions, Map<BigQueryRpc.Option,?> options)

Tests whether the caller holds the provided permissions for the specified resource. Returns the subset of permissions the caller actually holds.

Parameters
NameDescription
resourceIdString
permissionsList<String>
optionsMap<Option,?>
Returns
TypeDescription
com.google.api.services.bigquery.model.TestIamPermissionsResponse

update(Routine routine, Map<BigQueryRpc.Option,?> options)

public abstract Routine update(Routine routine, Map<BigQueryRpc.Option,?> options)

Updates the requested routine.

Parameters
NameDescription
routinecom.google.api.services.bigquery.model.Routine
optionsMap<Option,?>
Returns
TypeDescription
com.google.api.services.bigquery.model.Routine

write(String uploadId, byte[] toWrite, int toWriteOffset, long destOffset, int length, boolean last)

public abstract Job write(String uploadId, byte[] toWrite, int toWriteOffset, long destOffset, int length, boolean last)

Uploads the provided data to the resumable upload session at the specified position. This method returns the job created to insert the rows, only when last is true.

Parameters
NameDescription
uploadIdString

the resumable upload session URI

toWritebyte[]

a byte array of data to upload

toWriteOffsetint

offset in the toWrite param to start writing from

destOffsetlong

offset in the destination where to upload data to

lengthint

the number of bytes to upload

lastboolean

true indicates that the last chunk is being uploaded

Returns
TypeDescription
com.google.api.services.bigquery.model.Job

returns the job created to insert the rows, only when last is true. Returns null otherwise