SQL Transform helps to import a schema in your dataflow that can act as a source.
Create a new batch job, add a workflow and dataflow. In your dataflow, drag the SQL transform from the local object library. You can find it under the ‘Platform’ set of transforms.
Double click on the transform.
(Refer post Validation Transform to create the required tables in the database)
Select your datastore, write a simple select statement accessing a table already imported in your datastore. Click on ‘Update Schema’.
Observe that now the schema appears on the top window.
Add a query transform and add the columns required to the output schema. Join this with a target template table. Save and execute your job.
This transform is particularly useful when you want only a particular set of data from the database table and push it to target level.