See: Description
| 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 | 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 | |
| ColumnReference | |
| ColumnReference.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).
|
| ForeignKey | |
| ForeignKey.Builder | |
| 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 | |
| PrimaryKey | |
| PrimaryKey.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. |
| TableConstraints | |
| TableConstraints.Builder | |
| 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 | 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.
|
| BigQuery.TableMetadataView |
Metadata of a BigQuery Table.
|
| 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 | Description |
|---|---|
| BigQueryException |
BigQuery service exception.
|
| BigQueryRetryHelper.BigQueryRetryHelperException | |
| BigQuerySQLException |
BigQuery service exception.
|
| JobException |
Exception describing a failure of a job.
|
A simple usage example showing how to create a table in Bigquery. For the complete source code see CreateTable.java.
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");
Copyright © 2023 Google LLC. All rights reserved.