Package com.google.cloud.bigquery

A client for BigQuery – A fully managed, petabyte scale, low cost enterprise data warehouse for analytics.

See: Description

Interface Summary

Interface	Description
BigQuery	An interface for Google Cloud BigQuery.
BigQueryFactory	An interface for BigQuery factories.
LoadConfiguration	Common interface for a load configuration.
LoadConfiguration.Builder

Class Summary

Class	Description
Acl	Access Control for a BigQuery Dataset.
Acl.Domain	Class for a BigQuery Domain entity.
Acl.Entity	Base class for BigQuery entities that can be grant access to the dataset.
Acl.Group	Class for a BigQuery Group entity.
Acl.Role	Dataset roles supported by BigQuery.
Acl.User	Class for a BigQuery User entity.
Acl.View	Class for a BigQuery View entity.
BigQuery.DatasetDeleteOption	Class for specifying dataset delete options.
BigQuery.DatasetListOption	Class for specifying dataset list options.
BigQuery.DatasetOption	Class for specifying dataset get, create and update options.
BigQuery.JobListOption	Class for specifying job list options.
BigQuery.JobOption	Class for specifying table get and create options.
BigQuery.ModelListOption	Class for specifying table list options.
BigQuery.ModelOption	Class for specifying model get, create and update options.
BigQuery.QueryOption
BigQuery.QueryResultsOption	Class for specifying query results options.
BigQuery.RoutineListOption	Class for specifying routine list options.
BigQuery.RoutineOption	Class for specifying table get, create and update options.
BigQuery.TableDataListOption	Class for specifying table data list options.
BigQuery.TableListOption	Class for specifying table list options.
BigQuery.TableOption	Class for specifying table get, create and update options.
BigQueryError	Google Cloud BigQuery Error.
BigQueryOptions
BigQueryOptions.Builder
BigQueryOptions.DefaultBigQueryFactory
BigQueryOptions.DefaultBigQueryRpcFactory
BigtableColumn
BigtableColumn.Builder
BigtableColumnFamily	List of column families to expose in the table schema along with their types.
BigtableColumnFamily.Builder
BigtableOptions
BigtableOptions.Builder	A builder for BigtableOptions objects.
Clustering
Clustering.Builder
CopyJobConfiguration	Google BigQuery copy job configuration.
CopyJobConfiguration.Builder
CsvOptions	Google BigQuery options for CSV format.
CsvOptions.Builder
Dataset	A Google BigQuery Dataset.
Dataset.Builder	A builder for Dataset objects.
DatasetId	Google BigQuery Dataset identity.
DatasetInfo	Google BigQuery Dataset information.
DatasetInfo.Builder	A builder for DatasetInfo objects.
DatastoreBackupOptions	Google BigQuery options for Cloud Datastore backup.
DatastoreBackupOptions.Builder
EmptyTableResult
EncryptionConfiguration
EncryptionConfiguration.Builder
ExternalTableDefinition	Google BigQuery external table definition.
ExternalTableDefinition.Builder
ExtractJobConfiguration	Google BigQuery extract job configuration.
ExtractJobConfiguration.Builder
Field	Google BigQuery Table schema field.
Field.Builder
FieldList	Google BigQuery Table schema fields (columns).
FieldValue	Google BigQuery Table Field Value class.
FieldValueList	Google BigQuery Table Field Values class, which represents a row in returned query result (table row).
FormatOptions	Base class for Google BigQuery format options.
GoogleSheetsOptions	Google BigQuery options for the Google Sheets format.
GoogleSheetsOptions.Builder
InsertAllRequest	Google Cloud BigQuery insert all request.
InsertAllRequest.Builder
InsertAllRequest.RowToInsert	A Google Big Query row to be inserted into a table.
InsertAllResponse	Google Cloud BigQuery insert all response.
Job	A Google BigQuery Job.
Job.Builder	A builder for Job objects.
JobConfiguration	Base class for a BigQuery job configuration.
JobConfiguration.Builder<T extends JobConfiguration,B extends JobConfiguration.Builder<T,B>>	Base builder for job configurations.
JobId	Google BigQuery Job identity.
JobId.Builder
JobInfo	Google BigQuery Job information.
JobInfo.Builder	A builder for JobInfo objects.
JobStatistics	A Google BigQuery Job statistics.
JobStatistics.CopyStatistics	A Google BigQuery Copy Job statistics.
JobStatistics.ExtractStatistics	A Google BigQuery Extract Job statistics.
JobStatistics.LoadStatistics	A Google BigQuery Load Job statistics.
JobStatistics.QueryStatistics	A Google BigQuery Query Job statistics.
JobStatistics.QueryStatistics.StatementType	StatementType represents possible types of SQL statements reported as part of the QueryStatistics of a BigQuery job.
JobStatistics.ScriptStatistics	A Google BigQuery Script statistics.
JobStatistics.ScriptStatistics.ScriptStackFrame
JobStatus	A Google BigQuery Job status.
JobStatus.State	Possible states that a BigQuery Job can assume.
LegacySQLTypeName	A type used in legacy SQL contexts.
LoadJobConfiguration	Google BigQuery load job configuration.
LoadJobConfiguration.Builder
Model	A Google BigQuery ML Model.
Model.Builder
ModelId
ModelInfo	Google BigQuery ML model information.
ModelInfo.Builder	A builder for ModelInfo objects.
ModelTableDefinition	A Google BigQuery Model table definition.
ModelTableDefinition.Builder
QueryJobConfiguration	Google BigQuery Query Job configuration.
QueryJobConfiguration.Builder
QueryParameterValue	A value for a QueryParameter along with its type.
QueryParameterValue.Builder
QueryResponse
QueryStage	BigQuery provides diagnostic information about a completed query's execution plan (or query plan for short).
QueryStage.QueryStep	Each query stage is made of a number of steps.
RangePartitioning
RangePartitioning.Builder	A builder for RangePartitioning objects.
RangePartitioning.Range
RangePartitioning.Range.Builder	A builder for Range objects.
Routine	A Google BigQuery Routine.
Routine.Builder
RoutineArgument	An argument for a BigQuery Routine.
RoutineArgument.Builder
RoutineId	RoutineId represents the identifier for a given Routine.
RoutineInfo	Google BigQuery routine information.
RoutineInfo.Builder
Schema	This class represents the schema for a Google BigQuery Table or data source.
StandardSQLDataType	Represents Standard SQL data type information.
StandardSQLDataType.Builder
StandardSQLField	A Google BigQuery SQL Field.
StandardSQLField.Builder
StandardSQLStructType	A set of fields contained within a SQL STRUCT in Google BigQuery.
StandardSQLStructType.Builder
StandardTableDefinition	A Google BigQuery default table definition.
StandardTableDefinition.Builder
StandardTableDefinition.StreamingBuffer	Google BigQuery Table's Streaming Buffer information.
Table	A Google BigQuery Table.
Table.Builder	A builder for Table objects.
TableDataWriteChannel	WriteChannel implementation to stream data into a BigQuery table.
TableDefinition	Base class for a Google BigQuery table definition.
TableDefinition.Builder<T extends TableDefinition,B extends TableDefinition.Builder<T,B>>	Base builder for table definitions.
TableDefinition.Type	The table type.
TableId	Google BigQuery Table identity.
TableInfo	Google BigQuery table information.
TableInfo.Builder	A builder for TableInfo objects.
TableResult
TimelineSample	A specific timeline sample.
TimelineSample.Builder
TimePartitioning	Objects of this class allow to configure table partitioning based on time.
TimePartitioning.Builder
UserDefinedFunction	Google BigQuery User Defined Function.
ViewDefinition	Google BigQuery view table definition.
ViewDefinition.Builder
WriteChannelConfiguration	Google BigQuery Configuration for a load operation.
WriteChannelConfiguration.Builder

Enum Summary

Enum	Description
Acl.Entity.Type	Types of BigQuery entities.
BigQuery.DatasetField	Fields of a BigQuery Dataset resource.
BigQuery.JobField	Fields of a BigQuery Job resource.
BigQuery.ModelField	Fields of a BigQuery Model resource.
BigQuery.RoutineField	Fields of a BigQuery Routine resource.
BigQuery.TableField	Fields of a BigQuery Table resource.
Field.Mode	Mode for a BigQuery Table field.
FieldValue.Attribute	The field value's attribute, giving information on the field's content type.
JobConfiguration.Type	Type of a BigQuery Job.
JobInfo.CreateDisposition	Specifies whether the job is allowed to create new tables.
JobInfo.SchemaUpdateOption	Specifies options relating to allowing the schema of the destination table to be updated as a side effect of the load or query job.
JobInfo.WriteDisposition	Specifies the action that occurs if the destination table already exists.
QueryJobConfiguration.Priority	Priority levels for a query.
StandardSQLTypeName	A type used in standard SQL contexts.
TimePartitioning.Type	The type of time partitioning.
UserDefinedFunction.Type	Type of user-defined function.

Exception Summary

Exception	Description
BigQueryException	BigQuery service exception.
JobException	Exception describing a failure of a job.

Package com.google.cloud.bigquery Description

A client for BigQuery – A fully managed, petabyte scale, low cost enterprise data warehouse for analytics.

A simple usage example showing how to create a table if it does not exist and load data into it. For the complete source code see CreateTableAndLoadData.java.

 BigQuery bigquery = BigQueryOptions.getDefaultInstance().getService();
 TableId tableId = TableId.of("dataset", "table");
 Table table = bigquery.getTable(tableId);
 if (table == null) {
   System.out.println("Creating table " + tableId);
   Field integerField = Field.of("fieldName", Field.Type.integer());
   Schema schema = Schema.of(integerField);
   table = bigquery.create(TableInfo.of(tableId, StandardTableDefinition.of(schema)));
 }
 System.out.println("Loading data into table " + tableId);
 Job loadJob = table.load(FormatOptions.csv(), "gs://bucket/path");
 loadJob = loadJob.waitFor();
 if (loadJob.getStatus().getError() != null) {
   System.out.println("Job completed with errors");
 } else {
   System.out.println("Job succeeded");
 }
 

See Also:

Google Cloud BigQuery