Google Cloud BigQuery Client for Java

Java idiomatic client for Cloud BigQuery.

• Product Documentation
• Client Library Documentation

Quickstart

If you are using Maven with BOM, add this to your pom.xml file

<!-- Using libraries-bom to manage versions.See https://github.com/GoogleCloudPlatform/cloud-opensource-java/wiki/The-Google-Cloud-Platform-Libraries-BOM -->
<dependencyManagement>
<dependencies>
<dependency>
<groupId>com.google.cloud</groupId>
<artifactId>libraries-bom</artifactId>
<version>8.0.0</version>
<type>pom</type>
<scope>import</scope>
</dependency>
</dependencies>
</dependencyManagement>
<dependencies>
<dependency>
<groupId>com.google.cloud</groupId>
<artifactId>google-cloud-bigquery</artifactId>
</dependency>

If you are using Maven without BOM, add this to your dependencies:

<dependency>
<groupId>com.google.cloud</groupId>
<artifactId>google-cloud-bigquery</artifactId>
<version>1.116.3</version>
</dependency>

If you are using Gradle, add this to your dependencies

compile 'com.google.cloud:google-cloud-bigquery:1.116.3'

If you are using SBT, add this to your dependencies

libraryDependencies +="com.google.cloud"%"google-cloud-bigquery"%"1.116.3"

Authentication

See the Authentication section in the base directory's README.

Getting Started

Prerequisites

You will need a Google Cloud Platform Console project with the Cloud BigQuery API enabled. You will need to enable billing to use Google Cloud BigQuery. Follow these instructions to get your project set up. You will also need to set up the local development environment by installing the Google Cloud SDK and running the following commands in command line: gcloud auth login and gcloud config set project [YOUR PROJECT ID].

Installation and setup

You'll need to obtain the google-cloud-bigquery library. See the Quickstart section to add google-cloud-bigquery as a dependency in your code.

About Cloud BigQuery

Cloud BigQuery is a fully managed, NoOps, low cost data analytics service. Data can be streamed into BigQuery at millions of rows per second to enable real-time analysis. With BigQuery you can easily deploy Petabyte-scale Databases.

See the Cloud BigQuery client library docs to learn how to use this Cloud BigQuery Client Library.

Creating a dataset

With BigQuery you can create datasets. A dataset is a grouping mechanism that holds zero or more tables. Add the following import at the top of your file:

importcom.google.cloud.bigquery.DatasetInfo;

Then, to create the dataset, use the following code:

// Create a datasetStringdatasetId = "my_dataset_id";
bigquery.create(DatasetInfo.newBuilder(datasetId).build());

Creating a table

With BigQuery you can create different types of tables: normal tables with an associated schema, external tables backed by data stored on Google Cloud Storage and view tables that are created from a BigQuery SQL query. In this code snippet we show how to create a normal table with only one string field. Add the following imports at the top of your file:

importcom.google.cloud.bigquery.Field;
importcom.google.cloud.bigquery.Schema;
importcom.google.cloud.bigquery.StandardTableDefinition;
importcom.google.cloud.bigquery.Table;
importcom.google.cloud.bigquery.TableId;
importcom.google.cloud.bigquery.TableInfo;

Then add the following code to create the table:

TableIdtableId = TableId.of(datasetId, "my_table_id");
// Table field definitionFieldstringField = Field.of("StringField", LegacySQLTypeName.STRING);
// Table schema definitionSchemaschema = Schema.of(stringField);
// Create a tableStandardTableDefinitiontableDefinition = StandardTableDefinition.of(schema);
TablecreatedTable = bigquery.create(TableInfo.of(tableId, tableDefinition));

Loading data into a table

BigQuery provides several ways to load data into a table: streaming rows or loading data from a Google Cloud Storage file. In this code snippet we show how to stream rows into a table. Add the following imports at the top of your file:

importcom.google.cloud.bigquery.InsertAllRequest;
importcom.google.cloud.bigquery.InsertAllResponse;
importjava.util.HashMap;
importjava.util.Map;

Then add the following code to insert data:

Map<String, Object> firstRow = newHashMap<>();
Map<String, Object> secondRow = newHashMap<>();
firstRow.put("StringField", "value1");
secondRow.put("StringField", "value2");
// Create an insert requestInsertAllRequestinsertRequest = InsertAllRequest.newBuilder(tableId)
.addRow(firstRow)
.addRow(secondRow)
.build();
// Insert rowsInsertAllResponseinsertResponse = bigquery.insertAll(insertRequest);
// Check if errors occurredif (insertResponse.hasErrors()) {
System.out.println("Errors occurred while inserting rows");
}

Querying data

BigQuery enables querying data by running queries and waiting for the result. Queries can be run directly or through a Query Job. In this code snippet we show how to run a query directly and wait for the result. Add the following imports at the top of your file:

importcom.google.cloud.bigquery.FieldValueList;
importcom.google.cloud.bigquery.QueryJobConfiguration;

Then add the following code to run the query and wait for the result:

// Create a query requestQueryJobConfigurationqueryConfig =
QueryJobConfiguration.newBuilder("SELECT my_column FROM my_dataset_id.my_table_id").build();
// Read rowsSystem.out.println("Table rows:");
for (FieldValueListrow : bigquery.query(queryConfig).iterateAll()) {
System.out.println(row);
}

Complete source code

In InsertDataAndQueryTable.java we put together all the code shown above into one program. The program assumes that you are running on Compute Engine or from your own desktop. To run the example on App Engine, simply move the code from the main method to your application's servlet class and change the print statements to display on your webpage.

Samples

Samples are in the samples/ directory. The samples' README.md has instructions for running the samples.

Sample	Source Code	Try it
Add Column Load Append	source code
Add Empty Column	source code
Auth Drive Scope	source code
Auth Snippets	source code
Browse Table	source code
Cancel Job	source code
Copy Multiple Tables	source code
Copy Table	source code
Create Clustered Table	source code
Create Dataset	source code
Create Job	source code
Create Model	source code
Create Partitioned Table	source code
Create Range Partitioned Table	source code
Create Routine	source code
Create Routine DDL	source code
Create Table	source code
Create Table Without Schema	source code
Create View	source code
Dataset Exists	source code
Delete Dataset	source code
Delete Model	source code
Delete Routine	source code
Delete Table	source code
Extract Table To Csv	source code
Extract Table To Json	source code
Get Dataset Info	source code
Get Job	source code
Get Model	source code
Get Routine	source code
Get Table	source code
Get View	source code
Inserting Data Types	source code
List Datasets	source code
List Models	source code
List Tables	source code
Load Csv From Gcs	source code
Load Csv From Gcs Truncate	source code
Load Local File	source code
Load Parquet	source code
Load Parquet Replace Table	source code
Load Partitioned Table	source code
Load Table Clustered	source code
Nested Repeated Schema	source code
Query	source code
Query Batch	source code
Query Clustered Table	source code
Query With Named Parameters	source code
Query With Positional Parameters	source code
Query With Structs Parameters	source code
Quickstart Sample	source code
Relax Column Mode	source code
Relax Table Query	source code
Run Legacy Query	source code
Save Query To Table	source code
Simple App	source code
Simple Query	source code
Table Insert Rows	source code
Update Dataset Access	source code
Update Dataset Description	source code
Update Dataset Expiration	source code
Update Table DML	source code
Update Table Description	source code
Update Table Expiration	source code

Troubleshooting

To get help, follow the instructions in the shared Troubleshooting document.

Java Versions

Java 7 or above is required for using this client.

Versioning

This library follows Semantic Versioning.

Contributing

Contributions to this library are always welcome and highly encouraged.

See CONTRIBUTING for more information how to get started.

Please note that this project is released with a Contributor Code of Conduct. By participating in this project you agree to abide by its terms. See Code of Conduct for more information.

License

Apache 2.0 - See LICENSE for more information.

CI Status

Java Version	Status
Java 7
Java 8
Java 8 OSX
Java 8 Windows
Java 11