Greenplum Insert

Use this activity to insert records in the Greenplum database.

Configuration

The Configuration tab has the following fields.

Field Description
Connection Name of the PostgreSQL database connection from which to retrieve information. You can select a connection from the drop-down list.

Input Settings

The Input Settings tab has the following fields:

Field Description
Insert An SQL query used to insert a record in the table. You can construct prepared SQL queries by using substitution variables (or parameters) of the form ?<fieldname> in the insert query statement.
Each substitution variable identifies an input parameter. The mapped value of the input parameter is added in the substitution variable at run time. You can reuse the substitution variable for the same input parameter elsewhere in the query. Information about the type of input parameters used in the VALUES clause is fetched from the database by using the connection that you have selected for the insert query. Similarly, input fields on the Input tab of the activity are also populated based on the SQL Insert query.
Note: Include a semicolon (;) at the end of the query to indicate the end of the query. A missing semicolon at the end of the query results in syntax error.

The following example represents a typical insert query: 

INSERT INTO ADVISOR (s_id, i_id) VALUES (?s_id, ?i_id);
The insert query in this example does not have an output field. An input field is generated for s_id (VARCHAR) and i_id(VARCHAR) under the Values[] node as it is part of the values clause. Also, the mapped value for the s_id and i_id is substituted into the ?s_id and ?i_id substitution variable.
Fields The grid is provided for information purpose only.

Input

This tab displays the input schema of the activity in a tree structure format. The information in the schema varies based on the insert query provided. The fields that were selected on the Input Settings tab are available in the schema. You can either hard code the values or map them to a field from the output of a preceding activity in the flow using the Mapper.

Fields from the VALUES clause are displayed under the VALUES node in the input schema.

Output

This tab displays the output schema of the activity in a tree structure format. The information in the schema varies based on the insert query provided. The properties that are displayed on the Output tab schema correspond to the output of this activity and can be used as input by subsequent activities in the flow.

Related concepts
Related reference