The BigQueryDataSelector Activity

The data selector activity retrieves data from the Bigquery entities.

General

The General tab contains the following fields.

Field Module Property? Description
Name No The name to be displayed as the label for the activity in the process. For more information, see Entity Naming Conventions.
Configuration Resource Yes Shared configuration resource containing the information about the Google BigQuery connection.
Schema No The Selector schema which is configured with Google Bigquery table in the connection resource.

Description

On the Description tab, provide a short description for the activity.

Advanced

On the Advanced tab, provide the number of maximum rows. These rows are the maximum number of rows to retrieve for Select operation. You can chose from the following values:
  • Literal Value: This field accepts zero or positive integers. Negative value results into a fault.
  • Process Property
  • Module Property

Input

The Input tab displays the input schema of the activity as a tree structure. You must enter information as required for any mandatory fields.

Output

The Output tab shows the response of the invoked service. The Output tab displays the output schema of the activity as a tree structure. The output is read-only.
Field Description
STATUS SUCCESS if the SQL statement is executed successfully. FAILURE if an error occurs. Error details are stored in the ERROR_DESC field.
SQL The SQL string used to specify the SQL statement to be executed.
ERROR_DESC In case if the status is FAILURE, error description is stored here.
RETURN_VALUES The values returned by the SQL statement.

Fault

The Fault tab lists exceptions that are thrown by this activity. The following table lists the types of exceptions thrown by the BigQueryDataSelector activity:
Error Schema Element Datatype Description
BQException String It has a msg and msgCode field for the exception.
BQValidationException String It has a msg and msgCode field for the exception.
msg String The error message returned by the plug-in.
msgCode String The error code returned by the plug-in.