Google BigQuery v2 API - Class BigQueryClientImpl (3.4.0)

public sealed class BigQueryClientImpl : BigQueryClient, IDisposable

Reference documentation and code samples for the Google BigQuery v2 API class BigQueryClientImpl.

Wrapper around BigqueryService to provide simpler operations.

Inheritance

object > BigQueryClient > BigQueryClientImpl

Implements

IDisposable

Inherited Members

BigQueryClient.CreateAsync(string, GoogleCredential)

BigQueryClient.Create(string, GoogleCredential)

BigQueryClient.GetTableReference(string, string)

BigQueryClient.GetTableReference(string, string, string)

BigQueryClient.GetDatasetReference(string)

BigQueryClient.GetDatasetReference(string, string)

BigQueryClient.GetProjectReference(string)

BigQueryClient.GetJobReference(string)

BigQueryClient.GetJobReference(string, string)

BigQueryClient.GetJobReference(string, string, string)

BigQueryClient.GetModelReference(string, string)

BigQueryClient.GetModelReference(string, string, string)

BigQueryClient.GetRoutineReference(string, string)

BigQueryClient.GetRoutineReference(string, string, string)

BigQueryClient.CreateJsonSerializersSettings()

BigQueryClient.ListDatasets(ListDatasetsOptions)

BigQueryClient.ListDatasets(string, ListDatasetsOptions)

BigQueryClient.ListDatasetsAsync(ListDatasetsOptions)

BigQueryClient.ListDatasetsAsync(string, ListDatasetsOptions)

BigQueryClient.GetDataset(string, GetDatasetOptions)

BigQueryClient.GetDataset(string, string, GetDatasetOptions)

BigQueryClient.GetDatasetAsync(string, GetDatasetOptions, CancellationToken)

BigQueryClient.GetDatasetAsync(string, string, GetDatasetOptions, CancellationToken)

BigQueryClient.CreateDataset(string, Dataset, CreateDatasetOptions)

BigQueryClient.CreateDataset(string, string, Dataset, CreateDatasetOptions)

BigQueryClient.CreateDatasetAsync(string, Dataset, CreateDatasetOptions, CancellationToken)

BigQueryClient.CreateDatasetAsync(string, string, Dataset, CreateDatasetOptions, CancellationToken)

BigQueryClient.GetOrCreateDataset(string, Dataset, GetDatasetOptions, CreateDatasetOptions)

BigQueryClient.GetOrCreateDataset(string, string, Dataset, GetDatasetOptions, CreateDatasetOptions)

BigQueryClient.GetOrCreateDatasetAsync(string, Dataset, GetDatasetOptions, CreateDatasetOptions, CancellationToken)

BigQueryClient.GetOrCreateDatasetAsync(string, string, Dataset, GetDatasetOptions, CreateDatasetOptions, CancellationToken)

BigQueryClient.DeleteDataset(string, DeleteDatasetOptions)

BigQueryClient.DeleteDataset(string, string, DeleteDatasetOptions)

BigQueryClient.DeleteDatasetAsync(string, DeleteDatasetOptions, CancellationToken)

BigQueryClient.DeleteDatasetAsync(string, string, DeleteDatasetOptions, CancellationToken)

BigQueryClient.UpdateDataset(string, Dataset, UpdateDatasetOptions)

BigQueryClient.UpdateDataset(string, string, Dataset, UpdateDatasetOptions)

BigQueryClient.UpdateDatasetAsync(string, Dataset, UpdateDatasetOptions, CancellationToken)

BigQueryClient.UpdateDatasetAsync(string, string, Dataset, UpdateDatasetOptions, CancellationToken)

BigQueryClient.PatchDataset(string, Dataset, PatchDatasetOptions)

BigQueryClient.PatchDataset(string, string, Dataset, PatchDatasetOptions)

BigQueryClient.PatchDatasetAsync(string, Dataset, PatchDatasetOptions, CancellationToken)

BigQueryClient.PatchDatasetAsync(string, string, Dataset, PatchDatasetOptions, CancellationToken)

BigQueryClient.SetDatasetLabel(string, string, string, ModifyLabelsOptions)

BigQueryClient.SetDatasetLabel(string, string, string, string, ModifyLabelsOptions)

BigQueryClient.SetDatasetLabelAsync(string, string, string, ModifyLabelsOptions, CancellationToken)

BigQueryClient.SetDatasetLabelAsync(string, string, string, string, ModifyLabelsOptions, CancellationToken)

BigQueryClient.RemoveDatasetLabel(string, string, ModifyLabelsOptions)

BigQueryClient.RemoveDatasetLabel(string, string, string, ModifyLabelsOptions)

BigQueryClient.RemoveDatasetLabelAsync(string, string, ModifyLabelsOptions, CancellationToken)

BigQueryClient.RemoveDatasetLabelAsync(string, string, string, ModifyLabelsOptions, CancellationToken)

BigQueryClient.ClearDatasetLabels(string, ModifyLabelsOptions)

BigQueryClient.ClearDatasetLabels(string, string, ModifyLabelsOptions)

BigQueryClient.ClearDatasetLabelsAsync(string, ModifyLabelsOptions, CancellationToken)

BigQueryClient.ClearDatasetLabelsAsync(string, string, ModifyLabelsOptions, CancellationToken)

BigQueryClient.ModifyDatasetLabels(string, IDictionary<string, string>, ModifyLabelsOptions)

BigQueryClient.ModifyDatasetLabels(string, string, IDictionary<string, string>, ModifyLabelsOptions)

BigQueryClient.ModifyDatasetLabelsAsync(string, IDictionary<string, string>, ModifyLabelsOptions, CancellationToken)

BigQueryClient.ModifyDatasetLabelsAsync(string, string, IDictionary<string, string>, ModifyLabelsOptions, CancellationToken)

BigQueryClient.InsertRow(string, string, string, BigQueryInsertRow, InsertOptions)

BigQueryClient.InsertRow(string, string, BigQueryInsertRow, InsertOptions)

BigQueryClient.InsertRow(TableReference, BigQueryInsertRow, InsertOptions)

BigQueryClient.InsertRowAsync(string, string, string, BigQueryInsertRow, InsertOptions, CancellationToken)

BigQueryClient.InsertRowAsync(string, string, BigQueryInsertRow, InsertOptions, CancellationToken)

BigQueryClient.InsertRowAsync(TableReference, BigQueryInsertRow, InsertOptions, CancellationToken)

BigQueryClient.InsertRows(string, string, string, params BigQueryInsertRow[])

BigQueryClient.InsertRows(string, string, params BigQueryInsertRow[])

BigQueryClient.InsertRows(TableReference, params BigQueryInsertRow[])

BigQueryClient.InsertRowsAsync(string, string, string, params BigQueryInsertRow[])

BigQueryClient.InsertRowsAsync(string, string, params BigQueryInsertRow[])

BigQueryClient.InsertRowsAsync(TableReference, params BigQueryInsertRow[])

BigQueryClient.UploadCsv(string, string, TableSchema, Stream, UploadCsvOptions)

BigQueryClient.UploadCsv(string, string, string, TableSchema, Stream, UploadCsvOptions)

BigQueryClient.UploadCsvAsync(string, string, TableSchema, Stream, UploadCsvOptions, CancellationToken)

BigQueryClient.UploadCsvAsync(string, string, string, TableSchema, Stream, UploadCsvOptions, CancellationToken)

BigQueryClient.UploadJson(string, string, TableSchema, Stream, UploadJsonOptions)

BigQueryClient.UploadJson(string, string, string, TableSchema, Stream, UploadJsonOptions)

BigQueryClient.UploadJsonAsync(string, string, TableSchema, Stream, UploadJsonOptions, CancellationToken)

BigQueryClient.UploadJsonAsync(string, string, string, TableSchema, Stream, UploadJsonOptions, CancellationToken)

BigQueryClient.UploadJson(string, string, TableSchema, IEnumerable<string>, UploadJsonOptions)

BigQueryClient.UploadJson(string, string, string, TableSchema, IEnumerable<string>, UploadJsonOptions)

BigQueryClient.UploadJsonAsync(string, string, TableSchema, IEnumerable<string>, UploadJsonOptions, CancellationToken)

BigQueryClient.UploadJsonAsync(string, string, string, TableSchema, IEnumerable<string>, UploadJsonOptions, CancellationToken)

BigQueryClient.UploadAvro(string, string, TableSchema, Stream, UploadAvroOptions)

BigQueryClient.UploadAvro(string, string, string, TableSchema, Stream, UploadAvroOptions)

BigQueryClient.UploadAvroAsync(string, string, TableSchema, Stream, UploadAvroOptions, CancellationToken)

BigQueryClient.UploadAvroAsync(string, string, string, TableSchema, Stream, UploadAvroOptions, CancellationToken)

BigQueryClient.UploadParquet(string, string, Stream, UploadParquetOptions)

BigQueryClient.UploadParquet(string, string, string, Stream, UploadParquetOptions)

BigQueryClient.UploadParquetAsync(string, string, Stream, UploadParquetOptions, CancellationToken)

BigQueryClient.UploadParquetAsync(string, string, string, Stream, UploadParquetOptions, CancellationToken)

BigQueryClient.UploadOrc(string, string, Stream, UploadOrcOptions)

BigQueryClient.UploadOrc(string, string, string, Stream, UploadOrcOptions)

BigQueryClient.UploadOrcAsync(string, string, Stream, UploadOrcOptions, CancellationToken)

BigQueryClient.UploadOrcAsync(string, string, string, Stream, UploadOrcOptions, CancellationToken)

BigQueryClient.InsertRows(string, string, IEnumerable<BigQueryInsertRow>, InsertOptions)

BigQueryClient.InsertRows(string, string, string, IEnumerable<BigQueryInsertRow>, InsertOptions)

BigQueryClient.InsertRowsAsync(string, string, IEnumerable<BigQueryInsertRow>, InsertOptions, CancellationToken)

BigQueryClient.InsertRowsAsync(string, string, string, IEnumerable<BigQueryInsertRow>, InsertOptions, CancellationToken)

BigQueryClient.ListJobs(ListJobsOptions)

BigQueryClient.ListJobs(string, ListJobsOptions)

BigQueryClient.ListJobsAsync(ListJobsOptions)

BigQueryClient.ListJobsAsync(string, ListJobsOptions)

BigQueryClient.CreateExtractJob(string, string, string, string, CreateExtractJobOptions)

BigQueryClient.CreateExtractJob(string, string, string, CreateExtractJobOptions)

BigQueryClient.CreateExtractJob(TableReference, string, CreateExtractJobOptions)

BigQueryClient.CreateExtractJobAsync(string, string, string, string, CreateExtractJobOptions, CancellationToken)

BigQueryClient.CreateExtractJobAsync(string, string, string, CreateExtractJobOptions, CancellationToken)

BigQueryClient.CreateExtractJobAsync(TableReference, string, CreateExtractJobOptions, CancellationToken)

BigQueryClient.CreateCopyJob(TableReference, TableReference, CreateCopyJobOptions)

BigQueryClient.CreateCopyJobAsync(TableReference, TableReference, CreateCopyJobOptions, CancellationToken)

BigQueryClient.CreateLoadJob(string, TableReference, TableSchema, CreateLoadJobOptions)

BigQueryClient.CreateLoadJobAsync(string, TableReference, TableSchema, CreateLoadJobOptions, CancellationToken)

BigQueryClient.CreateModelExtractJob(string, string, string, CreateModelExtractJobOptions)

BigQueryClient.CreateModelExtractJob(string, string, string, string, CreateModelExtractJobOptions)

BigQueryClient.CreateModelExtractJob(ModelReference, string, CreateModelExtractJobOptions)

BigQueryClient.CreateModelExtractJobAsync(string, string, string, CreateModelExtractJobOptions, CancellationToken)

BigQueryClient.CreateModelExtractJobAsync(string, string, string, string, CreateModelExtractJobOptions, CancellationToken)

BigQueryClient.CreateModelExtractJobAsync(ModelReference, string, CreateModelExtractJobOptions, CancellationToken)

BigQueryClient.PollJobUntilCompleted(string, GetJobOptions, PollSettings)

BigQueryClient.PollJobUntilCompleted(string, string, GetJobOptions, PollSettings)

BigQueryClient.PollJobUntilCompletedAsync(string, GetJobOptions, PollSettings, CancellationToken)

BigQueryClient.PollJobUntilCompletedAsync(string, string, GetJobOptions, PollSettings, CancellationToken)

BigQueryClient.GetJob(string, GetJobOptions)

BigQueryClient.GetJob(string, string, GetJobOptions)

BigQueryClient.GetJobAsync(string, GetJobOptions, CancellationToken)

BigQueryClient.GetJobAsync(string, string, GetJobOptions, CancellationToken)

BigQueryClient.CancelJob(string, CancelJobOptions)

BigQueryClient.CancelJob(string, string, CancelJobOptions)

BigQueryClient.CancelJobAsync(string, CancelJobOptions, CancellationToken)

BigQueryClient.CancelJobAsync(string, string, CancelJobOptions, CancellationToken)

BigQueryClient.CreateExtractJob(string, string, IEnumerable<string>, CreateExtractJobOptions)

BigQueryClient.CreateExtractJob(string, string, string, IEnumerable<string>, CreateExtractJobOptions)

BigQueryClient.CreateExtractJobAsync(string, string, IEnumerable<string>, CreateExtractJobOptions, CancellationToken)

BigQueryClient.CreateExtractJobAsync(string, string, string, IEnumerable<string>, CreateExtractJobOptions, CancellationToken)

BigQueryClient.CreateModelExtractJob(string, string, IEnumerable<string>, CreateModelExtractJobOptions)

BigQueryClient.CreateModelExtractJob(string, string, string, IEnumerable<string>, CreateModelExtractJobOptions)

BigQueryClient.CreateModelExtractJobAsync(string, string, IEnumerable<string>, CreateModelExtractJobOptions, CancellationToken)

BigQueryClient.CreateModelExtractJobAsync(string, string, string, IEnumerable<string>, CreateModelExtractJobOptions, CancellationToken)

BigQueryClient.DeleteJob(string, DeleteJobOptions)

BigQueryClient.DeleteJob(string, string, DeleteJobOptions)

BigQueryClient.DeleteJobAsync(string, DeleteJobOptions, CancellationToken)

BigQueryClient.DeleteJobAsync(string, string, DeleteJobOptions, CancellationToken)

BigQueryClient.ListModels(string, string, ListModelsOptions)

BigQueryClient.ListModels(string, ListModelsOptions)

BigQueryClient.ListModelsAsync(string, string, ListModelsOptions)

BigQueryClient.ListModelsAsync(string, ListModelsOptions)

BigQueryClient.GetModel(string, string, GetModelOptions)

BigQueryClient.GetModel(string, string, string, GetModelOptions)

BigQueryClient.GetModelAsync(string, string, GetModelOptions, CancellationToken)

BigQueryClient.GetModelAsync(string, string, string, GetModelOptions, CancellationToken)

BigQueryClient.DeleteModel(string, string, DeleteModelOptions)

BigQueryClient.DeleteModel(string, string, string, DeleteModelOptions)

BigQueryClient.DeleteModelAsync(string, string, DeleteModelOptions, CancellationToken)

BigQueryClient.DeleteModelAsync(string, string, string, DeleteModelOptions, CancellationToken)

BigQueryClient.PatchModel(string, string, Model, PatchModelOptions)

BigQueryClient.PatchModel(string, string, string, Model, PatchModelOptions)

BigQueryClient.PatchModelAsync(string, string, Model, PatchModelOptions, CancellationToken)

BigQueryClient.PatchModelAsync(string, string, string, Model, PatchModelOptions, CancellationToken)

BigQueryClient.ExecuteQuery(string, IEnumerable<BigQueryParameter>, QueryOptions, GetQueryResultsOptions)

BigQueryClient.ExecuteQueryAsync(string, IEnumerable<BigQueryParameter>, QueryOptions, GetQueryResultsOptions, CancellationToken)

BigQueryClient.ListRows(string, string, string, TableSchema, ListRowsOptions)

BigQueryClient.ListRows(string, string, TableSchema, ListRowsOptions)

BigQueryClient.ListRowsAsync(string, string, string, TableSchema, ListRowsOptions)

BigQueryClient.ListRowsAsync(string, string, TableSchema, ListRowsOptions)

BigQueryClient.GetQueryResults(string, GetQueryResultsOptions)

BigQueryClient.GetQueryResults(string, string, GetQueryResultsOptions)

BigQueryClient.GetQueryResultsAsync(string, GetQueryResultsOptions, CancellationToken)

BigQueryClient.GetQueryResultsAsync(string, string, GetQueryResultsOptions, CancellationToken)

BigQueryClient.ListRoutines(string, string, ListRoutinesOptions)

BigQueryClient.ListRoutines(string, ListRoutinesOptions)

BigQueryClient.ListRoutinesAsync(string, string, ListRoutinesOptions)

BigQueryClient.ListRoutinesAsync(string, ListRoutinesOptions)

BigQueryClient.GetRoutine(string, string, GetRoutineOptions)

BigQueryClient.GetRoutine(string, string, string, GetRoutineOptions)

BigQueryClient.GetRoutineAsync(string, string, GetRoutineOptions, CancellationToken)

BigQueryClient.GetRoutineAsync(string, string, string, GetRoutineOptions, CancellationToken)

BigQueryClient.CreateRoutine(string, string, Routine, CreateRoutineOptions)

BigQueryClient.CreateRoutine(string, string, string, Routine, CreateRoutineOptions)

BigQueryClient.CreateRoutineAsync(string, string, Routine, CreateRoutineOptions, CancellationToken)

BigQueryClient.CreateRoutineAsync(string, string, string, Routine, CreateRoutineOptions, CancellationToken)

BigQueryClient.GetOrCreateRoutine(string, string, Routine, GetRoutineOptions, CreateRoutineOptions)

BigQueryClient.GetOrCreateRoutine(string, string, string, Routine, GetRoutineOptions, CreateRoutineOptions)

BigQueryClient.GetOrCreateRoutineAsync(string, string, Routine, GetRoutineOptions, CreateRoutineOptions, CancellationToken)

BigQueryClient.GetOrCreateRoutineAsync(string, string, string, Routine, GetRoutineOptions, CreateRoutineOptions, CancellationToken)

BigQueryClient.DeleteRoutine(string, string, DeleteRoutineOptions)

BigQueryClient.DeleteRoutine(string, string, string, DeleteRoutineOptions)

BigQueryClient.DeleteRoutineAsync(string, string, DeleteRoutineOptions, CancellationToken)

BigQueryClient.DeleteRoutineAsync(string, string, string, DeleteRoutineOptions, CancellationToken)

BigQueryClient.UpdateRoutine(string, string, Routine, UpdateRoutineOptions)

BigQueryClient.UpdateRoutine(string, string, string, Routine, UpdateRoutineOptions)

BigQueryClient.UpdateRoutineAsync(string, string, Routine, UpdateRoutineOptions, CancellationToken)

BigQueryClient.UpdateRoutineAsync(string, string, string, Routine, UpdateRoutineOptions, CancellationToken)

BigQueryClient.GetBigQueryServiceAccountEmail(GetBigQueryServiceAccountEmailOptions)

BigQueryClient.GetBigQueryServiceAccountEmail(string, GetBigQueryServiceAccountEmailOptions)

BigQueryClient.GetBigQueryServiceAccountEmailAsync(GetBigQueryServiceAccountEmailOptions, CancellationToken)

BigQueryClient.GetBigQueryServiceAccountEmailAsync(string, GetBigQueryServiceAccountEmailOptions, CancellationToken)

BigQueryClient.ListTables(string, string, ListTablesOptions)

BigQueryClient.ListTables(string, ListTablesOptions)

BigQueryClient.ListTablesAsync(string, string, ListTablesOptions)

BigQueryClient.ListTablesAsync(string, ListTablesOptions)

BigQueryClient.GetTable(string, string, GetTableOptions)

BigQueryClient.GetTable(string, string, string, GetTableOptions)

BigQueryClient.GetTableAsync(string, string, GetTableOptions, CancellationToken)

BigQueryClient.GetTableAsync(string, string, string, GetTableOptions, CancellationToken)

BigQueryClient.CreateTable(string, string, Table, CreateTableOptions)

BigQueryClient.CreateTable(string, string, string, Table, CreateTableOptions)

BigQueryClient.CreateTableAsync(string, string, Table, CreateTableOptions, CancellationToken)

BigQueryClient.CreateTableAsync(string, string, string, Table, CreateTableOptions, CancellationToken)

BigQueryClient.CreateTable(string, string, TableSchema, CreateTableOptions)

BigQueryClient.CreateTable(string, string, string, TableSchema, CreateTableOptions)

BigQueryClient.CreateTableAsync(string, string, TableSchema, CreateTableOptions, CancellationToken)

BigQueryClient.CreateTableAsync(string, string, string, TableSchema, CreateTableOptions, CancellationToken)

BigQueryClient.GetOrCreateTable(string, string, Table, GetTableOptions, CreateTableOptions)

BigQueryClient.GetOrCreateTable(string, string, string, Table, GetTableOptions, CreateTableOptions)

BigQueryClient.GetOrCreateTableAsync(string, string, Table, GetTableOptions, CreateTableOptions, CancellationToken)

BigQueryClient.GetOrCreateTableAsync(string, string, string, Table, GetTableOptions, CreateTableOptions, CancellationToken)

BigQueryClient.GetOrCreateTable(string, string, TableSchema, GetTableOptions, CreateTableOptions)

BigQueryClient.GetOrCreateTable(string, string, string, TableSchema, GetTableOptions, CreateTableOptions)

BigQueryClient.GetOrCreateTableAsync(string, string, TableSchema, GetTableOptions, CreateTableOptions, CancellationToken)

BigQueryClient.GetOrCreateTableAsync(string, string, string, TableSchema, GetTableOptions, CreateTableOptions, CancellationToken)

BigQueryClient.DeleteTable(string, string, DeleteTableOptions)

BigQueryClient.DeleteTable(string, string, string, DeleteTableOptions)

BigQueryClient.DeleteTableAsync(string, string, DeleteTableOptions, CancellationToken)

BigQueryClient.DeleteTableAsync(string, string, string, DeleteTableOptions, CancellationToken)

BigQueryClient.UpdateTable(string, string, Table, UpdateTableOptions)

BigQueryClient.UpdateTable(string, string, string, Table, UpdateTableOptions)

BigQueryClient.UpdateTableAsync(string, string, Table, UpdateTableOptions, CancellationToken)

BigQueryClient.UpdateTableAsync(string, string, string, Table, UpdateTableOptions, CancellationToken)

BigQueryClient.PatchTable(string, string, Table, PatchTableOptions)

BigQueryClient.PatchTable(string, string, string, Table, PatchTableOptions)

BigQueryClient.PatchTableAsync(string, string, Table, PatchTableOptions, CancellationToken)

BigQueryClient.PatchTableAsync(string, string, string, Table, PatchTableOptions, CancellationToken)

BigQueryClient.GetTableIamPolicy(string, string, GetTableIamPolicyOptions)

BigQueryClient.GetTableIamPolicy(string, string, string, GetTableIamPolicyOptions)

BigQueryClient.GetTableIamPolicyAsync(string, string, GetTableIamPolicyOptions, CancellationToken)

BigQueryClient.GetTableIamPolicyAsync(string, string, string, GetTableIamPolicyOptions, CancellationToken)

BigQueryClient.SetTableIamPolicy(string, string, Policy, SetTableIamPolicyOptions)

BigQueryClient.SetTableIamPolicy(string, string, string, Policy, SetTableIamPolicyOptions)

BigQueryClient.SetTableIamPolicyAsync(string, string, Policy, SetTableIamPolicyOptions, CancellationToken)

BigQueryClient.SetTableIamPolicyAsync(string, string, string, Policy, SetTableIamPolicyOptions, CancellationToken)

BigQueryClient.TestTableIamPermissions(string, string, IList<string>, TestTableIamPermissionsOptions)

BigQueryClient.TestTableIamPermissions(string, string, string, IList<string>, TestTableIamPermissionsOptions)

BigQueryClient.TestTableIamPermissionsAsync(string, string, IList<string>, TestTableIamPermissionsOptions, CancellationToken)

BigQueryClient.TestTableIamPermissionsAsync(string, string, string, IList<string>, TestTableIamPermissionsOptions, CancellationToken)

object.GetHashCode()

object.GetType()

object.ToString()

Namespace

Google.Cloud.BigQuery.V2

Assembly

Google.Cloud.BigQuery.V2.dll

Remarks

This is the "default" implementation of BigQueryClient. Most client code should refer to BigQueryClient, creating instances with Create(string, GoogleCredential) and CreateAsync(string, GoogleCredential). The constructor of this class is public for the sake of constructor-based dependency injection.

Constructors

BigQueryClientImpl(ProjectReference, BigqueryService)

public BigQueryClientImpl(ProjectReference projectReference, BigqueryService service)

Constructs a new client wrapping the given BigqueryService.

Parameters
Name	Description
projectReference	ProjectReference A fully-qualified identifier for the project. Must not be null.
service	BigqueryService The service to wrap. Must not be null.

Remarks

Care should be taken when constructing the service: if the default serializer settings are used, result values which can be parsed as date/time values can cause problems. Where possible, either use Create(string, GoogleCredential) or construct a service using serializer settings from CreateJsonSerializersSettings().

BigQueryClientImpl(ProjectReference, BigqueryService, string)

public BigQueryClientImpl(ProjectReference projectReference, BigqueryService service, string defaultLocation)

Constructs a new client wrapping the given BigqueryService, with a specified default location for location-specific operations.

Parameters
Name	Description
projectReference	ProjectReference A fully-qualified identifier for the project. Must not be null.
service	BigqueryService The service to wrap. Must not be null.
defaultLocation	string The default location to use for location-specific operations. May be null.

Remarks

Care should be taken when constructing the service: if the default serializer settings are used, result values which can be parsed as date/time values can cause problems. Where possible, either use Create(string, GoogleCredential) or construct a service using serializer settings from CreateJsonSerializersSettings().

BigQueryClientImpl(string, BigqueryService)

public BigQueryClientImpl(string projectId, BigqueryService service)

Constructs a new client wrapping the given BigqueryService, with no default location.

Parameters
Name	Description
projectId	string The ID of the project to work with. Must not be null.
service	BigqueryService The service to wrap. Must not be null.

Remarks

Care should be taken when constructing the service: if the default serializer settings are used, result values which can be parsed as date/time values can cause problems. Where possible, either use Create(string, GoogleCredential) or construct a service using serializer settings from CreateJsonSerializersSettings().

BigQueryClientImpl(string, BigqueryService, string)

public BigQueryClientImpl(string projectId, BigqueryService service, string defaultLocation)

Constructs a new client wrapping the given BigqueryService, with a specified default location for location-specific operations.

Parameters
Name	Description
projectId	string The ID of the project to work with. Must not be null.
service	BigqueryService The service to wrap. Must not be null.
defaultLocation	string The default location to use for location-specific operations. May be null.

Remarks

Care should be taken when constructing the service: if the default serializer settings are used, result values which can be parsed as date/time values can cause problems. Where possible, either use Create(string, GoogleCredential) or construct a service using serializer settings from CreateJsonSerializersSettings().

Properties

ApplicationName

public static string ApplicationName { get; set; }

The default application name used when creating a BigqueryService. Defaults to "google-cloud-dotnet"; must not be null.

Property Value
Type	Description
string

Remarks

Most applications will never want to set this, which is why it's in this class rather than BigQueryClient.

DefaultLocation

public override string DefaultLocation { get; }

The default location to use for all operations where locations can be specified, such as dataset and job creation.

Property Value
Type	Description
string

Overrides

BigQueryClient.DefaultLocation

PrettyPrint

public override bool PrettyPrint { get; }

Determines whether or not responses should be formatted with whitespace for readability.

Property Value
Type	Description
bool

Overrides

BigQueryClient.PrettyPrint

ProjectId

public override string ProjectId { get; }

The ID of the project this client operates on. All operations that require a project to be specified implicitly supply this ID.

Property Value
Type	Description
string

Overrides

BigQueryClient.ProjectId

Service

public override BigqueryService Service { get; }

The underlying BigQuery service object used by this client.

Property Value
Type	Description
BigqueryService

Overrides

BigQueryClient.Service

Remarks

The BigQueryClient class only provides convenience operations built on top of an existing service object. Any more complex operations which are not supported by this wrapper may wish to use the same service object as the wrapper, in order to take advantage of its configuration (for authentication, application naming etc).

Methods

CancelJob(JobReference, CancelJobOptions)

public override BigQueryJob CancelJob(JobReference jobReference, CancelJobOptions options = null)

Cancels the specified job.

Parameters
Name	Description
jobReference	JobReference A fully-qualified identifier for the job. Must not be null.
options	CancelJobOptions The options for the operation. May be null, in which case defaults will be supplied.

Returns
Type	Description
BigQueryJob	The final state of the job.

Overrides

BigQueryClient.CancelJob(JobReference, CancelJobOptions)

CancelJobAsync(JobReference, CancelJobOptions, CancellationToken)

public override Task<BigQueryJob> CancelJobAsync(JobReference jobReference, CancelJobOptions options = null, CancellationToken cancellationToken = default)

Asynchronously cancels the specified job.

Parameters
Name	Description
jobReference	JobReference A fully-qualified identifier for the job. Must not be null.
options	CancelJobOptions The options for the operation. May be null, in which case defaults will be supplied.
cancellationToken	CancellationToken The token to monitor for cancellation requests.

Returns
Type	Description
TaskBigQueryJob	A task representing the asynchronous operation. When complete, the result is the final state of the job.

Overrides

BigQueryClient.CancelJobAsync(JobReference, CancelJobOptions, CancellationToken)

ClearDatasetLabels(DatasetReference, ModifyLabelsOptions)

public override IDictionary<string, string> ClearDatasetLabels(DatasetReference datasetReference, ModifyLabelsOptions options = null)

Clears all labels on the specified dataset.

Parameters
Name	Description
datasetReference	DatasetReference A fully-qualified identifier for the dataset. Must not be null.
options	ModifyLabelsOptions The options for the operation. May be null, in which case defaults will be supplied.

Returns
Type	Description
IDictionarystringstring	A dictionary with the labels on the dataset before they were cleared.

Overrides

BigQueryClient.ClearDatasetLabels(DatasetReference, ModifyLabelsOptions)

ClearDatasetLabelsAsync(DatasetReference, ModifyLabelsOptions, CancellationToken)

public override Task<IDictionary<string, string>> ClearDatasetLabelsAsync(DatasetReference datasetReference, ModifyLabelsOptions options = null, CancellationToken cancellationToken = default)

Asynchronously clears all labels on the specified dataset.

Parameters
Name	Description
datasetReference	DatasetReference A fully-qualified identifier for the dataset. Must not be null.
options	ModifyLabelsOptions The options for the operation. May be null, in which case defaults will be supplied.
cancellationToken	CancellationToken The token to monitor for cancellation requests.

Returns
Type	Description
TaskIDictionarystringstring	A task representing the asynchronous operation. When complete, the result is a dictionary with the labels on the dataset before they were cleared.

Overrides

BigQueryClient.ClearDatasetLabelsAsync(DatasetReference, ModifyLabelsOptions, CancellationToken)

CreateCopyJob(IEnumerable<TableReference>, TableReference, CreateCopyJobOptions)

public override BigQueryJob CreateCopyJob(IEnumerable<TableReference> sources, TableReference destination, CreateCopyJobOptions options = null)

Creates a job to copy data from at least one table to another.

Parameters
Name	Description
sources	IEnumerableTableReference The source tables to copy. Must not be null or empty.
destination	TableReference The destination to copy to. Must not be null.
options	CreateCopyJobOptions The options for the operation. May be null, in which case defaults will be supplied.

Returns
Type	Description
BigQueryJob	The job created for the copy operation.

Overrides

BigQueryClient.CreateCopyJob(IEnumerable<TableReference>, TableReference, CreateCopyJobOptions)

Remarks

To avoid confusion between source and destination tables, overloads are not provided that take the individual components of table references. Instead, use GetTableReference(string, string) or GetTableReference(string, string, string) to create table references.

CreateCopyJobAsync(IEnumerable<TableReference>, TableReference, CreateCopyJobOptions, CancellationToken)

public override Task<BigQueryJob> CreateCopyJobAsync(IEnumerable<TableReference> sources, TableReference destination, CreateCopyJobOptions options = null, CancellationToken cancellationToken = default)

Asynchronously creates a job to copy data from at least one table to another.

Parameters
Name	Description
sources	IEnumerableTableReference The source tables to copy. Must not be null or empty.
destination	TableReference The destination to copy to. Must not be null.
options	CreateCopyJobOptions The options for the operation. May be null, in which case defaults will be supplied.
cancellationToken	CancellationToken The token to monitor for cancellation requests.

Returns
Type	Description
TaskBigQueryJob	A task representing the asynchronous operation. When complete, the result is the job created for the copy operation.

Overrides

BigQueryClient.CreateCopyJobAsync(IEnumerable<TableReference>, TableReference, CreateCopyJobOptions, CancellationToken)

Remarks

To avoid confusion between source and destination tables, overloads are not provided that take the individual components of table references. Instead, use GetTableReference(string, string) or GetTableReference(string, string, string) to create table references.

CreateDataset(DatasetReference, Dataset, CreateDatasetOptions)

public override BigQueryDataset CreateDataset(DatasetReference datasetReference, Dataset resource = null, CreateDatasetOptions options = null)

Creates the specified dataset.

Parameters
Name	Description
datasetReference	DatasetReference A fully-qualified identifier for the dataset. Must not be null.
resource	Dataset The dataset resource representation to use for the creation. May be null in which case default values will be used.
options	CreateDatasetOptions The options for the operation. May be null, in which case defaults will be supplied.

Returns
Type	Description
BigQueryDataset	The created dataset.

Overrides

BigQueryClient.CreateDataset(DatasetReference, Dataset, CreateDatasetOptions)

Remarks

If resourceDatasetReference is specified, then it must be the same as the DatasetReference obtained from the other parameters.

CreateDatasetAsync(DatasetReference, Dataset, CreateDatasetOptions, CancellationToken)

public override Task<BigQueryDataset> CreateDatasetAsync(DatasetReference datasetReference, Dataset resource = null, CreateDatasetOptions options = null, CancellationToken cancellationToken = default)

Asynchronously creates the specified dataset.

Parameters
Name	Description
datasetReference	DatasetReference A fully-qualified identifier for the dataset. Must not be null.
resource	Dataset The dataset resource representation to use for the creation. May be null in which case default values will be used.
options	CreateDatasetOptions The options for the operation. May be null, in which case defaults will be supplied.
cancellationToken	CancellationToken The token to monitor for cancellation requests.

Returns
Type	Description
TaskBigQueryDataset	A task representing the asynchronous operation. When complete, the result is the created dataset.

Overrides

BigQueryClient.CreateDatasetAsync(DatasetReference, Dataset, CreateDatasetOptions, CancellationToken)

Remarks

If resourceDatasetReference is specified, then it must be the same as the DatasetReference obtained from the other parameters.

CreateExtractJob(TableReference, IEnumerable<string>, CreateExtractJobOptions)

public override BigQueryJob CreateExtractJob(TableReference tableReference, IEnumerable<string> destinationUris, CreateExtractJobOptions options = null)

Creates a job to extract data from the specified BigQuery table to Google Cloud Storage. See the BigQuery documentation for more information on extract jobs.

Parameters
Name	Description
tableReference	TableReference A fully-qualified identifier for the table. Must not be null.
destinationUris	IEnumerablestring The Google Cloud Storage URIs (possibly including a wildcard) to extract the data to. Must not be null or empty.
options	CreateExtractJobOptions The options for the operation. May be null, in which case defaults will be supplied.

Returns
Type	Description
BigQueryJob	The job created for the extract operation.

Overrides

BigQueryClient.CreateExtractJob(TableReference, IEnumerable<string>, CreateExtractJobOptions)

CreateExtractJobAsync(TableReference, IEnumerable<string>, CreateExtractJobOptions, CancellationToken)

public override Task<BigQueryJob> CreateExtractJobAsync(TableReference tableReference, IEnumerable<string> destinationUris, CreateExtractJobOptions options = null, CancellationToken cancellationToken = default)

Asynchronously creates a job to extract data from the specified BigQuery table to Google Cloud Storage. See the BigQuery documentation for more information on extract jobs.

Parameters
Name	Description
tableReference	TableReference A fully-qualified identifier for the table. Must not be null.
destinationUris	IEnumerablestring The Google Cloud Storage URIs (possibly including a wildcard) to extract the data to. Must not be null or empty.
options	CreateExtractJobOptions The options for the operation. May be null, in which case defaults will be supplied.
cancellationToken	CancellationToken The token to monitor for cancellation requests.

Returns
Type	Description
TaskBigQueryJob	A task representing the asynchronous operation. When complete, the result is the job created for the extract operation.

Overrides

BigQueryClient.CreateExtractJobAsync(TableReference, IEnumerable<string>, CreateExtractJobOptions, CancellationToken)

CreateLoadJob(IEnumerable<string>, TableReference, TableSchema, CreateLoadJobOptions)

public override BigQueryJob CreateLoadJob(IEnumerable<string> sourceUris, TableReference destination, TableSchema schema, CreateLoadJobOptions options = null)

Creates a job to load data from at least one Google Cloud Storage file to a BigQuery table.

Parameters
Name	Description
sourceUris	IEnumerablestring The Google Cloud Storage URIs of the files to load. Must not be null or empty.
destination	TableReference The destination table to write data to. Must not be null.
schema	TableSchema The schema for the table. May be null if the load operation does not require a schema, such as if the table already exists, the data is being loaded from a Google Cloud Datastore backup, or if the options are set to autodetect the schema.
options	CreateLoadJobOptions The options for the operation. May be null, in which case defaults will be supplied.

Returns
Type	Description
BigQueryJob	The job created for the load operation.

Overrides

BigQueryClient.CreateLoadJob(IEnumerable<string>, TableReference, TableSchema, CreateLoadJobOptions)

Remarks

To avoid confusion between source and destination tables, overloads are not provided that take the individual components of table references. Instead, use GetTableReference(string, string) or GetTableReference(string, string, string) to create table references.

CreateLoadJobAsync(IEnumerable<string>, TableReference, TableSchema, CreateLoadJobOptions, CancellationToken)

public override Task<BigQueryJob> CreateLoadJobAsync(IEnumerable<string> sourceUris, TableReference destination, TableSchema schema, CreateLoadJobOptions options = null, CancellationToken cancellationToken = default)

Asynchronously creates a job to load data from at least one Google Cloud Storage file to a BigQuery table.

Parameters
Name	Description
sourceUris	IEnumerablestring The Google Cloud Storage URIs of the files to load. Must not be null or empty.
destination	TableReference The destination table to write data to. Must not be null.
schema	TableSchema The schema for the table. May be null if the load operation does not require a schema, such as if the table already exists, the data is being loaded from a Google Cloud Datastore backup, or if the options are set to autodetect the schema.
options	CreateLoadJobOptions The options for the operation. May be null, in which case defaults will be supplied.
cancellationToken	CancellationToken The token to monitor for cancellation requests.

Returns
Type	Description
TaskBigQueryJob	A task representing the asynchronous operation. When complete, the result is the job created for the load operation.

Overrides

BigQueryClient.CreateLoadJobAsync(IEnumerable<string>, TableReference, TableSchema, CreateLoadJobOptions, CancellationToken)

Remarks

To avoid confusion between source and destination tables, overloads are not provided that take the individual components of table references. Instead, use GetTableReference(string, string) or GetTableReference(string, string, string) to create table references.

CreateModelExtractJob(ModelReference, IEnumerable<string>, CreateModelExtractJobOptions)

public override BigQueryJob CreateModelExtractJob(ModelReference modelReference, IEnumerable<string> destinationUris, CreateModelExtractJobOptions options = null)

Creates a job to extract the specified BigQuery model to Google Cloud Storage. See the BigQuery documentation for more information on model extract jobs.

Parameters
Name	Description
modelReference	ModelReference A fully-qualified identifier for the model. Must not be null.
destinationUris	IEnumerablestring The Google Cloud Storage URIs (possibly including a wildcard) to extract the model to. Must not be null or empty.
options	CreateModelExtractJobOptions The options for the operation. May be null, in which case defaults will be supplied.

Returns
Type	Description
BigQueryJob	The job created for the extract operation.

Overrides

BigQueryClient.CreateModelExtractJob(ModelReference, IEnumerable<string>, CreateModelExtractJobOptions)

CreateModelExtractJobAsync(ModelReference, IEnumerable<string>, CreateModelExtractJobOptions, CancellationToken)

public override Task<BigQueryJob> CreateModelExtractJobAsync(ModelReference modelReference, IEnumerable<string> destinationUris, CreateModelExtractJobOptions options = null, CancellationToken cancellationToken = default)

Asynchronously creates a job to extract the specified BigQuery model to Google Cloud Storage. See the BigQuery documentation for more information on model extract jobs.

Parameters
Name	Description
modelReference	ModelReference A fully-qualified identifier for the model. Must not be null.
destinationUris	IEnumerablestring The Google Cloud Storage URIs (possibly including a wildcard) to extract the model to. Must not be null or empty.
options	CreateModelExtractJobOptions The options for the operation. May be null, in which case defaults will be supplied.
cancellationToken	CancellationToken The token to monitor for cancellation requests.

Returns
Type	Description
TaskBigQueryJob	A task representing the asynchronous operation. When complete, the result is the job created for the extract operation.

Overrides

BigQueryClient.CreateModelExtractJobAsync(ModelReference, IEnumerable<string>, CreateModelExtractJobOptions, CancellationToken)

CreateQueryJob(string, IEnumerable<BigQueryParameter>, QueryOptions)

public override BigQueryJob CreateQueryJob(string sql, IEnumerable<BigQueryParameter> parameters, QueryOptions options = null)

Creates a job for a SQL query.

Parameters
Name	Description
sql	string The SQL query. Must not be null.
parameters	IEnumerableBigQueryParameter The parameters for the query. May be null, which is equivalent to specifying an empty list of parameters. Must not contain null elements.
options	QueryOptions The options for the operation. May be null, in which case defaults will be supplied.

Returns
Type	Description
BigQueryJob	The query job created. Use GetQueryResults(JobReference, GetQueryResultsOptions) to retrieve the results of the query.

Overrides

BigQueryClient.CreateQueryJob(string, IEnumerable<BigQueryParameter>, QueryOptions)

CreateQueryJobAsync(string, IEnumerable<BigQueryParameter>, QueryOptions, CancellationToken)

public override Task<BigQueryJob> CreateQueryJobAsync(string sql, IEnumerable<BigQueryParameter> parameters, QueryOptions options = null, CancellationToken cancellationToken = default)

Asynchronously creates a job for a SQL query.

Parameters
Name	Description
sql	string The SQL query. Must not be null.
parameters	IEnumerableBigQueryParameter The parameters for the query. May be null, which is equivalent to specifying an empty list of parameters. Must not contain null elements.
options	QueryOptions The options for the operation. May be null, in which case defaults will be supplied.
cancellationToken	CancellationToken The token to monitor for cancellation requests.

Returns
Type	Description
TaskBigQueryJob	A task representing the asynchronous operation. When complete, the result is the query job created. Use GetQueryResultsAsync(JobReference, GetQueryResultsOptions, CancellationToken) to retrieve the results of the query.

Overrides

BigQueryClient.CreateQueryJobAsync(string, IEnumerable<BigQueryParameter>, QueryOptions, CancellationToken)

CreateRoutine(RoutineReference, Routine, CreateRoutineOptions)

public override BigQueryRoutine CreateRoutine(RoutineReference routineReference, Routine resource, CreateRoutineOptions options = null)

Creates the specified routine.

Parameters
Name	Description
routineReference	RoutineReference A fully-qualified identifier for the routine. Must not be null.
resource	Routine The routine resource representation to use for the creation. Must not be null. If this routine's RoutineReference is specified, then it must be the same as the one obtained from the other parameters, else it will be set to the one obtained from the other parameters.
options	CreateRoutineOptions The options for the operation. May be null, in which case defaults will be supplied.

Returns
Type	Description
BigQueryRoutine	The newly created routine.

Overrides

BigQueryClient.CreateRoutine(RoutineReference, Routine, CreateRoutineOptions)

CreateRoutineAsync(RoutineReference, Routine, CreateRoutineOptions, CancellationToken)

public override Task<BigQueryRoutine> CreateRoutineAsync(RoutineReference routineReference, Routine resource, CreateRoutineOptions options = null, CancellationToken cancellationToken = default)

Asynchronously creates the specified routine.

Parameters
Name	Description
routineReference	RoutineReference A fully-qualified identifier for the routine. Must not be null.
resource	Routine The routine resource representation to use for the creation. Must not be null. If this routine's RoutineReference is specified, then it must be the same as the one obtained from the other parameters, else it will be set to the one obtained from the other parameters.
options	CreateRoutineOptions The options for the operation. May be null, in which case defaults will be supplied.
cancellationToken