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 for 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`);
Please take into account that $a, $b and $output
will be parsed directly as they are. In some cases, the table names that work as input/output need to be quoted differently depending on the data warehouse. Users need to ensure the correct quoting, like `$output`
or "$a"
.
Due to Redshift limitations, calling stored procedures that have INOUT string parameters will cause an exception when running the workflow. Stored procedures with such parameters are not supported.
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, $b and $c as placeholders for the input table names (you can use one, all, or none of them).
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
Please take into account that $a, $b and $c
will be parsed directly as they are. In some cases, they will need to be quoted differently depending on the data warehouse. Users need to ensure the correct quoting, like '$a'
or "$a"
.
Inputs
Source table [Table]
Source table [Table]
SQL SELECT statement [String]
Outputs
Result table [Table]
Last updated