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.
BigQueryDryRunResult
BigQueryFactory	An interface for BigQuery factories.
BigQueryResult<T>
BigQueryResultStats
Connection	A Connection is a session between a Java application and BigQuery.
LoadConfiguration	Common interface for a load configuration.
LoadConfiguration.Builder

Class Summary

Class	Description
Acl	Access Control for a BigQuery Dataset.
Acl.DatasetAclEntity	Class for a BigQuery DatasetAclEntity ACL entity.
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.IamMember	Class for a BigQuery IamMember entity.
Acl.Role	Dataset roles supported by BigQuery.
Acl.Routine	Class for a BigQuery Routine entity.
Acl.User	Class for a BigQuery User entity.
Acl.View	Class for a BigQuery View entity.
AvroOptions	Google BigQuery options for AVRO format.
AvroOptions.Builder
BiEngineReason
BiEngineReason.Builder
BiEngineStats	BIEngineStatistics contains query statistics specific to the use of BI Engine.
BiEngineStats.Builder
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.IAMOption
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.
BigQueryDryRunResultImpl
BigQueryError	Google Cloud BigQuery Error.
BigQueryErrorMessages
BigQueryOptions
BigQueryOptions.Builder
BigQueryOptions.DefaultBigQueryFactory
BigQueryOptions.DefaultBigQueryRpcFactory
BigQueryResultImpl<T>
BigQueryResultStatsImpl
BigQueryRetryAlgorithm<ResponseT>
BigQueryRetryConfig
BigQueryRetryConfig.Builder
BigQueryRetryHelper
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.
CloneDefinition
CloneDefinition.Builder
Clustering
Clustering.Builder
ConnectionProperty
ConnectionProperty.Builder	A builder for ConnectionProperty objects.
ConnectionSettings	ConnectionSettings for setting up a BigQuery query connection.
ConnectionSettings.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
DmlStats	Represents DML statistics information.
DmlStats.Builder
EmptyTableResult
EncryptionConfiguration
EncryptionConfiguration.Builder
ExecuteSelectResponse
ExecuteSelectResponse.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
HivePartitioningOptions	HivePartitioningOptions currently supported types include: AVRO, CSV, JSON, ORC and Parquet.
HivePartitioningOptions.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.ReservationUsage	ReservationUsage contains information about a job's usage of a single reservation.
JobStatistics.ReservationUsage.Builder
JobStatistics.ScriptStatistics	A Google BigQuery Script statistics.
JobStatistics.ScriptStatistics.ScriptStackFrame
JobStatistics.SessionInfo
JobStatistics.SessionInfo.Builder
JobStatistics.TransactionInfo
JobStatistics.TransactionInfo.Builder
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
MaterializedViewDefinition
MaterializedViewDefinition.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
Parameter
Parameter.Builder
ParquetOptions
ParquetOptions.Builder	A builder for ParquetOptions objects.
PolicyTags
PolicyTags.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.
ReadClientConnectionConfiguration	Represents BigQueryStorage Read client connection information.
ReadClientConnectionConfiguration.Builder
RemoteFunctionOptions	Represents Remote Function Options.
RemoteFunctionOptions.Builder
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.
SnapshotTableDefinition
SnapshotTableDefinition.Builder
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
StandardSQLTableType	Represents Standard SQL table type information.
StandardSQLTableType.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	[Optional] The supported types are DAY, HOUR, MONTH, and YEAR, which will generate one partition per day, hour, month, and year, respectively.
UserDefinedFunction.Type	Type of user-defined function.

Exception Summary

Exception	Description
BigQueryException	BigQuery service exception.
BigQueryRetryHelper.BigQueryRetryHelperException
BigQuerySQLException	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 in Bigquery. For the complete source code see CreateTable.java.

  try {
       // Initialize client that will be used to send requests. This client only needs to be created
       // once, and can be reused for multiple requests.
       BigQuery bigquery = BigQueryOptions.getDefaultInstance().getService();

       TableId tableId = TableId.of(datasetName, tableName);
       TableDefinition tableDefinition = StandardTableDefinition.of(schema);
       TableInfo tableInfo = TableInfo.newBuilder(tableId, tableDefinition).build();

       bigquery.create(tableInfo);
       System.out.println("Table created successfully");
     } catch (BigQueryException e) {
       System.out.println("Table was not created. \n" + e.toString());
     }
 

See Also:

Google Cloud BigQuery