static void addJsonbColumn() throws InterruptedException, ExecutionException {

// TODO(developer): Replace these variables before running the sample.

String projectId = "my-project";

String instanceId = "my-instance";

String databaseId = "my-database";

addJsonbColumn(projectId, instanceId, databaseId);

}

static void addJsonbColumn(String projectId, String instanceId, String databaseId)

throws InterruptedException, ExecutionException {

try (Spanner spanner =

SpannerOptions.newBuilder()

.setProjectId(projectId)

.build()

.getService();

DatabaseAdminClient databaseAdminClient = spanner.createDatabaseAdminClient()) {

// JSONB datatype is only supported with PostgreSQL-dialect databases.

// Wait for the operation to finish.

// This will throw an ExecutionException if the operation fails.

databaseAdminClient.updateDatabaseDdlAsync(

DatabaseName.of(projectId, instanceId, databaseId),

ImmutableList.of("ALTER TABLE Venues ADD COLUMN VenueDetails JSONB")).get();

System.out.printf("Successfully added column `VenueDetails`%n");

}

}