Google Cloud SQL Delete

Use this activity to execute an SQL Delete statement on a Google cloud SQL database instance. The Google Cloud SQL delete activity returns information in the form of rows based on the returning clause specified.

Configuration

The Configuration tab has the following fields:

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

Input Settings

The Input Settings tab has the following fields:

Field Description
Query An SQL statement used to delete record(s) from a table. You construct prepared SQL queries by using substitution variables (or parameters) of the form ? in the delete statement. Each substitution variable identifies an input parameter whose mapped value will be substituted into the substitution variable at runtime. User can reuse the substitution variable for the same input parameter elsewhere in the delete query.
The type information for the input parameters used in the WHERE and RETURNING clause is fetched from the database using the selected Google cloud SQL connection for the entered delete query. Also based on the output parameters used in the RETURNING clause, the corresponding type information is fetched from the database. Similarly, input and output fields in the Input and Output tabs of the activity are also populated based on the SQL Delete statement.
Note: Be sure to include the semicolon (;) at the end of the query. This activity expects a query to end with a semicolon to indicate the end of the query. A missing semicolon at the end of the query results in the query hanging.
The following examples represent delete queries: 
  • DELETE from employee where name = ?name returning id;

    For the above delete query, output field is generated for id (INT4) from the returning clause and input field is generated for name (VARCHAR). Also the mapped value for the field name is substituted into the substitution variable ?name. 

  • Delete from employee;

    For above delete query, no output and input would be generated, as there are no parameters and no returning clause.

Table Schema Displays the metadata of the SQL delete statement. This grid is provided for informational 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 delete query provided. The fields that were selected in the Input Settings tab will be 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.

Output

This tab displays the activity output schema in a tree structure format. The output of an activity is displayed for informational purposes only and cannot be modified or altered. The information in this schema varies depending on the fields that are selected in the Input Settings tab. The properties that are displayed in the Output tab schema correspond to the output of this activity and can be used as input by subsequent activities in the flow.