Google BigQuery v2 API - Class QueryOptions (3.10.0)

public sealed class QueryOptions : JobCreationOptions

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

Options for CreateQueryJob and ExecuteQuery operations.

Inheritance

object > JobCreationOptions > QueryOptions

Namespace

Google.Cloud.BigQuery.V2

Assembly

Google.Cloud.BigQuery.V2.dll

Properties

AllowLargeResults

public bool? AllowLargeResults { get; set; }

If true, allows the query to produce arbitrarily large result sets at a slight cost in performance. DestinationTable must be set in order to use this option.

Property Value
Type Description
bool

ConfigurationModifier

public Action<JobConfigurationQuery> ConfigurationModifier { get; set; }

Optional action to perform after preparing the request. If this property is non-null, the JobConfigurationQuery used for a request will be passed to the delegate before the request is executed. This allows for fine-grained modifications which aren't otherwise directly supported by the properties in this options type.

Property Value
Type Description
ActionJobConfigurationQuery
Remarks

Prefer the properties on this type over this modifier to prepare the request. Only use this modifier to configure aspects for which there are no properties available. This modifier is applied to the request after all properties on this type have been applied. The delegate is only called once per operation, even if the request is automatically retried.

CreateDisposition

public CreateDisposition? CreateDisposition { get; set; }

Specifies whether the operation is allowed to create new tables. If not set, this is effectively CreateIfNeeded.

Property Value
Type Description
CreateDisposition

DefaultDataset

public DatasetReference DefaultDataset { get; set; }

The default dataset to assume for any unqualified table names in the query. If this is not set, all table names must be fully qualified.

Property Value
Type Description
DatasetReference

DestinationEncryptionConfiguration

public EncryptionConfiguration DestinationEncryptionConfiguration { get; set; }

The encryption configuratoin to apply to the destination table, if any.

Property Value
Type Description
EncryptionConfiguration

DestinationSchemaUpdateOptions

public SchemaUpdateOption? DestinationSchemaUpdateOptions { get; set; }

Allows the schema of the DestinationTable to be updated as a side effect of the query job. Schema update options are supported in two cases: when WriteDisposition is WriteAppend; when WriteDisposition is WriteTruncate and the destination table is a partition of a table, specified by partition decorators. SchemaUpdateOption is marked with the FlagsAttribute so several flags can be specified.

Property Value
Type Description
SchemaUpdateOption

DestinationTable

public TableReference DestinationTable { get; set; }

A destination table to write the results into. If this is not specified, the results will be stored in a temporary table.

Property Value
Type Description
TableReference

DryRun

public bool? DryRun { get; set; }

If set to true, don't actually run this job. A valid query will return a mostly empty response with some processing statistics, while an invalid query will return the same error it would if it wasn't a dry run. This option can be used to determine the schema of the query without running it. The resulting BigQueryJob has no job ID, so cannot be polled for completion, but the Resource contains all the information returned by the server.

Property Value
Type Description
bool

FlattenResults

public bool? FlattenResults { get; set; }

Flattens all nested and repeated fields in the query results. If not set, this is effectively true. If this is set to false, DestinationTable must be specified and AllowLargeResults must be set to true.

Property Value
Type Description
bool

MaximumBillingTier

public int? MaximumBillingTier { get; set; }

Limits the billing tier of the job. If the query uses resources beyond this tier, it will fail. If not set, this is effectively the project default.

Property Value
Type Description
int

MaximumBytesBilled

public long? MaximumBytesBilled { get; set; }

Limits the bytes billed for this job. Queries that will have bytes billed beyond this limit will fail (without incurring a charge). If not set, this is effectively the project default.

Property Value
Type Description
long

ParameterMode

public BigQueryParameterMode? ParameterMode { get; set; }

If set, determines whether parameters are named or positional. If not set, this will default to named parameters. When named parameters are used, all parameters must have a name. When positional parameters are used, parameters may still have names, but don't have to.

Property Value
Type Description
BigQueryParameterMode

Priority

public QueryPriority? Priority { get; set; }

The priority of the query.

Property Value
Type Description
QueryPriority

TimePartitioning

public TimePartitioning TimePartitioning { get; set; }

The time partitioning to apply, if any. See TimePartition to create instances of TimePartitioning.

Property Value
Type Description
TimePartitioning

UseLegacySql

public bool? UseLegacySql { get; set; }

Set to true to use legacy SQL instead of standard SQL.

Property Value
Type Description
bool

UseQueryCache

public bool? UseQueryCache { get; set; }

Whether to look for the result in the query cache. If not set, this is effectively true.

Property Value
Type Description
bool

WriteDisposition

public WriteDisposition? WriteDisposition { get; set; }

Specifies the behavior if the destination table exists. If not set, this is effectively WriteIfEmpty.

Property Value
Type Description
WriteDisposition