Execute Select SQL

Operation Name

Execute Select SQL

Function Overview

On Google BigQuery, write data to a table using an SQL statement.

Properties

For details on using variables, refer to "Variables".
Basic Settings
Item name Required/Optional Use of variables Description Remarks
Name Required Not Available Enter the name on the script canvas.  
Required Settings
Item name Required/Optional Use of variables Description Remarks
Destination Required Not Available Select Global Resources.
  • [Add]:
    Adds new global resource.
  • [Edit list]:
    Global resource settings can be edited by "Edit resource list".
 
Project ID Required Available Select or enter the project ID.  
SQL statement Required Available Enter the SQL statement to be issued to Google BigQuery.
  • For more details on executable SQL statements other than the SELECT statement, contact Google.
Dataset name of the save destination Required Available Select or enter the dataset name of the table where the query result is to be stored.  
Table name of the save destination Required Available Select or enter the table name where the query result is to be stored.  
Property Action
Item name Description Remarks
Update the list of project IDs Get projects in the specified destination, and set them to [Project ID].
  • If [Destination] is specified/edited, or projects have been added/edited on Google BigQuery, you can apply the changes by using this property action.
Update the list of dataset names of the save destination Get datasets in the specified project, and set them in [Dataset name of the save destination].
  • If [Project ID] is specified/edited, or a dataset has been added/edited on Google BigQuery, you can apply the changes by using this property action.
  • Disabled if variable is set to [Project ID].
Update the list of table names of the save destination Get tables in the specified dataset, and set them in [Table name of the save destination].
  • If [Dataset name of the save destination] is specified/edited, or a table has been added/edited on Google BigQuery, you can apply the changes by using this property action.
  • Disabled if variable is set to [Project ID] or [Dataset name of the save destination].
Write Settings
Item name Required/Optional Use of variables Description Remarks
Write settings of destination tables Required Not Available Select an option to use when writing.
  • [Add to table]: (default)
    Add data to the end of an existing table.
  • [Overwrite table]:
    Delete all the data in the write destination table, and write data.
 
Comment
Item name Required/Optional Use of variables Description Remarks
Comment Optional Not Available You can write a short description of this adapter.
The description will be applied in the specifications.		  

Schema

Input Schema

None

Output Schema

None

Transaction

Transaction is not supported.

PSP Usage

PSP cannot be used.

Available Component Variables

Component variable name Description Remarks
message_category When an error occurs, the category of the message code corresponding to the error that occurred is stored.
  • The default value is null.
message_code When an error occurs, the code of the message code corresponding to the error that occurred is stored.
  • The default value is null.
message_level When an error occurs, the severity of the message code corresponding to the error that occurred is stored.
  • The default value is null.
error_type When an error occurs, the type of error that occurred is stored.
  • The default value is null.
  • Error type is in the following format:
    Example: "java.io.FileNotFoundException"
  • The contents to be stored may vary depending on the version of DataSpider Servista.
error_message When an error occurs, the message of the error that occurred is stored.
  • The default value is null.
  • The contents to be stored may vary depending on the version of DataSpider Servista.
error_trace When an error occurs, the trace information of the error that occurred is stored.
  • The default value is null.
  • The contents to be stored may vary depending on the version and client applications of DataSpider Servista.

Specification Limits

Major Exceptions

Exception Name Cause Solution
ResourceNotFoundException
Resource definition is not found. Name:[]		 [Destination] is not specified. Specify [Destination].
ResourceNotFoundException
Resource definition is not found. Name:[<Name of global resources>]		 Resource definition selected in [Destination] is not found. Check the global resource specified in [Destination].
InvalidPropertyConfigurationException
<property name> is not specified.		 [<Property name>] is not specified. Specify [<Property name>].
InvalidCredentialException
A service account authentication key is incorrect.		 [<Service account authentication key>] in [<Destination>] is incorrect. Confirm [<Service account authentication key>] in [<Destination>].
BigQueryServiceException
Failed to execute the job.		 Failed to execute the job. Identify the cause of the error by referring to the error logs, and resolve the problem.
BigQueryServiceException
Failed in the operation for Google BigQuery.		 Failed in the operation for Google BigQuery Identify the cause of the error from the status code and error code by referring to the error message list page of Google BigQuery (https://cloud.google.com/bigquery/docs/error-messages), and then resolve the problem.
ResourceManagerServiceException Failed in the operation for Google Resource Manager. Identify the cause of the error from the status code and error code by referring to the error message list page of Google Resource Manager (https://cloud.google.com/resource-manager/docs/core_errors), and then resolve the problem.

Notes