Custom

Components that allow to create custom user-defined procedures and SQL queries in your workflows.

Call Procedure

Description

This component executes an arbitrary CALL SQL statement.

Use $a and $b as placeholders for the input table names (you can use one, both, or none of them), and '$output' as placeholder for the output table name.

The procedure that you are calling is responsible of creating the output table in the path stored in the '$output' variable.

The following is a valid example of code to use in this component:

CALL MY_PROCEDURE($a, 10, $output);

Inputs

• Source table [Table]

• Source table [Table]

• SQL CALL statement [String]

Outputs

• Result table [Table]

Custom SQL Select

Description

This component executes an arbitrary SELECT SQL statement.

A new table will be created from the result of the entered statement

Use $a and $b as placeholders for the input table names (you can use one, both, or none of them), and '$output' as placeholder for the output table name.

The following is a valid example of code to use in this component, which will generate a new table with an added area column (based on a column named 'geom'), with only the rows corresponding to the five largest geometries:

SELECT *, ST_AREA(geom) AS area FROM $a ORDER BY area LIMIT 5

Inputs

• Source table [Table]

• Source table [Table]

• SQL SELECT statement [String]

Outputs

• Result table [Table]