SearchTables.java - AWS Code Sample

SearchTables.java

SearchTables.java demonstrates how to search a set of tables based on properties.

Note

To run this Java (SDK V2) code example, ensure that you have set up your development environment, including your credentials. For more information, see AWS SDK for Java 2.x Developer Guide.

/* Copyright Amazon.com, Inc. or its affiliates. All Rights Reserved. SPDX-License-Identifier: Apache-2.0 */ package com.example.glue; import software.amazon.awssdk.regions.Region; import software.amazon.awssdk.services.glue.GlueClient; import software.amazon.awssdk.services.glue.model.GlueException; import software.amazon.awssdk.services.glue.model.SearchTablesRequest; import software.amazon.awssdk.services.glue.model.SearchTablesResponse; import software.amazon.awssdk.services.glue.model.Table; import java.util.List; /* * Before running this example, run a crawler to produce a table within a database. * * Also, ensure that you have setup your development environment, including your credentials. * * For information, see this documentation topic: * * https://docs.aws.amazon.com/sdk-for-java/latest/developer-guide/get-started.html */ public class SearchTables { public static void main(String[] args) { final String USAGE = "\n" + "Usage:\n" + " SearchTables <text>\n\n" + "Where:\n" + " text - a string used for a text search. \n"; if (args.length != 1) { System.out.println(USAGE); System.exit(1); } String text = args[0]; Region region = Region.US_EAST_1; GlueClient glueClient = GlueClient.builder() .region(region) .build(); searchGlueTable(glueClient, text); glueClient.close(); } public static void searchGlueTable(GlueClient glueClient, String text) { try { SearchTablesRequest tablesRequest = SearchTablesRequest.builder() .searchText(text) .resourceShareType("ALL") .maxResults(10) .build(); SearchTablesResponse tablesResponse = glueClient.searchTables(tablesRequest); List<Table> tables = tablesResponse.tableList(); for (Table table: tables) { System.out.println("Table name is : "+table.name()); System.out.println("Database name is : "+table.databaseName()); } } catch (GlueException e) { System.err.println(e.awsErrorDetails().errorMessage()); System.exit(1); } } }

Sample Details

Last tested: 11/04/2020

Author: scmacdon AWS

Type: full-example