Class ConnectionSettings (2.27.0)

public abstract class ConnectionSettings

ConnectionSettings for setting up a BigQuery query connection.

Inheritance

java.lang.Object > ConnectionSettings

Static Methods

newBuilder()

public static ConnectionSettings.Builder newBuilder()

Returns a builder for a ConnectionSettings object.

Returns
TypeDescription
ConnectionSettings.Builder

Methods

getAllowLargeResults()

public abstract Boolean getAllowLargeResults()

Returns whether the job is enabled to create arbitrarily large results. If true the query is allowed to create large results at a slight cost in performance. the query is allowed to create large results at a slight cost in performance. See Also: Returning Large Query Results

Returns
TypeDescription
Boolean

getClustering()

public abstract Clustering getClustering()

Returns the clustering specification for the destination table.

Returns
TypeDescription
Clustering

getConnectionProperties()

public abstract List<ConnectionProperty> getConnectionProperties()

Returns the connection properties for connection string with this query

Returns
TypeDescription
List<ConnectionProperty>

getCreateDisposition()

public abstract JobInfo.CreateDisposition getCreateDisposition()

Returns whether the job is allowed to create new tables. See Also: Create Disposition

Returns
TypeDescription
JobInfo.CreateDisposition

getCreateSession()

public abstract Boolean getCreateSession()

Returns whether to create a new session. See Also: Create Sessions

Returns
TypeDescription
Boolean

getDefaultDataset()

public abstract DatasetId getDefaultDataset()

Returns the default dataset

Returns
TypeDescription
DatasetId

getDestinationEncryptionConfiguration()

public abstract EncryptionConfiguration getDestinationEncryptionConfiguration()

Returns the custom encryption configuration (e.g., Cloud KMS keys)

Returns
TypeDescription
EncryptionConfiguration

getDestinationTable()

public abstract TableId getDestinationTable()

Returns the table where to put query results. If not provided a new table is created. This value is required if # allowLargeResults() is true.

Returns
TypeDescription
TableId

getFlattenResults()

public abstract Boolean getFlattenResults()

Returns whether nested and repeated fields should be flattened. If set to false ConnectionSettings.Builder#setAllowLargeResults(Boolean) must be true. See Also: Flatten

Returns
TypeDescription
Boolean

getJobTimeoutMs()

public abstract Long getJobTimeoutMs()

Returns the timeout associated with this job

Returns
TypeDescription
Long

getMaxResultPerPage()

public abstract Integer getMaxResultPerPage()
Returns
TypeDescription
Integer

getMaxResults()

public abstract Long getMaxResults()

Returns the maximum number of rows of data

Returns
TypeDescription
Long

getMaximumBillingTier()

public abstract Integer getMaximumBillingTier()

Returns the optional billing tier limit for this job.

Returns
TypeDescription
Integer

getMaximumBytesBilled()

public abstract Long getMaximumBytesBilled()

Returns the limits the bytes billed for this job

Returns
TypeDescription
Long

getMinResultSize()

public abstract Integer getMinResultSize()
Returns
TypeDescription
Integer

getNumBufferedRows()

public abstract Integer getNumBufferedRows()

Returns the number of rows of data to pre-fetch

Returns
TypeDescription
Integer

getPriority()

public abstract QueryJobConfiguration.Priority getPriority()

Returns the query priority.

Returns
TypeDescription
QueryJobConfiguration.Priority

getRangePartitioning()

public abstract RangePartitioning getRangePartitioning()

Returns the range partitioning specification for the table

Returns
TypeDescription
RangePartitioning

getRequestTimeout()

public abstract Long getRequestTimeout()

Returns the synchronous response timeoutMs associated with this query

Returns
TypeDescription
Long

getSchemaUpdateOptions()

public abstract List<JobInfo.SchemaUpdateOption> getSchemaUpdateOptions()

[Experimental] Returns options allowing the schema of the destination table to be updated as a side effect of the query job. Schema update options are supported in two cases: when writeDisposition is WRITE_APPEND; when writeDisposition is WRITE_TRUNCATE and the destination table is a partition of a table, specified by partition decorators. For normal tables, WRITE_TRUNCATE will always overwrite the schema.

Returns
TypeDescription
List<SchemaUpdateOption>

getTableDefinitions()

public abstract Map<String,ExternalTableDefinition> getTableDefinitions()

Returns the external tables definitions. If querying external data sources outside of BigQuery, this value describes the data format, location and other properties of the data sources. By defining these properties, the data sources can be queried as if they were standard BigQuery tables.

Returns
TypeDescription
Map<String,ExternalTableDefinition>

getTimePartitioning()

public abstract TimePartitioning getTimePartitioning()

Returns the time partitioning specification for the destination table.

Returns
TypeDescription
TimePartitioning

getTotalToPageRowCountRatio()

public abstract Integer getTotalToPageRowCountRatio()
Returns
TypeDescription
Integer

getUseQueryCache()

public abstract Boolean getUseQueryCache()

Returns whether to look for the result in the query cache

Returns
TypeDescription
Boolean

getUseReadAPI()

public abstract Boolean getUseReadAPI()

Returns useReadAPI flag, enabled by default. Read API will be used if the underlying conditions are satisfied and this flag is enabled

Returns
TypeDescription
Boolean

getUserDefinedFunctions()

public abstract List<UserDefinedFunction> getUserDefinedFunctions()

Returns user defined function resources that can be used by this query. Function resources can either be defined inline (UserDefinedFunction.Type#INLINE) or loaded from a Google Cloud Storage URI (UserDefinedFunction.Type#FROM_URI.

Returns
TypeDescription
List<UserDefinedFunction>

getWriteDisposition()

public abstract JobInfo.WriteDisposition getWriteDisposition()

Returns the action that should occur if the destination table already exists. See Also: Write Disposition

Returns
TypeDescription
JobInfo.WriteDisposition

toBuilder()

public abstract ConnectionSettings.Builder toBuilder()

Returns a builder pre-populated using the current values of this field.

Returns
TypeDescription
ConnectionSettings.Builder