Class QueryJobConfiguration

    • Method Detail

      • allowLargeResults

        public Boolean allowLargeResults()
        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
      • createSession

        public Boolean createSession()
        Returns whether to create a new session.
        See Also:
        Create Sessions
      • getDefaultDataset

        public DatasetId getDefaultDataset()
        Returns the default dataset. This dataset is used for all unqualified table names used in the query.
      • getDestinationTable

        public 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.
      • getQuery

        public String getQuery()
        Returns the Google BigQuery SQL query.
      • getPositionalParameters

        public List<QueryParameterValue> getPositionalParameters()
        Returns the positional query parameters to use for the query.
      • getNamedParameters

        public Map<String,​QueryParameterValue> getNamedParameters()
        Returns the named query parameters to use for the query.
      • getTableDefinitions

        public 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.
      • dryRun

        public Boolean dryRun()
        Returns whether the job has to be dry run or not. If set, the job is not executed. 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.
      • useLegacySql

        public Boolean useLegacySql()
        Returns whether to use BigQuery's legacy SQL dialect for this query. By default this property is set to false. If set to false, the query will use BigQuery's Standard SQL. When set to false, the values of allowLargeResults() and flattenResults() are ignored; query will be run as if allowLargeResults() is true and flattenResults() is false. If set to null or true, legacy SQL dialect is used. This property is experimental and might be subject to change.
      • getMaximumBillingTier

        public Integer getMaximumBillingTier()
        Returns the optional billing tier limit for this job.
      • getMaximumBytesBilled

        public Long getMaximumBytesBilled()
        Returns the optional bytes billed limit for this job.
      • getSchemaUpdateOptions

        public 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.
      • getTimePartitioning

        public TimePartitioning getTimePartitioning()
        Returns the time partitioning specification for the destination table.
      • getClustering

        public Clustering getClustering()
        Returns the clustering specification for the destination table.
      • getJobTimeoutMs

        public Long getJobTimeoutMs()
        Returns the timeout associated with this job
      • getLabels

        public Map<String,​String> getLabels()
        Returns the labels associated with this job
      • getRangePartitioning

        public RangePartitioning getRangePartitioning()
        Returns the range partitioning specification for the table
      • getConnectionProperties

        public List<ConnectionProperty> getConnectionProperties()
        Returns the connection properties for connection string with this job
      • getMaxResults

        public Long getMaxResults()
        This is only supported in the fast query path [Optional] The maximum number of rows of data to return per page of results. Setting this flag to a small value such as 1000 and then paging through results might improve reliability when the query result set is large. In addition to this limit, responses are also limited to 10 MB. By default, there is no maximum row count, and only the byte limit applies.
        Returns:
        value or null for none
      • hashCode

        public int hashCode()
        Overrides:
        hashCode in class Object
      • of

        public static QueryJobConfiguration of​(String query)
        Returns a BigQuery Copy Job for the given the query to be run. Job's id is chosen by the service.