Id

String

No

Step identification string.

After Script

String

No

SQL script to execute after step processing is done.

Before Script

String

No

SQL script to execute before the step is run.

Data Source Name

String

Yes

Data source definition to use.

Include Empty

Boolean

Yes

If false, only input records that yield records in the SQL result set are sent to the output. If set to true, then the processed input row is sent to the output even if there are no entries in the result set. Default value: true.

Query

String

Yes

Select-like SQL query to execute.

Mappings

List of Column Mapping

Yes

Mappings that define where to map values read from the result set.