Package com.google.cloud.bigquery.migration.v2alpha

Class SqlTranslationServiceClient

  • All Implemented Interfaces:
    com.google.api.gax.core.BackgroundResource, AutoCloseable
    @BetaApi
@Generated("by gapic-generator-java")
public class SqlTranslationServiceClient
extends Object
implements com.google.api.gax.core.BackgroundResource
    Service Description: Provides other SQL dialects to GoogleSQL translation operations.

    This class provides the ability to make remote calls to the backing service through method calls that map to API methods. Sample code to get started: 

    
 // This snippet has been automatically generated and should be regarded as a code template only.
 // It will require modifications to work:
 // - It may require correct/in-range values for request initialization.
 // - It may require specifying regional endpoints when creating the service client as shown in
 // https://cloud.google.com/java/docs/setup#configure_endpoints_for_the_client_library
 try (SqlTranslationServiceClient sqlTranslationServiceClient =
     SqlTranslationServiceClient.create()) {
   LocationName parent = LocationName.of("[PROJECT]", "[LOCATION]");
   TranslateQueryRequest.SqlTranslationSourceDialect sourceDialect =
       TranslateQueryRequest.SqlTranslationSourceDialect.forNumber(0);
   String query = "query107944136";
   TranslateQueryResponse response =
       sqlTranslationServiceClient.translateQuery(parent, sourceDialect, query);
 }

    Note: close() needs to be called on the SqlTranslationServiceClient object to clean up resources such as threads. In the example above, try-with-resources is used, which automatically calls close().

    The surface of this class includes several types of Java methods for each of the API's methods:

    1. A "flattened" method. With this type of method, the fields of the request type have been converted into function parameters. It may be the case that not all fields are available as parameters, and not every API method will have a flattened method entry point.
    2. A "request object" method. This type of method only takes one parameter, a request object, which must be constructed before the call. Not every API method will have a request object method.
    3. A "callable" method. This type of method takes no parameters and returns an immutable API callable object, which can be used to initiate calls to the service.

    See the individual methods for example code.

    Many parameters require resource names to be formatted in a particular way. To assist with these names, this class includes a format method for each type of name, and additionally a parse method to extract the individual identifiers contained within names that are returned.

    This class can be customized by passing in a custom instance of SqlTranslationServiceSettings to create(). For example:

    To customize credentials: 

    
 // This snippet has been automatically generated and should be regarded as a code template only.
 // It will require modifications to work:
 // - It may require correct/in-range values for request initialization.
 // - It may require specifying regional endpoints when creating the service client as shown in
 // https://cloud.google.com/java/docs/setup#configure_endpoints_for_the_client_library
 SqlTranslationServiceSettings sqlTranslationServiceSettings =
     SqlTranslationServiceSettings.newBuilder()
         .setCredentialsProvider(FixedCredentialsProvider.create(myCredentials))
         .build();
 SqlTranslationServiceClient sqlTranslationServiceClient =
     SqlTranslationServiceClient.create(sqlTranslationServiceSettings);

    To customize the endpoint: 

    
 // This snippet has been automatically generated and should be regarded as a code template only.
 // It will require modifications to work:
 // - It may require correct/in-range values for request initialization.
 // - It may require specifying regional endpoints when creating the service client as shown in
 // https://cloud.google.com/java/docs/setup#configure_endpoints_for_the_client_library
 SqlTranslationServiceSettings sqlTranslationServiceSettings =
     SqlTranslationServiceSettings.newBuilder().setEndpoint(myEndpoint).build();
 SqlTranslationServiceClient sqlTranslationServiceClient =
     SqlTranslationServiceClient.create(sqlTranslationServiceSettings);

    To use REST (HTTP1.1/JSON) transport (instead of gRPC) for sending and receiving requests over the wire: 

    
 // This snippet has been automatically generated and should be regarded as a code template only.
 // It will require modifications to work:
 // - It may require correct/in-range values for request initialization.
 // - It may require specifying regional endpoints when creating the service client as shown in
 // https://cloud.google.com/java/docs/setup#configure_endpoints_for_the_client_library
 SqlTranslationServiceSettings sqlTranslationServiceSettings =
     SqlTranslationServiceSettings.newHttpJsonBuilder().build();
 SqlTranslationServiceClient sqlTranslationServiceClient =
     SqlTranslationServiceClient.create(sqlTranslationServiceSettings);

    Please refer to the GitHub repository's samples for more quickstart code snippets.

    • Constructor Detail

      • SqlTranslationServiceClient

        protected SqlTranslationServiceClient​(SqlTranslationServiceSettings settings)
                               throws IOException
        Constructs an instance of SqlTranslationServiceClient, using the given settings. This is protected so that it is easy to make a subclass, but otherwise, the static factory methods should be preferred.
        Throws:
        IOException

    • Method Detail

      • create

        public static final SqlTranslationServiceClient create​(SqlTranslationServiceStub stub)
        Constructs an instance of SqlTranslationServiceClient, using the given stub for making calls. This is for advanced usage - prefer using create(SqlTranslationServiceSettings).

      • translateQuery

        public final TranslateQueryResponse translateQuery​(LocationName parent,
                                                   TranslateQueryRequest.SqlTranslationSourceDialect sourceDialect,
                                                   String query)
        Translates input queries from source dialects to GoogleSQL.

        Sample code: 

        
 // This snippet has been automatically generated and should be regarded as a code template only.
 // It will require modifications to work:
 // - It may require correct/in-range values for request initialization.
 // - It may require specifying regional endpoints when creating the service client as shown in
 // https://cloud.google.com/java/docs/setup#configure_endpoints_for_the_client_library
 try (SqlTranslationServiceClient sqlTranslationServiceClient =
     SqlTranslationServiceClient.create()) {
   LocationName parent = LocationName.of("[PROJECT]", "[LOCATION]");
   TranslateQueryRequest.SqlTranslationSourceDialect sourceDialect =
       TranslateQueryRequest.SqlTranslationSourceDialect.forNumber(0);
   String query = "query107944136";
   TranslateQueryResponse response =
       sqlTranslationServiceClient.translateQuery(parent, sourceDialect, query);
 }
        Parameters:
        parent - Required. The name of the project to which this translation request belongs. Example: `projects/foo/locations/bar`
        sourceDialect - Required. The source SQL dialect of `queries`.
        query - Required. The query to be translated.
        Throws:
        com.google.api.gax.rpc.ApiException - if the remote call fails

      • translateQuery

        public final TranslateQueryResponse translateQuery​(String parent,
                                                   TranslateQueryRequest.SqlTranslationSourceDialect sourceDialect,
                                                   String query)
        Translates input queries from source dialects to GoogleSQL.

        Sample code: 

        
 // This snippet has been automatically generated and should be regarded as a code template only.
 // It will require modifications to work:
 // - It may require correct/in-range values for request initialization.
 // - It may require specifying regional endpoints when creating the service client as shown in
 // https://cloud.google.com/java/docs/setup#configure_endpoints_for_the_client_library
 try (SqlTranslationServiceClient sqlTranslationServiceClient =
     SqlTranslationServiceClient.create()) {
   String parent = LocationName.of("[PROJECT]", "[LOCATION]").toString();
   TranslateQueryRequest.SqlTranslationSourceDialect sourceDialect =
       TranslateQueryRequest.SqlTranslationSourceDialect.forNumber(0);
   String query = "query107944136";
   TranslateQueryResponse response =
       sqlTranslationServiceClient.translateQuery(parent, sourceDialect, query);
 }
        Parameters:
        parent - Required. The name of the project to which this translation request belongs. Example: `projects/foo/locations/bar`
        sourceDialect - Required. The source SQL dialect of `queries`.
        query - Required. The query to be translated.
        Throws:
        com.google.api.gax.rpc.ApiException - if the remote call fails

      • translateQuery

        public final TranslateQueryResponse translateQuery​(TranslateQueryRequest request)
        Translates input queries from source dialects to GoogleSQL.

        Sample code: 

        
 // This snippet has been automatically generated and should be regarded as a code template only.
 // It will require modifications to work:
 // - It may require correct/in-range values for request initialization.
 // - It may require specifying regional endpoints when creating the service client as shown in
 // https://cloud.google.com/java/docs/setup#configure_endpoints_for_the_client_library
 try (SqlTranslationServiceClient sqlTranslationServiceClient =
     SqlTranslationServiceClient.create()) {
   TranslateQueryRequest request =
       TranslateQueryRequest.newBuilder()
           .setParent(LocationName.of("[PROJECT]", "[LOCATION]").toString())
           .setQuery("query107944136")
           .build();
   TranslateQueryResponse response = sqlTranslationServiceClient.translateQuery(request);
 }
        Parameters:
        request - The request object containing all of the parameters for the API call.
        Throws:
        com.google.api.gax.rpc.ApiException - if the remote call fails

      • translateQueryCallable

        public final com.google.api.gax.rpc.UnaryCallable<TranslateQueryRequest,​TranslateQueryResponse> translateQueryCallable()
        Translates input queries from source dialects to GoogleSQL.

        Sample code: 

        
 // This snippet has been automatically generated and should be regarded as a code template only.
 // It will require modifications to work:
 // - It may require correct/in-range values for request initialization.
 // - It may require specifying regional endpoints when creating the service client as shown in
 // https://cloud.google.com/java/docs/setup#configure_endpoints_for_the_client_library
 try (SqlTranslationServiceClient sqlTranslationServiceClient =
     SqlTranslationServiceClient.create()) {
   TranslateQueryRequest request =
       TranslateQueryRequest.newBuilder()
           .setParent(LocationName.of("[PROJECT]", "[LOCATION]").toString())
           .setQuery("query107944136")
           .build();
   ApiFuture<TranslateQueryResponse> future =
       sqlTranslationServiceClient.translateQueryCallable().futureCall(request);
   // Do something.
   TranslateQueryResponse response = future.get();
 }

      • shutdown

        public void shutdown()
        Specified by:
        shutdown in interface com.google.api.gax.core.BackgroundResource

      • isShutdown

        public boolean isShutdown()
        Specified by:
        isShutdown in interface com.google.api.gax.core.BackgroundResource

      • isTerminated

        public boolean isTerminated()
        Specified by:
        isTerminated in interface com.google.api.gax.core.BackgroundResource

      • shutdownNow

        public void shutdownNow()
        Specified by:
        shutdownNow in interface com.google.api.gax.core.BackgroundResource